This script has no errors, but it won't pull the search results form the database.

dcatkin

<?php
$username = "dcatkin";
$password = "hellfire";
$hostname = "localhost";
$dbh = mysql_connect($hostname, $username, $password)
	or die("Unable to connect to MySQL");
$selected = mysql_select_db("cars",$dbh)
	or die("Could not select cars");
$args->arg_type[0] = $result;
$args->arg_type[1] = "$Make, $Year, $Model, $Price, $Description, $Name, $Address, $Email, $Phone, $URL";
$result = mysql_query("SELECT  Make, Year, Model, Price, Description, Name, Address, Email, Phone, URL FROM Cars");
$result = array('Year, Price, Description, Name, Address, Email, Phone, URL');
$mysql_fetch_array = ($result);
$Make = $_GET["Make"];
$Year = $_GET["Year"];
$Model = $_GET["Model"];
$Price = $_GET["Price"];
$Description = $_GET["Description"];
$Name = $_GET["Name"];
$Address = $_GET["Address"];
$Email = $_GET["Email"];
$Phone = $_GET["Phone"];
$URL = $_GET["URL"];
include("template.php");
mysql_close($dbh);
?>

http://hp-car.com/cars/search/search.php

It gets me because it has no errors.

dnszero

There are no errors because your script is syntatically correct, but there are several logic errors which are keeping it from working.

First and foremost read this page (the notes too) on mysql_fetch_array()
http://www.php.net/manual/en/function.mysql-fetch-array.php

Then get rid of the lines that look like
$Make = $_GET["Make"];
and replace them with the appropriate assignment staments which should be evident after reading the above manual page.

superwormy

$result = mysql_query("SELECT Make, Year, Model, Price, Description, Name, Address, Email, Phone, URL FROM Cars");

$array = mysql_fetch_array = ($result);

Get rid of all that $_GET crap, no idea what you're using that for... after doing whats above all the data should be in an array. If you want multiple records you need to loop through teh result set with this:

while ($array = mysql_fetch_array ($result)) {

dcatkin

Thanks guys once again you,ve helped me out.