Re: mysql if empty
| From: | Jim Lucas | Date: | Tue, 10 Apr 2007 16:53:22 +0000 |
| Subject: | Re: mysql if empty | ||
| References: | 1 2 3 4 5 6 7 8 9 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-252440@lists.php.net to get a copy of this message | ||
chris@aquanuke.com 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" <stuttle@gmail.com> Cc: "Tijnema !" <tijnema@gmail.com>; "tedd" <tedd@sperling.com>; "Peter Lauri" <lists@dwsasia.com>; "Ólafur Waage" <sinai@simnet.is>; <php-general@lists.php.net> Sent: Monday, April 09, 2007 9:45 PM Subject: Re: [PHP] Session Authentication$sql = "SELECT Client FROM booked WHERE Name = 'larry'"; $result = mysql_query($sql) OR die('[MYSQL ERROR] - ['.mysql_errno().']<br />'.mysql_error()); while ( list($client) = mysql_fetch_row($result) ) { echo "{$client}<br />\n"; } -- Enjoy, Jim Lucas Different eyes see different things. Different hearts beat on different strings. But there are times for you and me when all such things agree. - RushStut 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