Help with PHP using Access

[alo]

I have the following error message, can anyone help me figure out what I am doing wrong. Thanks

Warning: SQL error: , SQL state 00000 in SQLConnect in c:\inetpub\wwwroot\forum.php on line 3
Discussion Forum using PHP/Access under IIS

Post New Message
Warning: odbc_exec(): supplied argument is not a valid ODBC-Link resource in c:\inetpub\wwwroot\forum.php on line 19

Warning: odbc_fetch_row(): supplied argument is not a valid ODBC result resource in c:\inetpub\wwwroot\forum.php on line 21

[wilsonodk]

Could we see some code?

my guess would be that the query wasn't sent the value it expected. An the result then throws an error to the fetch call.

A general guideline

// Make connection to DB

// Select your DB

// Build your SQL query

// Make your query

// Use the results of the query

I haven't done any generic ODBC function calls before, I've only used MySQL, so I can't help with the specifics. But look-up [man]ODBC[/man] for more info.