Simple PHP/MySQL question

programming
1

Hi there,

I have this query that I need 3 times in my PHP script. Currently I am getting arround this by doing 3 duplicate queries as follows:-

$result1 = mysql_query(“SELECT * FROM users WHERE id = ‘$id’”);
$result2 = mysql_query(“SELECT * FROM users WHERE id = ‘$id’”);
$result3 = mysql_query(“SELECT * FROM users WHERE id = ‘$id’”);

Then I access data with 3 while loops using 3 different results (as above): -

while ($row = mysql_fetch_object($result1)) {
echo $row->user_id;
echo $row->fullname;
}

while ($row = mysql_fetch_object($result2)) {
echo $row->user_id;
echo $row->fullname;
}

while ($row = mysql_fetch_object($result3)) {
echo $row->user_id;
echo $row->fullname;
}

I believe this to be not good practice. But if I try and do this with 1 query e.g. use only $result1 I get no data back in the second and third while loop. Its like the mysql query result can only be used once!

Anyone got a more tidy approach?

Maybe I should store in arrays, if so how?

Thanks in advance.

W Digital