Jump to content

longhorn14

Members
  • Posts

    7
  • Joined

  • Last visited

    Never

Profile Information

  • Gender
    Not Telling

longhorn14's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. Thanks Jan, you all have taught me a lot!
  2. 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!
  3. Awesome! Thank you so much. How many of those AND statements can I have? Thank you so much for your help.
  4. 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!
  5. 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
  6. 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]
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.