[PHP-DB] Garbage collection (my session files)

2005-12-10 Thread Ron Piggott (PHP)
I have specified a directory for the session files to be stored in. But by doing so the garbage collection function isn't automatically deleting them. Is there a way I can do so --- Either with a cron or something like this? Ron -- PHP Database Mailing List (http://www.php.net/) To unsubscribe

[PHP-DB] SELECT

2005-12-10 Thread Ron Piggott (PHP)
I am trying to put together a SELECT syntax. I am querying a response database and I only want to obtain each user's name once even if they have given more than 1 response. $query="SELECT * FROM conversation_table WHERE conversation_reference = $conversation_currently_displayed"; $response_cr

Re: [PHP-DB] SELECT

2005-12-10 Thread Philip Hallstrom
I am trying to put together a SELECT syntax. I am querying a response database and I only want to obtain each user's name once even if they have given more than 1 response. $query="SELECT * FROM conversation_table WHERE conversation_reference = $conversation_currently_displayed"; $response_cre

Re: [PHP-DB] SELECT

2005-12-10 Thread Julien Bonastre
Yes, DISTINCT will do the same trick, I wasn't sure though as in the context he placed it I reconsidered DISTINCT and thought of GROUP BY because where there may be multiple entries/rows relating to a shared field they would obviously be seperated by perhaps a unique primary key, timestamp, id o

Re: [PHP-DB] SELECT

2005-12-10 Thread Julien Bonastre
Have you considered the GROUP BY statement of SQL?? For example if this is a table's data: msg_iduservarnamevalue 2 1yadahello 3 1yadahows it going? 4 2yada