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 cou

[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 on

RE: [PHP-DB] http/https

2002-12-07 Thread Aaron Wolski
Hi Jeff, One thing you can try is setting the cookie twice.. with and without the secure setting. Your code will pick up the nonsecure in the nonsecure area and function fine.. just as your code will pick up the secure in the secure area and function fine. Should work. Aaron -Original Mess

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. > >

[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 di

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 func