searching a database with a form using mutiple fields

dv6cougar

ok I have tried this multiple ways but none of my trials worked problem is that when you hit search it gives an error on line 22, which is the mysql_num_rows() I will label that line in the script for you...

i have a feeling that this is all due becuase of my $query and how i have that set up... but I cannot seem to fix it 🙁

any ideas? thanks in advance


<?
include("db.php");

if ($submit) {
$query = "SELECT tunercar_modhowto FROM $make WHERE (Year='$Year',
												   Model='$Model',
												   Type_of_How_To='$Type_of_How_To',
												   Mod_Name='$Mod_Name',
												   Description='$Description',
												   Estimated_Pr='$Estimated_Pr',
												   Steps='$Steps',
												   Created_by='$Created_by') ";


$result = mysql_query($query, $mysql_access);

//line 21, 22 is below....
if(mysql_num_rows($result)) {


while($row = mysql_fetch_row($result));

{
	print("$row[1]<br>");
	print("$row[2]<br>");
	print("$row[3]<br>");
	print("$row[4]<br>");
	print("$row[5]<br>");
	print("$row[6]<br>");
	print("$row[7]<br>");
	print("$row[8]<br>");
	print("$row[9]<br>");
	}
	} else {

print("Sorry, there are no results matching your criteria, go back and try again with less options to search for");

}
} else {
?>
<div width="800">
  <table width="60%" class="howto" align="center" border="1" bordercolor="black" cellpadding="0" cellspacing="0">
    <form method="post" action="search.php">
<input type="hidden" name="id">
<input type="hidden" action="insert">
<tr>
        <td class="topcell" width="37%"></td>
        <td width="63%" class="topcell"> Please fill out this form again to enter another mod how to:</td>
      </tr>
<tr>
        <td width="37%" class="howto"> Make:</td>
        <td width="63%" align="center"> 
          <select name="make">
  <option selected value="All_Cars">All Cars</option>
  <option value="Acura">Acura</option>
  <option value="Alfa_Romeo">Alfa Romeo</option>
  <option value="Aston_Martin">Aston Martin</option>
  <option value="Asuna">Asuna</option>
  <option value="Audi">Audi</option>
  <option value="Austin">Austin</option>
  <option value="Bentley">Bentley</option>
  <option value="BMW">BMW</option>
  <option value="Buick">Buick</option>
  <option value="Cadillac">Cadillac</option>
  <option value="Chevrolet">Chevrolet</option>
  <option value="Chrysler">Chrysler</option>
  <option value="Citroen">Citroen</option>
  <option value="Daewoo">Daewoo</option>
  <option value="Daihatsu">Daihatsu</option>
  <option value="Datsun">Datsun</option>
  <option value="DeTomaso">DeTomaso</option>
  <option value="Dodge">Dodge</option>
  <option value="Eagle">Eage</option>
  <option value="Ferrari">Ferrari</option>
  <option value="Fiat">Fiat</option>
  <option value="Ford">Ford</option>
  <option value="Freightliner">Freightliner</option>
  <option value="GMC">GMC</option>
  <option value="Geo">Geo</option>
  <option value="Holden">Holden</option>
  <option value="Honda">Honda</option>
  <option value="Hummer">Hummer</option>
  <option value="Hyundai">Hyundai</option>
  <option value="IHC">IHC</option>
  <option value="Infiniti">Infiniti</option>
  <option value="Isuzu">Isuzu</option>
  <option value="Jaguar">Jaguar</option>
  <option value="Jeep">Jeep</option>
  <option value="Kia">Kia</option>
  <option value="Lada">Lada</option>
  <option value="Lamborghini">Lamborghini</option>
  <option value="Land Rover">Land Rover</option>
  <option value="Lexus">Lexus</option>
  <option value="Lincoln">Lincoln</option>
  <option value="Lotus">Lotus</option>
  <option value="MG">MG</option>
  <option value="Mazda">Mazda</option>
  <option value="Mercedes_Benz">Mercedes-Benz</option>
  <option value="Mercury">Mercury</option>
  <option value="Merkur">Merkur</option>
  <option value="MINI">MINI</option>
  <option value="Mitshubishi">Mitshubishi</option>
  <option value="Nissan">Nissan</option>
  <option value="Oldsmobile">Oldsmobile</option>
  <option value="Opel">Opel</option>
  <option value="Peugeot">Peugeot</option>
  <option value="Plymouth">Plymouth</option>
  <option value="Pontiac">Pontiac</option>
  <option value="Porsche">Porsche</option>
  <option value="Renault">Renault</option>
  <option value="Rolls_Royce">Rolls-Royce</option>
  <option value="Rover">Rover</option>
  <option value="Saab">Saab</option>
  <option value="Saleen">Saleen</option>
  <option value="Saturn">Saturn</option>
  <option value="Seat">Seat</option>
  <option value="Shelby">Shelby</option>
  <option value="Skoda">Skoda</option>
  <option value="Sterling">Sterling</option>
  <option value="Subaru">Subaru</option>
  <option value="Suzuki">Suzuki</option>
  <option value="Toyota">Toyota</option>
  <option value="Volkswagen">Volkswagen</option>
  <option value="Volvo">Volvo</option>
  <option value="Yugo">Yugo</option>
  </select></td></tr>
 <tr> 
        <td width="37%" class="howto"> Year:</td>
        <td width="63%" class="howto" align="center"> 
          <select name="Year"><option selected value="2002">2002</option>
<option value="2002">2002</option>
<option value="2001">2001</option>
<option value="2000">2000</option>
<option value="1999">1999</option>
<option value="1998">1998</option>
<option value="1997">1997</option>
<option value="1996">1996</option>
<option value="1995">1995</option>
<option value="1994">1994</option>
<option value="1993">1993</option>
<option value="1992">1992</option>
<option value="1991">1991</option>
<option value="1990">1990</option>
<option value="1989">1989</option>
<option value="1988">1988</option>
<option value="1987">1987</option>
<option value="1986">1986</option>
<option value="1985">1985</option>
<option value="1984">1984</option>
<option value="1983">1983</option>
<option value="1982">1982</option>
<option value="1981">1981</option>
<option value="1980">1980</option>
<option value="1979">1979</option>
<option value="1978">1978</option>
<option value="1977">1977</option>
<option value="1976">1976</option>
<option value="1975">1975</option>
<option value="1974">1974</option>
<option value="1973">1973</option>
<option value="1972">1972</option>
<option value="1971">1971</option>
<option value="1970">1970</option>
<option value="1969">1969</option>
<option value="1968">1968</option>
<option value="1967">1967</option>
<option value="1966">1966</option>
<option value="1965">1965</option>
<option value="1964">1964</option>
<option value="1963">1963</option>
<option value="1962">1962</option>
<option value="1961">1961</option>
<option value="1960">1960</option>
<option value="1959">1959</option>
<option value="1958">1958</option>
<option value="1957">1957</option>
<option value="1956">1956</option>
<option value="1955">1955</option>
<option value="1954">1954</option>
<option value="1953">1953</option>
<option value="1952">1952</option>
<option value="1951">1951</option>
<option value="1950">1950</option>
<option value="1949">1949</option>
<option value="1948">1948</option>
<option value="1947">1947</option>
<option value="1946">1946</option>
<option value="1945">1945</option>
<option value="1944">1944</option>
<option value="1943">1943</option>
<option value="1942">1942</option>
<option value="1941">1941</option>
<option value="1940">1940</option>
</select></td></tr>
<tr>
        <td width="37%" class="howto"> Model:</td>
        <td width="63%" class="howto"> 
          <input type="text" name="Model"></td></tr>
<tr>
        <td width="37%" class="howto">Type of how to</td>
        <td width="63%" align="center"> 
          <select name="Type_of_How_To">
<option selected value="Electrical">Electrical</option>
<option value="Audio">Audio</option>
<option value="Exhuast">Exhuast</option>
<option value="Performance">Performance</option>
<option value="Intake">Intake</option>
<option value="Interior">Interior</option>
<option value="Interior Paint">Interior Paint</option>
<option value="Exterior">Exterior</option>
<option value="ExteriorPaint">ExteriorPaint</option>
<option value="Custom Grill">Custom Grill</option>
<option value="Suspension">Suspension</option>
</select></td></tr>
<tr>
        <td width="37%" class="howto">Estimated Time to do Mod:</td>
        <td width="63%" class="howto"> 
          <input type="text" name="Time"></td></tr>
<tr>
        <td width="37%" class="howto">Mod Name:</td>
        <td width="63%" class="howto" valign="middle"> 
          <input type="text" name="Mod_Name"></td></tr>
<tr>
        <td width="37%" class="howto">Description of Mod:</td>
        <td width="63%" class="howto"> 
          <input type="text" name="Description"></td></tr>
<tr>
        <td width="37%" class="howto">Estimated Cost of Mod:</td>
        <td width="63%" class="howto"> 
          <input type="text" name="Description"></td></tr>
<tr>
        <td width="37%" class="howto">Steps and Procedures to do Mod:</td>
        <td width="63%" align="center"> 
          <textarea name="Steps" rows="10" cols="50" valign="bottom"></textarea></td></tr>
<tr>
        <td class="howto" width="37%">Created by:</td>
        <td class="howto" width="63%">
<input type="text" name="Created_by"></td></tr>
<tr>
        <td width="37%"></td>
        <td align="right" width="63%"> 
          <input type="submit" value="Search" name="submit"></td></tr>
</form>

</table>
</div>
<?
}
?>
</body>
</html>

