I don't know why!?

[kachurak]

I am getting the following error on this page.... and DON'T see why... any ideas? Sort of new... but learning as I go!

Parse error: parse error, unexpected T_STRING in /var...
(The error refers to the SQL statement line)

Here's the code:

/?php mysql_select_db($database_ptw, $ptw);

$query_current_specials = "SELECT * FROM pagers WHERE special = "Yes"";

$current_specials = mysql_query($query_current_specials, $ptw) or die(mysql_error());

$row_current_specials = mysql_fetch_assoc($current_specials);

$totalRows_current_specials = mysql_num_rows($current_specials);
/>

I just can't figure it out!?

Thanks folks,
Matt

[volleytotal_ch]

you have to put the search condition (the word you're looking for) into '' and not use "" because this is the marker for the end of your php text string!

$query_current_specials = "SELECT * FROM pagers WHERE special = 'Yes' ";

[kachurak]

Ok... multiple tables... pulling details from:

SELECT * FROM pagers, internet, phones, accessories WHERE special='Yes'

I get another error... saying that the colname of special is ambiguous. I have tried searching MySQL's website and am unable to find what I can use similar to the ability to do this....

How can I do something like *.special for the statement?

Thanks again!
Matt

[kachurak]

Got it figured out - Thanks