Multiple WHERE statements and numrows()

[Abersparky]

Can anyone help me out here...

I can't quite seem to get this right. I have a table of which I need
to extract data based on two fields: entry_id and vis. The below
results in error. When I remove the second condition from the WHERE
statement, it counts the entry id as "comnumrows".

Is my SELECT statement wrong???

$comvis = "N";
$comquery = mysql_query("SELECT * FROM comments WHERE (entry_id =
$id AND vis = $comvis)");
$comquery_data = mysql_fetch_row($comquery );
$comnumrows = $comquery_data[0];
print $comnumrows . " comments";

[Jeff North]

On 26 Feb 2007 21:31:38 -0800, in comp.lang.php "Abersparky"
<ab********@gmail.com>
<11*********************@k78g2000cwa.googlegroups. comwrote:

>| Can anyone help me out here...
|
| I can't quite seem to get this right. I have a table of which I need
| to extract data based on two fields: entry_id and vis. The below
| results in error. When I remove the second condition from the WHERE
| statement, it counts the entry id as "comnumrows".
|
| Is my SELECT statement wrong???
|
| $comvis = "N";
| $comquery = mysql_query("SELECT * FROM comments WHERE (entry_id =
| $id AND vis = $comvis)");

vis = '$comvis')");
because the variable is a string/char

>| $comquery_data = mysql_fetch_row($comquery );
| $comnumrows = $comquery_data[0];
| print $comnumrows . " comments";

---------------------------------------------------------------
jn******@yourpantsyahoo.com.au : Remove your pants to reply
---------------------------------------------------------------

[Toby A Inkster]

Jeff North wrote:

jn******@yourpantsyahoo.com.au : Remove your pants to reply

Trousers down; would you prefer the photos in PNG or JPEG?

--
Toby A Inkster BSc (Hons) ARCS
Contact Me ~ http://tobyinkster.co.uk/contact
Geek of ~ HTML/SQL/Perl/PHP/Python*/Apache/Linux

* = I'm getting there!

[Jeff North]

On Tue, 27 Feb 2007 09:58:47 +0000, in comp.lang.php Toby A Inkster
<us**********@tobyinkster.co.uk>
<nv************@ophelia.g5n.co.ukwrote:

>| Jeff North wrote:
|
| jn******@yourpantsyahoo.com.au : Remove your pants to reply
|
| Trousers down; would you prefer the photos in PNG or JPEG?

Production quality video will suffice :-P

Oh BTW, I saw someone else with this type of sig and I asked if I
could 'borrow it'.

Now getting back to the topic at hand.....
---------------------------------------------------------------
jn******@yourpantsyahoo.com.au : Remove your pants to reply
---------------------------------------------------------------