Hi Peter,

I'm also sort of a beginner.

That's along the lines that I was thinking.

Doesn't mysql_query return a result set object.  So in this sample, wouldn't 
the IF be testing if the result object was set?

I'm just trying to learn what's going on, I realized the code is wrong but 
didn't know why, which is why I didn't respond earlier.

Gary

> -----Original Message-----
> From: Peter Westergaard [mailto:[EMAIL PROTECTED] Behalf Of
> Peter Westergaard
> Sent: Tue, January 08, 2008 11:09 AM
> To: php-db@lists.php.net
> Subject: [PHP-DB] Re: Beginners Problem
>
>
> Ben, I would say that the only reason
> > $select_sql_two = mysql_query($select_sql);
> >
> > if($select_sql_two) {
> >
>
> would refuse to execute is if $select_sql represents an invalid SQL
> statement.  Whether it has records or not, you should (if I'm
> not very
> much mistaken) get a resource returned in select_sql_two, which will
> make your IF succeed.
>
> You should probably check out http://php.net/mysql_query for more
> information on this function.  The difference between "empty
> result" and
> "invalid query" is significant.  Once you've determined that
> the query
> is valid, you must also then check to see if it returned any rows,
> possibly using a function like mysql_num_rows.
>
> Hope that helps!
> -P
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to