PHP & SQL Error

[Anon]

I am updating certain fields in a table, which works perfectly, but I do always get a weird PHP Error, which I can't get rid off.

Warning: No tuples available at this result index in C:\apache\htdocs\syndataaccess.php3 on line 150

Line 150:
while( odbc_fetch_row( $cur ) )
{
$nbrow++;
$idnum= odbc_result( $cur, 1 );
$SQL_Exec_String = "UPDATE dbtable SET synthesis = $index WHERE id = $ids[$i]";
}

Has anybody got some ides what this could be?

I alrady tried to specify a cursor when connecting, as shown below:

$conn_id=odbc_connect("$dsn","","", SQL_CUR_USE_ODBC );

but this does not help either.

Thanks!

[[deleted]]

UPDATE queries don't return any data, only true/false.
You can't fetch any records after running an UPDATE query.

[Anon]

Alright, I understand!

But which operator should I use instead?

Thanks a lot for your help.

[Anon]

Didn't need the while loop... Problem solved.

Thanks

[Anon]

I removed the PHP error:
"No tuples available at this result index in .." by modifying the PHP.INI (C:\WINNT\PHP.INI) line:
"output_buffering = Off" to "output_buffering = On|Off".

Be careful though because this attribute is also used by the php 'header ()' function.

Raymond Sassine

[[deleted]]

output buffering has nothing to do with error reports, and you cannot disable error reports by enabling output buffering.

The only way to disable error reports is by changing the error_reporyting level in php.ini, or setting it at runtime, or by putting an @ in front of the command that causes the 'error'.

NOTE: NEVER EVER disable any error reporting if your program does no check for errors tself.
If you do disable error reporting without proper error-checking, it becomes imossible to debug your script.
For example; if you disable error-reporting and you get a database connection error, you will never know that the database connection is the problem. All you see is that your entire script stops working for no apparent reason. No error messges, no warnings, no output.