garethppls

yep that worked thanks sharkbait. I used nl2br before inserting it to the MYSQL but its all good :)

[!--quoteo(post=388910:date=Jun 28 2006, 06:19 PM:name=AndyB)--][div class=\'quotetop\']QUOTE(AndyB @ Jun 28 2006, 06:19 PM) [snapback]388910[/snapback][/div][div class=\'quotemain\'][!--quotec--] [!--sql--][div class=\'sqltop\']SQL[/div][div class=\'sqlmain\'][!--sql1--][span style=\'color:blue;font-weight:bold\']SELECT[/span] something [color=green]FROM[/color] [color=orange]some_table[/color] [color=green]ORDER BY[/color] date_fieldname .... [!--sql2--][/div][!--sql3--] [/quote] how would someone put the date in the correct format for MYSQL [a href=\"http://dev.mysql.com/doc/refman/5.0/en/timestamp-4-1.html\" target=\"_blank\"]http://dev.mysql.com/doc/refman/5.0/en/timestamp-4-1.html[/a] *edit: found it here thanks!!*

thanks Sharkbait will try that now

what if \n or \r arent contained in it?

no I want it to detect paragraph breaks in a form without putting <p> in , just like this forum as its a forum script i'm making

I have a form but I want to disable HTML. the problem with this is the form doesn't recognise paragraph breaks. any way of doing this like on this forum. thanks,

how to order data via dates in MYSQL please?

Hi I have recently made a script in PHP that can connect to a Source server and get the name of the server the game and the map. However in the player info query when I put in the challenge number I get the query just times out.. Can anyone tell me how to send the correct into in the player info query, thanks (no need to split it i'll do that but if you could just get the query and the challenge number joined correctly it would be nice. Thanks... I've been learning a lot in this area recently.