[RESOLVED] Getting a Simple MySQL Result

[lupus2k5]

Hi,

This problem must be easy to solve, but I can't find it.
Here's my PHP/query:
$q = "SELECT ip FROM tbl_name WHERE id = '".$id."'";
$r = mysql_query($q);

The only way I know how to print the results is with a

while($row = mysql_fetch_row($r))
{
 echo $row[0];
}

I want to make a much simpler version of that, because I don't need a loop. Plus, the above doesn't work for me in this scenario for some reason.

This should be an easy answer.

Thanks.

[Pehape]

just remove the loop:
$row = mysql_fetch_row($r);
echo row[0];

hehehehe

[lupus2k5]

So without the loop I can just have
$r = mysql_query($r);
$row = mysql_fetch_row($r);
echo $row[0];
No other code?

Cool.

Thanks.

[Pehape]

yeah that's it since you only want to get one record (first record).
if you want to take the last record, use order field DESC on your query or you can also use mysql_data_seek()
you can also use mysql_fetch_array(), mysql_fetch_assoc() or mysql_fetch_object()