Need help with this

[karimali831]

Can anyone see anything wrong with this?

$query = "SELECT id,alias FROM users ORDER by id DESC LIMIT 5"; 
$lastreg = mysql_query($query);
    while(list($id,$alias)=mysql_fetch_row($lastreg)){
        $lastreg=$lastreg."$out[bulletleft] $alias"; 
    }
    if(!$lastreg){
        $lastreg = "$out[bulletleft] No members yet"; //
    }

The limit is set on 5, but only 1 is being displayed. And not sure about this but when the the output is displayed, it will show "Resource id... followed by the output" not sure how to change resource id either

[karimali831]

hmm HTML works in [code] tags?

[karimali831]

One last thing, if you go to at the top you can see there is an offer running off this script:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/sites/online/public_html/home.php on line 62

Link 62 =

while(list($id,$alias)=mysql_fetch_row($lastreg)){

That might help.

[scottie2212]

Originally Posted by karimali831

Can anyone see anything wrong with this?

$query = "SELECT id,alias FROM users ORDER by id DESC LIMIT 5"; 
 // $lastreg is a the resource id
$lastreg = mysql_query($query);
    while(list($id,$alias)=mysql_fetch_row($lastreg)){
 // now you are changing it but you're still in the loop
       $lastreg=$lastreg."$out[bulletleft] $alias"; 
    }
    if(!$lastreg){
        $lastreg = "$out[bulletleft] No members yet"; //
    }

The limit is set on 5, but only 1 is being displayed. And not sure about this but when the the output is displayed, it will show "Resource id... followed by the output" not sure how to change resource id either

Your lastreg string is being changed from an sql resoucre id to a what looks like an output string.

This should work -

$query = "SELECT id,alias FROM users ORDER by id DESC LIMIT 5"; 
 // $lastreg1 is now the resource id
$lastreg1 = mysql_query($query);
    while(list($id,$alias)=mysql_fetch_row($lastreg1)){
        $lastreg=$lastreg."$out[bulletleft] $alias"; 
    }
    if(!$lastreg){
        $lastreg = "$out[bulletleft] No members yet"; //
    }

[karimali831]

It worked, thanks soo much!!

[karimali831]

Opz, remove this post please.