How to know which row was affected with a querry ???

2001-07-30 Thread Zbigniew Szczesny
Hello ! I have a following problem while scripting MySQL with PHP4: Imagine the user may add a record to a table. How can I know precisely what was the number (auto increment primary key) given by MySQL to this new inserted row ??? You may presume there are many simultaneus users adding rows,

Please help with syntax !!!

2001-07-25 Thread Zbigniew Szczesny
Hello ! This is a syntax taken from MS Access: SELECT messages.message_id, messages_1.message_id FROM messages AS messages_1 INNER JOIN (messages INNER JOIN connections ON messages.message_id = connections.parent) ON messages_1.message_id = connections.child ORDER BY messages.message_id, messag