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";

On 26 Feb 2007 21:31:38 -0800, in comp.lang.php "Abersparky"
<abersparky@gmail.com>
<1172554298.603800.62920@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";

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

Jeff North wrote:

jnorthau@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!

On Tue, 27 Feb 2007 09:58:47 +0000, in comp.lang.php Toby A Inkster
<usenet200702@tobyinkster.co.uk>
<nvbdb4-ud1.ln1@ophelia.g5n.co.ukwrote:

>| Jeff North wrote:
>|
>| jnorthau@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.....
---------------------------------------------------------------
jnorthau@yourpantsyahoo.com.au : Remove your pants to reply
---------------------------------------------------------------