Question regarding SQL

[Manat]

$result = mysql_query($sql) or die(mysql_error());

If I have many SQL statements in the same script, can I have as many $result = mysql_query($sql) or die(mysql_error()); a I want?

Or should I be calling subsequent SQLs $result2?

Thanks
mk

[nemonoman]

$result1=mysql_query($query1);
$result2=mysql_query($query2);
.
.
.
$resultN=mysql_query($queryN);

etc.

There's probably some top limit on the number of result resources available, but I haven't hit it, as I've worked with 4 results as my maximum.

[________]

You don't have to name it $result1, $result2 and so on.
I name them according to the function I need it for, eg.:

$CheckUser = mysql_query($query);