[trouble with WHERE query]

try to only use the first WHERE and delete the second one.

 

... WHERE bla = \'$bla\' AND bla2 = \'$bla2\'

 

no second \\\"WHERE\\\"

 

Thanks Jan, you all have taught me a lot!

[trouble with WHERE query]

Good point Barand, thanks!

[trouble with WHERE query]

Well, I tried it with two \"AND\" statements in the query and it worked fine.

Here was the query:

[php:1:584218dfa6]<?php

$query=\"SELECT * FROM customers WHERE state_res=\'\".$_GET[\'state_res\'].\"\' AND cust_type=\'\".$_GET[\'cust_type\'].\"\' AND cust_subtype=\'\".$_GET[\'cust_subtype\'].\"\'\";

?>[/php:1:584218dfa6]

 

The URL for this is:

http://www.racksandfins.com/guides_test.ph...fishing%20guide

 

Thanks for the help!

[trouble with WHERE query]

Awesome! Thank you so much. How many of those AND statements can I have? Thank you so much for your help.

[trouble with WHERE query]

I am not sure I understand the difference. I think I would like the query to be run using the vars from the url. I would be interested in hearing about the other way, too. Thank you for asking!

[trouble with WHERE query]

Thanks, but that didn\'t seem to fix it. I try to load:

http://www.racksandfins.com/admin/customer...t_subtype=Other

 

but no records are returned and there is no entry in my log indicating an error. Any other ideas?

Thanks for trying,

nat

[trouble with WHERE query]

I am missing something here. I would like a query where I can have records displayed according to two different criteria. I can get it done with just one, such as

[php:1:ceb2ecabf9]<?php

 

$query=\"SELECT * FROM customers WHERE cust_type=\'$cust_type\'\";

 

?>[/php:1:ceb2ecabf9]

but, when I add another field, it displays nothing and I get no errors. Ideally, I would like to have the URL indicate what I want displayed (www.somedomain.com/file.php?cust_type=5&cust_subtype=Other). A more comprehensive code snippet is below. Thanks a ton,

nat

 

[php:1:ceb2ecabf9]<?php

<?

include(\"dbcustomers.inc.php\");

mysql_connect(mysql,$username,$password);

@mysql_select_db($database) or die( \"Unable to select database\");

$query=\"SELECT * FROM customers WHERE cust_type=\'$cust_type\' AND WHERE cust_subtype=\'$cust_subtype\'\";

 

$result=mysql_query($query);

 

 

 

mysql_close();

$ctype=\"contacts\";

echo \"<b><center>Customer Database</center></b><br><br>\";

 

?>

?>[/php:1:ceb2ecabf9]