Re: [PHP] mysql if empty

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";

try this:

$sql = "SELECT Client FROM booked WHERE Name = 'larry'";
$result = mysql_query($sql);
if(mysql_num_rows($result) == 0)
{
echo "No result found";
}
else
{
$myresults = mysql_fetch_array($result);
}

-afan





----- Original Message -----
From: "Martin Marques" <martin@xxxxxxxxxxxxxxx>
To: "Stut" <stuttle@xxxxxxxxx>
Cc: "Tijnema !" <tijnema@xxxxxxxxx>; "tedd" <tedd@xxxxxxxxxxxx>; "Peter
Lauri" <lists@xxxxxxxxxxx>; "Ólafur Waage" <sinai@xxxxxxxxx>;
<php-general@xxxxxxxxxxxxx>
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


.

Relevant Pages

  • Re: [PHP] IPv6 validation
    ... echo "$ip is not a valid IP"; ... PHP General Mailing List ... I installed php5 on my local dev box years ago. ... my company to upgrade and fix code that busted in the transition. ...
    (php.general)
  • Re: [PHP] Bind IP with fsockopen
    ... echo $sock; //output reply?? ... >> I think im getting stuck on the fputs bit.. ... >> PHP General Mailing List ... >> To unsubscribe, visit: http://www.php.net/unsub.php ...
    (php.general)
  • mysql if empty
    ... If I search for something in mysql that returns an empty result I cant get it to return ... echo "No result found"; ... PHP General Mailing List ...
    (php.general)
  • Re: [PHP] mysql if empty
    ... echo "No result found"; ... Centro de Telemática | Administrador ... PHP General Mailing List ...
    (php.general)
  • Re: [PHP] mysql if empty
    ... This doesn't meant that the variable holding the reference to the result set is itself empty, but that you will fail to fetch any results from it. ... echo "No result found"; ... PHP General Mailing List ... To unsubscribe, visit: http://www.php.net/unsub.php ...
    (php.general)