generating a select list from a database

[Damo]

Hi,
I'm trying to dynamically generate a html select list from a MS Access
database using the code below:

<?php
$conn=odbc_connect('customer','','')or die('Could Not Connect to ODBC
Database!');

$queryexe="SELECT * FROM types";

$rs=odbc_exec($conn , $queryexe)or die("Query failed: $sql<br />Error:
".mysql_error()."<br />");

echo "<SELECT name="typeId">";
while(odbc_fetch_row($rs))
{
echo "<option>".odbc_result($rs,"typeId")."</option>";
}
echo "</SELECT>";
?>

Its giving a sql error when i try it.
Can anyone help?

[Andy Hassall]

On 30 Nov 2006 14:46:57 -0800, "Damo" <co***********@gmail.comwrote:

>$rs=odbc_exec($conn , $queryexe)or die("Query failed: $sql<br />Error:
".mysql_error()."<br />");

odbc_exec with mysql_error? You're mixing stuff up a bit there. Do you mean
odbc_errormsg?

$sql isn't defined either. Is this really the code you're running?

>Its giving a sql error when i try it.

You've forgotten to post the error...

--
Andy Hassall :: an**@andyh.co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool