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: [EMAIL PROTECTED]
-- W: +31 23 5326162
-- F: +31 23 5322144
-- M: +31 6 21811143
--
-- Stationsplein 82
-- 2011 LM HAARLEM
-- Netherlands
--
-- http://www.datalink.nl
-- ««««««««««««««««««««««««
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]