Fetch array problem

[smc]

Heya,

Alright basically I'm trying to create a listing of my usernames in the database. This is the code I am working with:

[code=php:0]
//Lets go ahead and connect to the DB using my fancy patent pending function (saves time doesn't it)
dbconnect();

//The following will execute a query to list all the users

//Query for execution
//$fetchfido = mysql_query("SELECT * FROM users ORDER BY username ASC");
$fetchfido = mysql_query('SELECT * FROM `users` ORDER BY `users` . `username` ASC');
//While we are grabbing the array we will go ahead and prep the HTML for echoing
while($users = mysql_fetch_array($fetchfido)){
$listusers = "<a href=\"admin.php?user=$users[username]\">$users[username]</a><br />";
$cms_template_path = '../templates/admin/';
require($cms_template_path . 'admin_users.php');
die;
}
[/code]

My problem is with the code above it only lists the first username and then stops. I tried taking out the die; function and it listed all the usernames, but also included a new template for every single specific username.

How can I get around this problem?

[Caesar]

Why are you executing the "die" function in your loop?  Just curious. ;) You're basically terminating your script after it outputs the first record.

Edit: Not sure what your template include is doing....but why not do the include outside of the loop?

[smc]

Because I want it to stop executing everything beneath that particular block of code

[craygo]

your sql statement may not be right

[code]$fetchfido = "SELECT * FROM `users` ORDER BY username ASC";[/code]

Also set the template path before the loop. not need to set it for every user in the table.
What is in the admin_users.php file???
The die function wil cause the loop to end the first time it runs through. Take it out and put the die after the loop.

Ray

[The Little Guy]

wouldn't die look like this:

die();

[smc]

[quote author=craygo link=topic=123881.msg512617#msg512617 date=1169670807]
your sql statement may not be right

[code]$fetchfido = "SELECT * FROM `users` ORDER BY username ASC";[/code]

Also set the template path before the loop. not need to set it for every user in the table.
What is in the admin_users.php file???
The die function wil cause the loop to end the first time it runs through. Take it out and put the die after the loop.

Ray
[/quote]

The admin_users.php file is the template file for admin_users.php script (both in different folders). admin_users.php template only has <? echo $listusers; ?>

And my problem is if I take die out then it will keep running and running, creating a template for every single user. If I put the require and die after the while script then it only shows the last user to be called in the array

[craygo]

Not to go around your problem here, but why would you call another file to echo our your results??

[code]<?php
$sql = "SELECT * FROM `users` ORDER BY username ASC";
$fetchfido = mysql_query($sql) or die(mysql_error());
while($users = mysql_fetch_array($fetchfido)){
echo "<a href=\"admin.php?user=".$users[username]."\">".$users[username]."</a><br />";
}
?>[/code]

Ray

[smc]

Because I want to put it in my style template to make it look nice. My PHP and Template files are completly seperate. Putting PHP integrated into HTML just causes to many mistakes, for me at least.