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