19.06.2011, 20:53
For your information:
If you have one connection to your database, then you have to be sure that none of the functions are storing any results of a query are inside a loop of a result of a query.
Query -> StoreResult -> Loop: Query/StoreResult (Loop fails because the earlier result doesnt exist anymore)
You can avoid this with a second connection.
Query (connection 0) -> StoreResult (connection 0) -> Loop:
{
Query (connection 1) -> StoreResult (connection 1) ... etc
FreeResult (connection 1)
}
FreeResult ( connection 0 )
There is a fail error message when you try to get the row (mysql_fetch_row):
Blah blah.. mysql_store_result couldn blah blah
- mysql_fetch_row is meant
If you have one connection to your database, then you have to be sure that none of the functions are storing any results of a query are inside a loop of a result of a query.
Query -> StoreResult -> Loop: Query/StoreResult (Loop fails because the earlier result doesnt exist anymore)
You can avoid this with a second connection.
Query (connection 0) -> StoreResult (connection 0) -> Loop:
{
Query (connection 1) -> StoreResult (connection 1) ... etc
FreeResult (connection 1)
}
FreeResult ( connection 0 )
There is a fail error message when you try to get the row (mysql_fetch_row):
Blah blah.. mysql_store_result couldn blah blah
- mysql_fetch_row is meant