[Resolved] Question about multiple querys

[VanPEP]

OK, since my version of MySQL dosent support sub querys, I need to make two seperate querys, now my question is, if i have for example:

$query = "SELECT * FROM db '";
$result = mysql_query($query) or die ("Query failed");
$numofrows = mysql_num_rows($result);
<<add rest of stuff here>>

Then later in the page I do another query i need to add a 2 on it like this

$query2 = "SELECT * FROM db '";
right?

So the should everything after that have a two on the end like

$query2 = "SELECT * FROM db '";
$result2 = mysql_query($query2) or die ("Query failed");
$numofrows2 = mysql_num_rows($result2);
<<add rest of stuff here>>

or will it just know that everything after query2 pertains to that query?

[nemonoman]

If you want to differentiate the results, then your $result-type variables need to be distinquished.

$query=("SELECT date()");
$DATEresult=mysql_query($query);
$query=("SELECT database()");
$DBresult=mysql_query($query);

$DATErow=mysql_fetch_array($DATEresult);
$DBrow=mysql_fetch_array($DBresult);

echo "Date was $DATErow[0], Database was $DBrow[0]";

[VanPEP]

ah that makes sense thanks! I think i understand it better now