SQL: Very confused!
Ok lol this is my last question..
Now, I'm not an idiot, I program PHP and MySQL all day long, but this I just don't understand.. Code:
new plrUniqueID; Quote:
Then I tried: Code:
new plrUniqueID; Quote:
WITH BOTH CODES I GET THE ROW INSERTED INTO MY DB! The query is executing!!! |
Re: SQL: Very confused!
Try using
PHP Code:
http://dev.mysql.com/doc/refman/5.0/...last-insert-id |
Re: SQL: Very confused!
Quote:
|
Re: SQL: Very confused!
Quick question:
Were you using SQLite or MySQL? |
Re: SQL: Very confused!
Quote:
|
Re: SQL: Very confused!
have you connected to the db before you are starting to query?
|
Re: SQL: Very confused!
Let's see everything from where you connect to the db...
Scuzzy |
Re: SQL: Very confused!
It's ok guys I found a work around. It appears as though something is wrong with that function..
|
Re: SQL: Very confused!
Just bumped here and since he didn't mind to let us all know his solution 12 years ago, it's that you have to call SQL_GetInsertId() in the query callback using the main database connection handle and take it from there. Because the query doesn't execute instantly, we have to wait for the callback. Otherwise it'll return 0. Nothing is wrong with the function.
|
Re: SQL: Very confused!
Quote:
|
All times are GMT -4. The time now is 05:16. |
Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.