Re: [PHP-DB] setting SQL variable

2007-01-18 Thread Nick Stinemates
To accomplish this in the past, it is assumed that the last entered ID is the highest (since it auto increments) To solve this simply, I would use (truncated a bit): Good luck, let me know if you need any more assistance. - Nick Stinemates On Fri, Jan 19, 2007 at 09:38:01AM +1300, Bruce Cow

Re: [PHP-DB] setting SQL variable

2007-01-18 Thread Bruce Cowin
What about doing all of that in a stored proc and handle the transaction in there? I've never done that with MySQL (only SQL Server) but I'm assuming it's possible. Regards, Bruce >>> marga <[EMAIL PROTECTED]> 18/01/2007 10:37:04 p.m. >>> Hi, I create a sql variable with php code. Is possib

[PHP-DB] templatating Question

2007-01-18 Thread Sancar Saran
Hi, I'm trying to generate a template system. I think I made it and others say this was too complicate and error prone because of the template engine uses php language... They say html people broken easly the php file structure. So I have to rewrite system for parsing simple html files. My te

RE: [PHP-DB] setting SQL variable

2007-01-18 Thread Bastien Koert
I think the issue might be that you cannot stack the queries in mysqlyou can't run both queries separated by a semi-colon. You will likely need to loop thru the queries and execute them one at a time Bastien From: marga <[EMAIL PROTECTED]> To: php-db@lists.php.net Subject: [PHP-DB] setti

[PHP-DB] Yahoo! Mail and php-db digest mail-out!

2007-01-18 Thread JeRRy
Hi, Not PHP or MYSQL related but relates to the use of this DIGEST using Yahoo! Mail (beta). Is there anyone else that uses Yahoo! Mail (beta) and recieves these DIGESTS? I don't mean the single emails you get but the DIGEST. If I go back to the OLD version of the mail and view any DIGEST e

[PHP-DB] setting SQL variable

2007-01-18 Thread marga
Hi, I create a sql variable with php code. Is possible that it didn't works? In order to maintain the integrity I open a transaction to do all inserts. First insert a row in table1. I need these Insert ID to make the follow Inserts in the relations tables. Is not possible to use mysql_insert_id()