and here is the actual error message it creates 🙁

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/tunercar/public_html/db/search.php on line 22

Thanks again

Pig

well the problem is definitely in your query.

Maybe I just haven't explored other possibilites in structure, but the I thought you had to specifically say AND when using multiple where clauses.

ie: WHERE Year='$Year' AND Model='$Model' AND Type_of_How_To='$Type_of_How_To'...

But I could be completely wrong.

It is also possible that your names are incorrect, and there could be a small typo. I'd double check your names.

gl, don't know if that helped.

dustbuster

I believe Pig is correct.
The error message you got means that you have something wrong with the query. You should use AND to separate your WHERE clauses.

Another thing that might give you problems when you get the query working

while($row = mysql_fetch_row($result)); <- semicolon

The above statement won't give an error, it will just keep iterating and you won't see anything but the last entry you retrieved. The semicolon should be removed in the code you provided.

Good luck🙂

clifford

This code, which is at:
http://chinasearesort.com/1_6.php
<html>
<body>
<?php

$db = mysql_connect("localhost", "root");

mysql_select_db("mydb",$db);

$result = mysql_query("SELECT * FROM employees",$db);

echo("First: %s \n", mysql_result($result,0,"first"));
echo("Last: %s \n", mysql_result($result,0,"last"));
echo("Address: %s \n", mysql_result($result,0,"address"));
echo("Position: %s \n", mysql_result($result,0,"position"));

