running multiple mysql queries in a php page

[linux1880]

Hello friends.

 

do we need to name  $query and $result variable as $q1, $q2, $q3 and $r1, $r2.. when quering databse multiple times in single php page ?

 

I did run the queries 2 times in a php page, I could echo result from first query but not from second

[trq]

do we need to name  $query and $result variable as $q1, $q2, $q3 and $r1, $r2.. when quering databse multiple times in single php page ?

 

Depends entirely on your logic, but not usually.

[vero216]

Try not to make 2 or more queries in a script.Can you give a more detailed example.Mysql can be heavy duty if not used properly.