Justtechjobs.com Find a programming school near you






Online Campus Both


php3-list | 199901

RE: [PHP3] Boggle From: Numard (numard <email protected>)
Date: 01/23/99

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

hi!
long time i don't use db without phplib, but....
WHERE are you running the query?????
let's see.
On 23-Jan-99 Matthew Joseff wrote:
> $there="SELECT * from $userstable where firstname=('$firstname') and
> mname_lname=('$mname_lname') and email=('$email')";
^^^ sql statment
> $result=MYSQL_NUM_ROWS($there);
^^^ mysql_num_rows takes 1 paramater,
that is the connection id that you got previously in a mysql_query.

IOW,

$there = "select.......blah,blah";
$conn = mysql_query($there);
if(mysql_num_rows($conn) > 0){
        echo "we found ......blah,blah";
} else {
        echo "ok";
}
regards
- ---
Norberto Meijome (a) Numard - PGP public key: pgp-numy <email protected>
It is better to travel hopefully than to fly Continental.

-----BEGIN PGP SIGNATURE-----
Version: PGPfreeware 5.0i for non-commercial use
Charset: noconv

iQA/AwUBNqp1Spnsv7B51ReCEQKm9ACfSn43G1CDVz10h40+t9tkD8DgqukAn2zf
xBpf/50rOcmn/Au6MT2dXjKm
=VrwV
-----END PGP SIGNATURE----- 

--
PHP 3 Mailing List   http://www.php.net/
To unsubscribe send an empty message to php3-unsubscribe <email protected>
To subscribe to the digest list:  php3-digest-subscribe <email protected>
For help: php3-help <email protected>  Archive:  http://www.php.net/mailsearch.php3
List administrator:  zeev-list-admin <email protected>