?>
</body>
</html>

GIVES THIS ERROR:
Parse error: parse error in /home/china/public_html/1_6.php on line 11
LINE 11 IS THE FIRST ECHO, DOES IT MATTER THAT I AM USING ECHO INSTEAD OF PRINTF?
THANKS, CLIFFORD

dustbuster

clifford

echo is not the same as printf. It isn't the same function (see php.net and search for echo)

echo "First: ". mysql_result($result,0,'first')."<br>\n";

This should work.

clifford

echo "First: ". mysql_result($result,0,'first')." \n";

hm, that gives this error message:

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /home/china/public_html/1_6.php3 on line 10
First:

I appreciate your help, I need to learn this stuff. What do you think is the problem now?

dv6cougar

Originally posted by dustbuster
clifford

echo is not the same as printf. It isn't the same function (see php.net and search for echo)
echo "First: ". mysql_result($result,0,'first')." \n";
This should work. [/B]

I believe what clifford meant is that you need to use

printf ("First: ". mysql_result($result,0,'first')."<br>\n");

and not

echo "First: ". mysql_result($result,0,'first')."<br>\n";

ok now, back to my script 🙁

i did all of the above so the portion i changed now looks like this

<?
include("db.php");

if ($submit) {
$query = "SELECT * FROM $make WHERE Year='$Year' AND
                                                   Model='$Model' AND
                                                   Type_of_How_To='$Type_of_How_To' AND
                                                   Mod_Name='$Mod_Name' AND
                                                   Description='$Description' AND
                                                   Estimated_Pr='$Estimated_Pr' AND
                                                   Steps='$Steps' AND
                                                   Created_by='$Created_by' ";


$result = mysql_query($query, $mysql_access);

//line 21, 22 is below....
if(mysql_num_rows($result)) {


while($row = mysql_fetch_row($result))

{
    print("$row[1]<br>");
    print("$row[2]<br>");
    print("$row[3]<br>");
    print("$row[4]<br>");
    print("$row[5]<br>");
    print("$row[6]<br>");
    print("$row[7]<br>");
    print("$row[8]<br>");
    print("$row[9]<br>");
    }
    } else {

now no more errors BUT nothing's coming out of the database?

could be that i'm using the $make string to find the table?

that part works excellent for inserting though?

any ideas? any help's appreciated.

i have a few other ideas I can try too but I have tried one with no luck 🙁

Thank you all

dustbuster

clifford,

the error:
Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /home/china/public_html/1_6.php3 on line 10

means that when you make your sql statement there is something wrong. If you post it someone may be able to help

dv6cougar

A couple suggestions

Is $make the name of a table? I mean do you have a table named 'Acura'. By saying "SELECT FROM $make....." You are getting "SELECT FROM Acura....." Is that how your database is set up?

Before you make your sql query can you print out the value of $make and all the others posted from the form?

Does your php server have auto globals turned on? You may need to try using $_POST['make'] if nothing is being sent.

Pig

I'd stick a plain echo statement in your last where clause to see if it is being triggered at all.

Also, don't forget that row[1] is the 2nd entry, and row[0] is the first.

clifford

WOW, that one is way too far advanced for me. The fix you mentioed above:
printf ("First: ". mysql_result($result,0,'first')." \n");
still gives the error message:

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /home/china/public_html/1_6.php3 on line 11
First

The table setup is:
id tinyint(4) DEFAULT '0' NOT NULL AUTO_INCREMENT,
first varchar(20), last varchar(20), address varchar(255), position varchar(50), PRIMARY KEY (id)

I'll be glad to give someone access to the site if they need to see
it. I have mysql and phpadmin. Any other ideas? Is there a typo somewhere?

dustbuster

clifford
Post your SQL query.

Perhaps it looks something like this

$sql="SELECT * FROM my table where FIRST='Bob'";
$result=mysql_query($sql,$db)

If you have phpMyAdmin you can type the query in to the Query section of the interface for that table.

clifford

Here is the whole php file. I'm commenting out some lines to try different things. This is how it is now:

<html>
<body>
<?php

$db = mysql_connect("localhost", "root");

mysql_select_db("mydb",$db);

$result = mysql_query("SELECT * FROM employees",$db);
//next line is the second fix from phpbuilders
printf ("First: ". mysql_result($result,0,'first')." \n");

// next line is the first fix from phpbuilders
//echo "First: ". mysql_result($result,0,'first')." \n";

//echo("First: %s \n", mysql_result($result,0,"first"));
//echo("Last: %s \n", mysql_result($result,0,"last"));
//echo("Address: %s \n", mysql_result($result,0,"address"));
//echo("Position: %s \n", mysql_result($result,0,"position"));

?>
</body>
</html>

dustbuster

clifford

try putting a die() statement after your connections

$db = mysql_connect("localhost", "root") or die("Could not connect: " . mysql_error());
mysql_select_db("mydb",$db) or die(mysql_error());

This will tell you if you are connecting properly. From what I can see your SQL query is formatted correctly.

dv6cougar

Originally posted by dustbuster
clifford,

Does your php server have auto globals turned on? You may need to try using $_POST['make'] if nothing is being sent.

you got it right down.... the drop down selection for Acura would set $make and that is the table.

now my other script does the connection much the same but it's not a query, it's an insert_into and ti works fine with the drop down menu.

so $make is the table
and everything else is a field inside that table..... i have all the tables made with all those fields from All Car- Yugo

and I know that $myrow["1"] is the second entry, the first being my id, which i dont' need to query 🙂

but why use $_POST["make"] ??
why sould this work with a insert into script and not a search one?

here's my other script for reference

<html>
<head>
<title>TunerCarz-- Add a how to the Database</title>
<link rel="stylesheet" type="text/css" href="howtostyle.css">
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body bgcolor="#999999">

<?
include("db.php");

$query = "INSERT INTO $make ";
$query .= "VALUES(0, '$id',
					 '$Year',
					 '$Model',
					 '$Type_of_How_To',
					 '$Mod_Name',
					 '$Time',
					 '$Description',
					 '$Estimated_Pr,'
					 '$Steps',
					 '$Created_by')";
mysql_query($query, $mysql_access);

if ($submit) {
printf ("<table width=\"300\" align=\"center\" class=\"howto\">");
printf ("<tr><td class=\"topcell\"><h1>Successfully entered your mod how to the database</h1></td></tr>");
printf ("</table>");
?>
<div width="800">

<table width="800" align="center">
<tr><td class=howto><img src="mainlogo.jpg" width="800" height="150"></td></tr>
<td width="20%" align="left">
<table width="15%" align="left"><tr>
<td class="topcell" align="right">Navigate</td></tr>
<tr><td class="howto"><a href="http://tunercarz.com">Home</a></td></tr>
<tr><td class="howto"><a href="inserthowto.php">Add How To</a></td></tr>
<tr><td class="howto"><a href="search.php">Search</a></td></tr>
<tr><td class="howto">Update a How to</td></tr>
</table>
  <table width="60%" class="howto" align="center" border="1" bordercolor="black" cellpadding="0" cellspacing="0">
    <form method="post" action="inserthowto.php">
<input type="hidden" name="id">
<input type="hidden" action="insert">
<tr>
        <td class="topcell" width="37%"></td>
        <td width="63%" class="topcell"> Please fill out this form again to enter another mod how to:</td>
      </tr>
<tr>
        <td width="37%" class="howto"> Make:</td>
        <td width="63%" align="center"> 
          <select name="make">
  <option selected value="All_Cars">All Cars</option>
  <option value="Acura">Acura</option>
  <option value="Alfa_Romeo">Alfa Romeo</option>
  <option value="Aston_Martin">Aston Martin</option>
/******
cut out alot becuase the post is more then 10000 characters and therefore is not allowed to be posted
******/
  <option value="Volkswagen">Volkswagen</option>
  <option value="Volvo">Volvo</option>
  <option value="Yugo">Yugo</option>
  </select></td></tr>
 <tr> 
        <td width="37%" class="howto"> Year:</td>
        <td width="63%" class="howto" align="center"> 
          <select name="Year"><option selected value="2002">2002</option>
<option value="2002">2002</option>
<option value="2001">2001</option>
<option value="2000">2000</option>
<option value="1999">1999</option>
<option value="1998">1998</option>
<option value="1997">1997</option>
<option value="1996">1996</option>
<option value="1995">1995</option>
<option value="1994">1994</option>
<option value="1993">1993</option>
<option value="1992">1992</option>
<option value="1991">1991</option>
<option value="1990">1990</option>
<option value="1989">1989</option>
<option value="1988">1988</option>
<option value="1987">1987</option>
<option value="1986">1986</option>
<option value="1985">1985</option>
<option value="1984">1984</option>
<option value="1983">1983</option>
<option value="1982">1982</option>
<option value="1981">1981</option>
<option value="1980">1980</option>
<option value="1979">1979</option>
<option value="1978">1978</option>
<option value="1977">1977</option>
<option value="1976">1976</option>
<option value="1975">1975</option>
<option value="1974">1974</option>
<option value="1973">1973</option>
<option value="1972">1972</option>
<option value="1971">1971</option>
<option value="1970">1970</option>
<option value="1969">1969</option>
<option value="1968">1968</option>
<option value="1967">1967</option>
<option value="1966">1966</option>
<option value="1965">1965</option>
<option value="1964">1964</option>
<option value="1963">1963</option>
<option value="1962">1962</option>
<option value="1961">1961</option>
<option value="1960">1960</option>
<option value="1959">1959</option>
<option value="1958">1958</option>
<option value="1957">1957</option>
<option value="1956">1956</option>
<option value="1955">1955</option>
<option value="1954">1954</option>
<option value="1953">1953</option>
<option value="1952">1952</option>
<option value="1951">1951</option>
<option value="1950">1950</option>
<option value="1949">1949</option>
<option value="1948">1948</option>
<option value="1947">1947</option>
<option value="1946">1946</option>
<option value="1945">1945</option>
<option value="1944">1944</option>
<option value="1943">1943</option>
<option value="1942">1942</option>
<option value="1941">1941</option>
<option value="1940">1940</option>
</select></td></tr>
<tr>
        <td width="37%" class="howto"> Model:</td>
        <td width="63%" class="howto"> 
          <input type="text" name="Model"></td></tr>
<tr>
        <td width="37%" class="howto">Type of how to</td>
        <td width="63%" align="center"> 
          <select name="Type_of_How_To">
<option selected value="Electrical">Electrical</option>
<option value="Audio">Audio</option>
<option value="Exhuast">Exhuast</option>
<option value="Performance">Performance</option>
<option value="Intake">Intake</option>
<option value="Interior">Interior</option>
<option value="Interior Paint">Interior Paint</option>
<option value="Exterior">Exterior</option>
<option value="ExteriorPaint">ExteriorPaint</option>
<option value="Custom Grill">Custom Grill</option>
<option value="Suspension">Suspension</option>
</select></td></tr>
<tr>
        <td width="37%" class="howto">Estimated Time to do Mod:</td>
        <td width="63%" class="howto"> 
          <input type="text" name="Time"></td></tr>
<tr>
        <td width="37%" class="howto">Mod Name:</td>
        <td width="63%" class="howto" valign="middle"> 
          <input type="text" name="Mod_Name"></td></tr>
<tr>
        <td width="37%" class="howto">Description of Mod:</td>
        <td width="63%" class="howto"> 
          <input type="text" name="Description"></td></tr>
<tr>
        <td width="37%" class="howto">Estimated Cost of Mod:</td>
        <td width="63%" class="howto"> 
          <input type="text" name="Description"></td></tr>
<tr>
        <td width="37%" class="howto">Steps and Procedures to do Mod:</td>
        <td width="63%" align="center"> 
          <textarea name="Steps" rows="10" cols="50" valign="bottom"></textarea></td></tr>
<tr>
        <td class="howto" width="37%">Created by:</td>
        <td class="howto" width="63%">
<input type="text" name="Created_by"></td></tr>
<tr>
        <td width="37%"></td>
        <td align="right" width="63%"> 
          <input type="submit" value="Enter How To" name="submit"></td></tr>
</form>

</table>
</table>
</div>
<?
} else {

?>

<!-- here in my script i have another table to show up matching the above... it doesnt' fit in the post though, ti's too long  -->

<?

}
?>

</body>
</html>

dv6cougar

yet another question

let's say for make Acura has been chosen, next I want a drop down in cars to appear.... in the model column

how can i do that?

i know i could make a seperate page with each list of models for every make but that's a lot of work.

that woudl look like this

if ($make == Acura) {

print("<a href=\"url\">Acura</a>");

} else {
print("error in script");

if ($make == All_Cars) {
print("<a href\"url2\">All Cars");

etc etc etc... or i could do a switch case

any better ideas on this one?

thanks

cgraz

Anytime you have a problem with a mysql query, there are two things you can do to solve the problem quickly:

Print the query string (make sure query is a string, not a string being executed)

RIGHT

$sql = "SELECT * FROM table";
print $sql;

WRONG

$sql = mysql_query("SELECT * FROM table");
print $sql;
// execute the query here

use mysql_error() to print out any errors. It could be something as little as misspelling the table name. (in your case you're using a variable, but I've made this mistake plenty of times)

So change your code to the following:

$query = "SELECT * FROM $make WHERE Year='$Year' AND
                                                   Model='$Model' AND
                                                   Type_of_How_To='$Type_of_How_To' AND
                                                   Mod_Name='$Mod_Name' AND
                                                   Description='$Description' AND
                                                   Estimated_Pr='$Estimated_Pr' AND
                                                   Steps='$Steps' AND
                                                   Created_by='$Created_by'";

print "Query: " . $query . "<br>"


$result = mysql_query($query) or die(mysql_error());

Tell us what that prints.

For your last question. If you want model to be dyanmically selected based on what make they select for make, you'll need javascript. Here's the logic behind it

when they select make, the page refreshes (using javascript). You're pulling model out of the database, right? So then what you'd do is SELECT model FROM table WHERE make='" . $_POST['make'] . "'

Then, fill in the dropdown dynamically using the search results.

Cgraz

dv6cougar

the above code thros an error

Parse error: parse error, unexpected T_VARIABLE in /home/tunercar/public_html/db/search3.php on line 28

line 28 is
$result = mysql_query($query) or die(mysql_error());

so that's no good 🙁

i was thinking that the reason why nothings showing up is becuase the ID is not used to search?

could that be it?

and if so how I would i do a hidden insert of ID? where it just looks for all the id's

cgraz

No you don't need the id to search. The parse error is becuase I forgot a semi-colon in my last post on this line:

print "Query: " . $query . " ";

Add in the semi-colon then let me know what it prints.

Cgraz

dv6cougar

i filled out my form after altering it with your code and it gave me this

Query: SELECT * FROM Mercury WHERE Year='1999' AND Model='Cougar' AND Type_of_How_To='Interior Paint' AND Mod_Name='' AND Description='' AND Estimated_Pr='' AND Steps='' AND Created_by=''
Sorry, there are no results matching your criteria, go back and try again with less options to search for

seems to me like the strings are working fine, so what's my problem 🙁
thanks for helping me 🙂

cgraz

Well that's because you have a lot of where field=''

So if the person doesn't select that search term, you're saying in your query they want that field to have no value. That's why you're getting no results returned. What you have to do is only select stuff that they specified in their search. Try this:

$query = "SELECT * FROM $make";

foreach($_POST as $key => $value) {

   if($query == "SELECT * FROM $make") {
      $query .= " WHERE $key='$value'";
   } else {
      $query .= " AND $key='$value'";
   }

}

print $query . "<br>";
$result = mysql_query($query) or die(mysql_error());

Cgraz