Re: Are 2 mysql_query statements psble?
| From: | Tommy Jensehaugen | Date: | Fri, 10 Jan 2003 23:22:32 +0000 |
| Subject: | Re: Are 2 mysql_query statements psble? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-131205@lists.php.net to get a copy of this message | ||
i don't know if this is the most efficient way, but it'll work:
$query = "SELECT username FROM users WHERE username =
> '{$_POST['strUserName']}'";
$query2 = "SELECT Ngfnummer FROM lid WHERE Ngfnummer =
'{$_POST['strNgfnummer']}'";
if ( mysql_num_rows( mysql_query( $query ) ) == 0 && mysql_num_rows(
mysql_query( $query2 ) ) == 0 )
tommy
"Wmb" <wmb@euronet.nl> wrote in message
news:20030110231245.36334.qmail@pb1.pair.com...
> The code below returns : "Parse error: parse error, unexpected
T_BOOLEAN_AND
> ".....
> so must assume it's not possible, but anybody out there who's able to give
> me a suggestion how to get this going.
> 2 different tables have to be checked for correct input from form.
>
> (Would even want to do a third....)
>
> Thanks,
> Martin
>
> QUOTE+++++++++++++++++
> if($dbConn)
> $query = mysql_query("SELECT count(*) FROM users WHERE username =
> '{$_POST['strUserName']}'");
> $query2 = mysql_query("SELECT count(*) FROM lid WHERE Ngfnummer =
> '{$_POST['strNgfnummer']}'");
>
> if(mysql_result($query, 0, 0) == 0) && (mysql_result($query2, 0,
> 0) == 0)
> {
> UNQUOTE+++++++++++++++++
>
>