Sairam

Hi there, I have created a query in MS Access database and named it as query1. I want to be able to execute this query through php code. I can understand the following code. $conn=odbc_connect("mydb","root","pwd"); if($conn) { $sql="select * from mytable"; $row=odbc_exec($conn, $sql); $i = 0; while(odbc_fetch_row($row)) { $i++; $name = odbc_result($row,1); $make = odbc_result($row,2); $model = odbc_result($row,3); } } My question is how to give query1 to $sql or replace $sql in "$row=odbc_exec($conn, $sql);" with "$row=odbc_exec($conn, query1);" I am new to programming in php. Please help me fix this problem. Your help is much appreciated. Thanks in advance. Best Regards, Sairam

I have created a query in MS Access database and named it as query1. I want to be able to execute this query through php code. I can understand the following code. $conn=odbc_connect("mydb","root","pwd"); if($conn) { $sql="select * from mytable"; $row=odbc_exec($conn, $sql); $i = 0; while(odbc_fetch_row($row)) { $i++; $name = odbc_result($row,1); $make = odbc_result($row,2); $model = odbc_result($row,3); } } My question is how to give query1 to $sql or replace $sql in "$row=odbc_exec($conn, $sql);" with "$row=odbc_exec($conn, query1);" I am new to programming in php. Please help me fix this problem. Your help is much appreciated. Thanks in advance. Best Regards, Sairam