SELECT * FROM... with PHP5 and Access

dico

Hello,

I'm trying to SELECT * FROM my_table with PHP5 and an ODBC connection to Ms Access... all my rows are returned but when i try to output something like

echo $row['my_field'];

it doesn't work.

However if I SELECT my_field FROM my_table and then

echo $row['my_field'];

it all works fine.

Do i have to do something special to be able to select * from a DB with Access? I'm used to using PHP/MySQL and this works fine.

Any suggestions?

Thanks,

-dr

cheese

Here is an example of something I used a while back, when someone was using access databases.

//Example
$nowt == NULL;
	    /* Connecting, selecting database */
	  $link = odbc_connect("yourodbcname","sa","",""); 
$row = odbc_exec($link,"SELECT * FROM `yourtable` WHERE `acolumn` = $something ORDER BY `acolumn` DESC" );
print "<table>";
while(odbc_fetch_row($row))
{ 
print "<tr>"; 
$col1 = odbc_result($row,1); 
$col2 = odbc_result($row,2); 
$col3 = odbc_result($row,3); 
$col4 = odbc_result($row,4);
//this bit makes an active link based on data in column 2
print "<td bgcolor=#B2B3F0 align=center><a href=apageyouwanttolinkto.php?thingtopass=" . $col2 . ">";
print $col2;
print "</a></td>";
//end of active link
print "<td bgcolor=#C8C9F8 align=center>";
print $col3;
print "</td>";
print "<td bgcolor=#B2B3F0>";
print $col4;
print "</td>";
print "</tr>"; 
}
print "</table>";

If you go to this page and log in as a guest, then look at an awaiting shipment, you will see it in action.

Hope this helps,

Neil.