Re: [nyphp-talk] mysql: timestamp issue?

2008-07-01 Thread Matt Juszczak
I think the default is to insert the current timestamp on creation of new row and not change that value even if row is updated... ? I remember I had some fun with phpMyAdmin trying to figure out how they had this set up. -- Kristina If I remember correctly, it will update the first timestamp r

Re: [nyphp-talk] mysql: timestamp issue?

2008-07-01 Thread Kristina Anderson
I think the default is to insert the current timestamp on creation of new row and not change that value even if row is updated... ? I remember I had some fun with phpMyAdmin trying to figure out how they had this set up. -- Kristina > > `edi_updated` timestamp NOT NULL default CURRENT_TIMESTAM

Re: [nyphp-talk] mysql: timestamp issue?

2008-07-01 Thread Matt Juszczak
`edi_updated` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, Shouldn't it auto update by default? alter table modify edi_updated timestamp NOT NULL; Wouldn't that auto update it anyway? ___ New York PHP Community Talk Mai

Re: [nyphp-talk] url pass array as parameter

2008-07-01 Thread Anirudh Zala
On Tuesday 01 Jul 2008 19:35:47 chad qian wrote: > Thanks for everyone answer my question! > > One further question: > if > url=galleryform.php?$cartStr='cart[0]=val1&cart[1]=val2'; > > then > On gallery.php page: > $totalcart=$_GET['cartStr'] > for($x=0;$x<$totalcart[].length;$x++) > {echo $tot

Re: [nyphp-talk] url pass array as parameter

2008-07-01 Thread Anirudh Zala
On Tuesday 01 Jul 2008 19:48:27 Kristina Anderson wrote: > url would have to be 'galleryform.php?cart[0]=val1&cart[1]=val2' > (i'm not sure if you can use brackets [] in a URL either) > > or something of that nature. remember, a querystring has to consist > of key=value pairs (or it can be just on

[nyphp-talk] mysql: timestamp issue?

2008-07-01 Thread Marc Antony Vose
Hi there. I exported this create table statement from an existing table of mine. I was just wondering if someone would enlighten me as to why my "edi_updated" timestamp column is not auto-updating when a record is updated? Cheers, Marc CREATE TABLE `editions` ( `edi_id` int(10) unsi

RE: [nyphp-talk] url pass array as parameter

2008-07-01 Thread Kristina Anderson
url would have to be 'galleryform.php?cart[0]=val1&cart[1]=val2' (i'm not sure if you can use brackets [] in a URL either) or something of that nature. remember, a querystring has to consist of key=value pairs (or it can be just one value if a single parameter)...and it will automatically BE a

RE: [nyphp-talk] url pass array as parameter

2008-07-01 Thread chad qian
Thanks for everyone answer my question! One further question: if url=galleryform.php?$cartStr='cart[0]=val1&cart[1]=val2'; then On gallery.php page: Is gallery.php coding is correct?I want to output array. Thanks again! > Date: Tue, 1 Jul 2008 06:24:17 -0400> To: talk@lists.nyphp.org> F

Re: [nyphp-talk] url pass array as parameter

2008-07-01 Thread Ken Robinson
At 12:13 AM 7/1/2008, Anirudh Zala wrote: On Tuesday 01 Jul 2008 03:09:48 Tim Lieberman wrote: > Passing arrays in a query string is the wrong way to do it. Too many > things can go wrong. True. It is not proper way. But if you still want to pass such data using GET method then you can build Qu