Searchform to results.php
| From: | php at 321online dot net | Date: | Fri, 07 Mar 2003 18:32:17 +0000 |
| Subject: | Searchform to results.php | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-26173@lists.php.net to get a copy of this message | ||
I have a mysql database named DEALER with tables named by states.
My script displays all the data correctly if I manually inculde the FROM
"state name".I want to make a form to let someone choose the state and run the query. I
have tried and failed can someone show me what I am doing wrong?My searchform:
<html>
<body>
<h1>Find a Dealer Search</h1>
<form action="results.php" method="post">
Choose a State:<br>
<select name="searchtype">
<option value="OHIO">OHIO
<option value="ALABAMA">ALABAMA
</select>
<input type=submit value="Search">
</form>
</body>
</html>
A snip from my results.php
<?php
// connect to my dealer database
$link = mysql_connect("XXX.XXXX.XXX", "XXX", "XXXXXXXX");
mysql_select_db("DEALER");
// query and get the number of records
$query = "SELECT NAME, ADDRESS, CITY, STATE, ZIP, TELEPHONE, WEBSITE,
EMAIL FROM ("results"))"; $result = mysql_query($query) or die("MY QUERY
ERRORS");
$num_record = mysql_num_rows($result);
if($num_record > $display) { // Only show 1,2,3,etc. when there are
more records found that fit on 1 page // when the page is loaded first...
if(empty($pagenr)) {
$pagenr = 1;
}
Would you please help me with my mistakes on line6