$result == "" means: Your SQL query is so f'ed up, I couldn't even run it.
It does NOT mean: Your query returned zero rows, a perfectly normal and common condition. You want http://php.net/mysql_num_rows And, actually, $result is FALSE, not really "", when the query is wrong. On Mon, April 9, 2007 4:18 pm, [EMAIL PROTECTED] wrote: > If I search for something in mysql that returns an empty result I cant > get > it to return > "No result found" always returns "Found" even though the recoed does > not > exist... > > > $sql = "SELECT Client FROM booked WHERE Name = 'larry'"; > > $result = mysql_query($sql); > > if ($result == "") > { > echo "No result found"; > } > echo "Found"; > > > ----- Original Message ----- > From: "Martin Marques" <martin@bugs.unl.edu.ar> > To: "Stut" <[EMAIL PROTECTED]> > Cc: "Tijnema !" <[EMAIL PROTECTED]>; "tedd" <[EMAIL PROTECTED]>; > "Peter > Lauri" <[EMAIL PROTECTED]>; "Ólafur Waage" <[EMAIL PROTECTED]>; > <php-general@lists.php.net> > Sent: Monday, April 09, 2007 9:45 PM > Subject: Re: [PHP] Session Authentication > > >> Stut escribió: >>> As with most things these days it probably breaches the DMCA. But >>> frankly >>> speaking, if doing that works then the developers of the >>> application, and >>> by extension the company, deserve everything they get. >> >> DMCA is a real piece of crap. >> >> -- >> select 'mmarques' || '@' || 'unl.edu.ar' AS email; >> --------------------------------------------------------- >> Martín Marqués | Programador, DBA >> Centro de Telemática | Administrador >> Universidad Nacional >> del Litoral >> --------------------------------------------------------- >> >> -- >> PHP General Mailing List (http://www.php.net/) >> To unsubscribe, visit: http://www.php.net/unsub.php >> >> >> > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- Some people have a "gift" link here. Know what I want? I want you to buy a CD from some indie artist. http://cdbaby.com/browse/from/lynch Yeah, I get a buck. So? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
