Please help!!!!!!Re: order by...group by...complicated query

>hi, > >i am trying to build a message board in php with mysql as back end; > >what i want to do is to query the database in a certain way that the >result is returned in the correct order for php to display the discussion >thread properly > >here is my table structure: > >mysql> show fields fr

order by...group by...complicated query

hi, i am trying to build a message board in php with mysql as back end; what i want to do is to query the database in a certain way that the result is returned in the correct order for php to display the discussion thread properly here is my table structure: mysql> show fields from posts

Re: A couple of questions about connections

hi from the manual: "Aborted_clients : This means that something of the following has happened: · The client program did not call mysql_close() before exit. · The client had been sleeping more than wait_timeout or interactive_timeout without doing any requests. See section · ·

Re: help (urgent!!!) with a query(SOLVED!!)

t; >delete * from TABLE where TIMESTAMP='date, interval 3 day' > >I'm new to this as well but I think this might be closer > >let me know the answer > >-C >- Original Message - >From: "hassan el forkani" <[EMAIL PROTECTED]> >To

help (urgent!!!) with a query

hello; can someone please help me with this query: "delete from TABLE_NAME where TIMESTAMP_COLUMN(date, interval 3 day) < now()" what i'm tryng to do is to delete all records that are 3 (or more) days old i've looked around in the manual but couldn't find a "working answer", date functions are

Re: Moving database from windoze to Linux

try to use mysqlfront ( http://www.mysqlfront.de ), a windows GUI for mysql i've tried it and it works like a charm you can export table structure in a .sql format and then dump data into a csv file and use the same utlity to import the files into your linux machine; regards; At 08:00 27/07/0

Re: mysql.org

"First: take it to court. Potentially expensive, and probably not good for public relations for either party" probably the only sentence that makes sense in this "affaire" from a mysql user point of view, nusphere's move is completely amateur i can't see any intelligent motivation for it, th

Re: Information Technique

At 01:56 23/04/01 -0700, Van wrote: >hassan el forkani wrote: > > > > j'ai eu le meme probleme mais en environnement de développement, ce que je > > sait c'est que ca dépend du characterset de votre base de donnée faut > > demander à votre hebergeur le

Re: Information Technique

j'ai eu le meme probleme mais en environnement de développement, ce que je sait c'est que ca dépend du characterset de votre base de donnée faut demander à votre hebergeur le characterset (dans les "environnement variables") du serveur mysql ou votre base est hebergée At 23:33 21/04/01 +020

Re: french characters

i doubled checked things, the problem is in the database server french characters are not accepted as is, my sql converts them to , or ? any solution for this?? At 14:06 22/04/01 +0300, you wrote: >In order to see french characters you have to put in your php4/html page >header the line: >

french characters

hi, i'm running mysql server version 3.23.33 on a win98 machine using the following characterset : latin1 i have the following problem when i enter french characters like à or é... into the database using php4 scripts they are improperly recorded and returned like ? or , what i want to know is w