Loops killing MySQL queries?

[sorenchr]

Hi!

 

I have a simple script:

 

$query = mysql_query("SELECT * FROM users WHERE user='$username' ORDER BY user");

$userRange = range('A', 'Z');

foreach ($userRange as $sorter) {

while($output = mysql_fetch_assoc($query)) {

	$substr = substr($output['userdata'], 0, 1);

	if($substr == $sorter) {

		echo $output['userdata'];		

	}

        echo "<br>";

}

}

 

It creates a loop where it spits out the userdata designated to a given username in an alphabetical order. The problems I am experiencing, is that it only outputs the userdata starting with A, then the loop sort of kills the MySQL query. So in order to fix this problem, i have to create a new MySQL query for each new letter in the alphabet, which i am not interested in :/

 

So does anybody have a solution for maintaining the query for use in the loop?

[.josh]

just curious, but why don't you just do this?

 

$query = mysql_query("SELECT * FROM users WHERE user='$username' ORDER BY userdata");

while($output = mysql_fetch_assoc($query)) {
   echo $output['userdata'];
}

 

I mean, I'm assuming that user is unique, so I don't really see the point in ordering by user...

[sorenchr]

Because im so goddamn stupid Thank you for that quick answer

[.josh]

also you shouldn't use * in your select. you're only using userdata so just select userdata.

[sorenchr]

Hold on, now i remember why i created such a messy code, the problem was that i wanted to create a break(br) between each letter in alphabet. So that my data output would look something like this:

 

Userdata for testuser:

 

Aa

Ab

Ac

 

Ba

Bb

Bc

 

Ca

Cb

Cc

[.josh]

$query = mysql_query("SELECT * FROM users WHERE user='$username' ORDER BY userdata");

while($output = mysql_fetch_assoc($query)) {
   if (!$prev) $prev = substr($output['userdata'],0,1);
   echo $output['userdata'] . "<br />";
   $prev = substr($output['userdata'],0,1);
}

 

edited for: forgot to change it from my test loop vars to your vars