Re: SQL+php
| From: | Thomas Seifert | Date: | Sun, 19 Jan 2003 09:30:16 +0000 |
| Subject: | Re: SQL+php | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-132172@lists.php.net to get a copy of this message | ||
it doesn't change it in the database, just in the output.
Thomas
On Sun, 19 Jan 2003 03:17:04 +0200 (EET) paulm@SGI.rdscv.ro (Paul Marinas) wrote:
> something like that only i don't whant to alter the database, the fields
> in the database must remains unchanged, only, on page i whant to display
> diferent data.
>
> On Sun, 19 Jan 2003, Sean Malloy wrote:
>
> > If you want to do it within the query itself, take a look at the mysql
> > replace command
> >
> > REPLACE(str,from_str,to_str)
> >
> > SELECT REPLACE(<field>,<from>,<to>) FROM table
> >
> > or you can do it using PHP once the query has executed, on a record by
> > record basis, within a while/for loop or whatever.
> >
> > -----Original Message-----
> > From: Paul Marinas [mailto:paulm@SGI.rdscv.ro]
> > Sent: Sunday, 19 January 2003 11:07 AM
> > Cc: php-general@lists.php.net
> > Subject: [PHP] SQL+php
> >
> >
> > Dose anyone know how to search and replace a string in a
> > mysql_query output.
> >
> > Thanks, Paul
> >
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
--
Thomas Seifert
mailto:thomas.seifert@myphorum.de
http://www.MyPhorum.de