Re: [PHP-DB] date help

Hello, You said that you are using MySQL. Create 2 columns like: create_ts INT UNSIGNED NOT NULL, last_login_ts INT UNSIGNED NOT NULL Use the MySQL UNIX_TIMESTAMP() function, comparable to the PHP time() function (number of seconds since 1-1-1970 12:00:00 AM). UPDATE table SET

Re: [PHP-DB] PHP/Apache not totally closing MySQL connections

At 18.11.2001 06:36, Bob Maple wrote: Proto Recv-Q Send-Q Local Address tcp1 0 burner.com:4848 burner.com:mysqlCLOSE [munge-alert!] Hmm, looks like my pastes got whacked. Oops. nope, if you leave it going for awhile nothing out of the ordinary happens,

Re: [PHP-DB] ODBC

Alfarees, To get the first 5 in the order they were added to the database ... select * from tablename limit 5; or, for the 5 topmost, highest value select * from tablename where somefield.value somecriteria order by tablename.somefield limit 5 Now check docs for exact synatx - TOP

[PHP-DB] PostgreSQL connection problem #2

Hi, I could solve part of the problem by creating a user and database called 'www-data'. The new question is how can I connect to an arbitrary database? (This seems to be a configuration problem for me.) Since I have more sites on the same server, I really need more db-s. My previous letter was:

[PHP-DB] PHP and MSSQL using APACHE

Hello all: Just have been tasked to port an app created on (linux)php/mysql/apache to run (on Win2K) php/mssql/apache. Any links with info on setting up mssql to work with php and apache (all on win2k) appreciated! Luis __ Do You Yahoo!? Find the

[PHP-DB] Field = NULL?

Greetings, I have a silly question, unfortunately I cannot find how it should work. I want to see if a specific field is empty. I'll paste what I've done so far. The problem is that the current coding enters no value, but the IF statement doesn't work either. Please help me :D Yours, Kevin

Re: [PHP-DB] Field = NULL?

use == to compare,, = to asign a value.. cya - Original Message - From: Kevin Schaaps [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, November 18, 2001 10:50 PM Subject: [PHP-DB] Field = NULL? Greetings, I have a silly question, unfortunately I cannot find how it should

Re: [PHP-DB] Field = NULL?

Thanks it worked :D Héctor gonzález [EMAIL PROTECTED] wrote in message 000701c170a9$14f52a80$4286890a@hectorltyrjo9b">news:000701c170a9$14f52a80$4286890a@hectorltyrjo9b... use == to compare,, = to asign a value.. cya - Original Message - From: Kevin Schaaps [EMAIL PROTECTED] To: