Re: [PHP-DB] php and mysql

2002-12-07 Thread David Smith
Three words: php dot net --Dave On Fri, 2002-12-06 at 23:19, Jason Wong wrote: On Saturday 07 December 2002 11:54, Dallas wrote: hey, i'm just new to using php and mysql i would like to know how to do the following for a assignment of mine (shopping site):- and if I could ask for

[PHP-DB] http/https

2002-12-07 Thread Jeffrey_N_Dyke
can a cookie be valid and be passed to/from -- http and https. I loose the values from http - https. I can think of ways to fix this, but i didn't know if there was a way in the basic setting/handling of cookies, and the manual shows you how to but it says that a 1 for a secure argument will

Re: [PHP-DB] CREATE TABLE QUERY PHP/MySQL

2002-12-07 Thread Ignatius Reilly
answers inline Ignatius - Original Message - From: Jonathan [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, December 06, 2002 10:39 PM Subject: RE: [PHP-DB] CREATE TABLE QUERY PHP/MySQL Granting access makes sense. Now what

[PHP-DB] multiple table inserts at the same time

2002-12-07 Thread rolf vreijdenberger
hi there, I have multiple tables in my mysql db. Users register, and after submitting there are multiple tables that need inserts. What is the best way to do this? speedwise, efficiencywise, codewise? (pseudo code) A) $sql[]='insert1'; $sql[]='insert2'; $sql[]='insert3'; foreach($sql as

Re: [PHP-DB] multiple table inserts at the same time

2002-12-07 Thread David Smith
These two methods are nearly identical. Practically, you will probably never see a performance difference. The time it takes to perform a query is an order of magnitude greater than the time it takes to allocate space for and iterate through an array. I would imagine that you will never notice a

AW: [PHP-DB] multiple table inserts at the same time

2002-12-07 Thread [EMAIL PROTECTED]
hallo rolf, your idea is good, but its better you have a function that remove inserts, if any inserts failed. if you have mysql comiled under bsd or your mysql like immoDB your can take this with ROLLBACK function. if your mysql isn't comiled like this, you must rollback over a own rollback