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]