[SOLVED] SQL Query Question

[kyleldi]

Hi All,

 

I'm doing something quite simple here, but for some reason I can't get it to work.  My sql query (in php) needs to select data based on two requirements. 

 

$query_rs_store = sprintf("SELECT * FROM store WHERE category = "%s" AND active = "Yes" ORDER BY id ASC", GetSQLValueString($colname_rs_store, "text"));

 

The problem is I keep getting this Parse Error:  Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING in ere.php

 

I've tried using ' instead of " for the specific categories, but it still doesn't work.  %s is a url variable, while active is not.  Does this make a difference?

[trq]

$query_rs_store = sprintf("SELECT * FROM store WHERE category = '%s' AND active = 'Yes' ORDER BY id ASC", GetSQLValueString($colname_rs_store, "text"));

[kyleldi]

When I try that I get this error:  You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''' AND active = 'Yes' ORDER BY id ASC' at line 1.  Any ideas?

[trq]

Have you made sure $colname_rs_store is defined?

[kyleldi]

Yes, it is.  If I only call out the requirement of %s (my url variable) the query works fine.  It's only when I try to add another requirement that it won't work.  It's weird because I can do one or the other, but not both.

[trq]

Can you echo $query_rs_store for us?

[kyleldi]

I re-wrote the URL Variable script and made it pull $category instead of %s (technically doing the exact same thing) and now it works.  Thanks for all your help!