I’m having problems getting info from my database. I’m lost on this one.
Any help is appreciated.
$connection = mysql_connect($host,$user,$password)
or die (“couldn’t connect to server”);
$db = mysql_select_db($database,$connection)
or die (“Couldn’t select database”);
$query = “SELECT DISTINCT carmake FROM ALL_ITEMS ORDER BY carmake”;
$result = mysql_query($query)
or die (“Couldn’t execute query.”);
/* create form containing selection list */
echo "
n";
while ($row = mysql_fetch_array($result))
{
extract($row);
echo “$carTypen”;
}
echo “n”;
echo "
n";
?>