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