[PHP-DB] Subject: mysql_real_escape_string for HTML p???

2005-03-06 Thread Neil Smith [MVP, Digital media]
You actually need (it's in the manual) nl2br for this. It converts newline (nl) to (2) break (br) so this text (\n indicates a newline character or 'enter' as you've called it) This\n is\n a\n test\n Would become Thisbr /\n isbr /\n abr /\n testbr /\n Make sure you strip those br / if you intend

RE: [PHP-DB] mysql_real_escape_string for HTML p???

2005-03-06 Thread Bastien Koert
Hi Ron Use nl2br()...its adds in br / tags. The other option is to use str_rplace and replace the characters with ones of your choice bastien From: Ron Piggott [EMAIL PROTECTED] To: PHP DB php-db@lists.php.net Subject: [PHP-DB] mysql_real_escape_string for HTML p??? Date: Sat, 5 Mar 2005

Re: [PHP-DB] email question

2005-03-06 Thread Novice Learner
Hello, I had a very similar problem when I was trying to incorporate this functionality. I have my development system at home with Windows XP home edition, Apache server, and PHP5 and it would just not send the email from my local machine even after changing the settings in the ini file, I

[PHP-DB] MySQL Result

2005-03-06 Thread Wendell Frohwein
Hello all, Have a question for you, don't know how simple this is. I want the output that mysql sends to arranged a certain way and I don't know if it is possible. Here is the select statement: SELECT cart_search.id, cart_search.year, cart_makes.thename as makename, cart_models.thename as

Re: [PHP-DB] MySQL Result

2005-03-06 Thread Micah Stevens
Just reorder your list of selected fields. SELECT fieldnames in order to be returned from tablename WHERE requirements -Micah On Sunday 06 March 2005 01:10 pm, Wendell Frohwein wrote: Hello all, Have a question for you, don't know how simple this is. I want the output that mysql sends

Re: [PHP-DB] email question

2005-03-06 Thread anirudh dutt
[EMAIL PROTECTED] wrote: I know something must be missing in my home setup, I hope I will learn that later. However when I uploaded the files to my ISP, the email functionality would work and emails went through with absolutely no problem. u need an MTA set up on the machine (eg. qmail,

Re: [PHP-DB] MySQL Result

2005-03-06 Thread Micah Stevens
As a kind soul pointed out, I missed the string joining you need to do, so I feel tasked with addressing this further.. Simple answer: I don't see a way to do this with a single query unless you're using a DB with subqueries.. in which case you might be able to figure something out, but

Re: [PHP-DB] MYSQL row position.. is it possible (urgent)

2005-03-06 Thread Tatang Widyanto
how about : SELECT (count( b.unique_id ) + 1) ranking FROM table_name a, table_name b WHERE a.unique_id = '4' AND b.score a.score Mike wrote: Let's say I have a database and I want to find the position of a row when it is ordered by a specific column before a sort: UNIQUE ID | SCORE