Re: Detecting empty query result?
| From: | * R&zE: | Date: | Tue, 21 Aug 2001 13:56:15 +0000 |
| Subject: | Re: Detecting empty query result? | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-63703@lists.php.net to get a copy of this message | ||
On Tue, Aug 21, 2001 at 02:54:33PM +0100, Seb Frost wrote:
> Basically I want to check to see if $fileDir is already in my database. I
> do this as:
>
> $result = mysql_query("SELECT fileDir FROM shoots WHERE
> (fileDir='$fileDir')");
>
> How do I check the result? I normally use
>
> mysql_result($result, $row, $field)
>
> to read my result, but if I try that I get an error:
>
> if(mysql_result($result, $row, $field))
>
> gives me:
>
> Warning: Unable to jump to row 0 on MySQL result index 3
>
>
> cheers,
>
> - seb
You're looking for: msql_num_rows()
Try:
http://www.php.net/manual/en/function.msql-num-rows.php
--
* R&zE:
-- »»»»»»»»»»»»»»»»»»»»»»»»
-- Renze Munnik
-- DataLink BV
--
-- E: renze@datalink.nl
-- W: +31 23 5326162
-- F: +31 23 5322144
-- M: +31 6 21811143
--
-- Stationsplein 82
-- 2011 LM HAARLEM
-- Netherlands
--
-- http://www.datalink.nl
-- ««««««««««««««««««««««««