[PHP-DB] SQLite PRIMARY KEY.

2004-01-30 Thread Stuart Gilbert
thought might work, but as yet I have not been able to get it right. Can someone please help me? Regards, Stuart Gilbert. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] SQLite PRIMARY KEY.

2004-01-30 Thread Stuart Gilbert
Well, it appears I tried everything except JUST the word NULL. Sorry for wasting your time. Regards, Stuart Gilbert. Stuart Gilbert wrote: I'm trying to get my PHP code to INSERT a new row and have the PRIMARY KEY field automatically set to the next available integer. I read, somewhere

Re: [PHP-DB] Help with an UPDATE query please

2004-02-05 Thread Stuart Gilbert
Presuming you have the date in your PHP code you could simply add 172800 (seconds in 2 days) to the current value and insert it in the same way as you are doing with your current dates. If you post how you're inserting your dates, what format you're using and stuff like that then you'll

[Fwd: Re: [PHP-DB] Help with an UPDATE query please]

2004-02-05 Thread Stuart Gilbert
[Forwarded for Paxson Jr. because this was only sent to me.] you can also easily use the mysql date functions http://www.mysql.com/doc/en/Date_and_time_functions.html On 05. Feb 2004, at 11:23 Uhr, Stuart Gilbert wrote: Presuming you have the date in your PHP code you could simply add 172800

Re: [PHP-DB] Storing data in a file

2004-02-24 Thread Stuart Gilbert
of code using SQLite recently and I'd definitely recommend giving it a try. Take a look at www.php.net/sqlite for the PHP side of things and http://sqlite.org/lang.html for the supported SQL features/functions. Regards, Stuart Gilbert. -- PHP Database Mailing List (http://www.php.net