Re: [PHP-DB] Getting last insert id?

2003-10-08 Thread Jeff Shapiro
can I get the id from the above insert? Any help would be greatly appreciated :-) Regards Chris --- Listserv only address. Jeff Shapiro -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] HELP With UPDATE Query in mySQL

2003-10-04 Thread Jeff Shapiro
for Booking_Start_Date are 09.00 and all of the times for Booking_End_Date are 17.30, without affecting any of the dates? Thanks for your help --- Listserv only address. Jeff Shapiro -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Help With Another UPDATE Query Please!

2003-10-04 Thread Jeff Shapiro
query? Thanks for your help --- Listserv only address. Jeff Shapiro -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] how to select rows with repeated coloumns in one query????

2003-09-30 Thread Jeff Shapiro
address. Jeff Shapiro -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] sql optimizing assistance

2003-09-19 Thread Jeff Shapiro
= Response.Question_Key WHERE Question.Question_Key LIKE '2003%' GROUP BY Response.Question_Key ORDER BY Question.Question_Key ASC What does EXPLAIN tell you for this query? Is it using your indexes? ---John Holmes... --- Listserv only address. Jeff Shapiro -- PHP Database Mailing List (http

Re: [PHP-DB] Consider upgrading MySQL client .... how do I do this?

2003-09-04 Thread Jeff Shapiro
that this may be slower. My question, therefore, is - is there a way to upgrade the MySQL client in PHP 4.3.3? If not, what are the alternatives (apart from reverting back to MySQL 4.0.x of course). Thanks in advance. Vinny. --- Listserv only address. Jeff Shapiro -- PHP Database Mailing

Re: [PHP-DB] MySQL, PHP, and XML

2003-06-11 Thread Jeff Shapiro
only address. Jeff Shapiro -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] problem with insert query

2003-06-07 Thread Jeff Shapiro
and line 9 is $query = insert into recipients (recipient_name, recipient_email) values ('friend', '.$mails[$i].'); --- Listserv only address. Jeff Shapiro -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] How to find the last ID?

2003-06-06 Thread Jeff Shapiro
) VALUES ('$agentname') but I need to find out the ID value it created, how can I do this easily? Thanks Chris --- Listserv only address. Jeff Shapiro -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php