Try:
($select_total_rows == 0)
instead.
That and maybe echo $select_total_rows; to see what
it's returning.
--- Mike Tuller <[EMAIL PROTECTED]> wrote:
> I can't get mysql_num_rows to work for some reason.
> Here is a snippet
> of what I have
>
>
> $department_name = $_POST['department_name'];
>
> $select_query = "SELECT * WHERE department_name =
> '$department_name'";
> $select_result = mysql_query($select_query,
> $db_connect);
> $select_total_rows = mysql_num_rows($select_result);
>
> if ($select_total_rows<1)
> {
> $insert_query = " insert into departments
> (department_name)
>
> values
>
> ('$department_name')";
>
>
> mysql_query($insert_query, $db_connect) or die
> (mysql_error());
>
__________________________________________________
Do you Yahoo!?
Yahoo! Tax Center - File online, calculators, forms, and more
http://tax.yahoo.com
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
