> 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: 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
>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
