WHERES in an my sql query.

hey can anyone show me an short example on how to use where's in an mysql query using TBS.
plzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz........

Hi Dale,

What do you mean by "how to use where's" ?

There is an example on merging with MySql at the Example page. There is no WHERE clause in the query, but you can add it as you like.

The source of this forum is also available for download and it is plenty of WHERE clauses.

well can u see any errrors with this?

            $TBS->MergeBlock('blk1',$cnx_id,'SELECT * FROM '.$table_name.' WHERE (recipient=dale) ORDER BY recipient DESC') ;

Are both "recipient" and "dale" two names of columns in the tables ?

It is maybe
   (recipient='dale')

i mean say if i have like
mysql table:
recipient             message
dale                       543545
ok                      545454
dale                     65656565

so if i wanted just to display the rows on the table but the recipient = dale
what would be the query for that?

i mean say if i have like
mysql table:
recipient             message
dale                       543545
ok                      545454
dale                     65656565

so if i wanted just to display the rows on the table but the recipient = dale
what would be the query for that?

Did you follow Skrol message?
Post what error you are getting
Try simple...
Also if you query only for recipient='xxx'
then no "ORDER BY recipient DESC" needed

yea thanks guys