RE: [PHP] SQL+php

2003-01-19 Thread John W. Holmes
> --- Sean Burlington <[EMAIL PROTECTED]> wrote: > > I think the bandwidth wasters are those who ask > > questions poorly (it takes several follow up mails > > to find out what the question was) and those who > > don't have a qucik look at the archives first > > (is someone puuting together an FAQ

Re: [PHP] SQL+php

2003-01-19 Thread Chris Shiflett
--- Sean Burlington <[EMAIL PROTECTED]> wrote: > I think the bandwidth wasters are those who ask > questions poorly (it takes several follow up mails > to find out what the question was) and those who > don't have a qucik look at the archives first > (is someone puuting together an FAQ ?) I agree.

Re: [PHP] SQL+php

2003-01-19 Thread Chris Hewitt
John W. Holmes wrote: .it's an log for a VoIp network, evrey voip has an ip and i whant that instad of the VoIp's IP to put his name, instad of "1.1.1.1:xxx" must be "jhon doe form yyy city", it's easier to read for the people who So where do you get the name from. You're still not bei

Re: [PHP] SQL+php

2003-01-19 Thread Sean Burlington
Sean Malloy wrote: I see a lot of these type of answers on the list at the moment. I'm sick of receiving smart ass answers from people. It wastes my time, and my bandwidth. Either answer the fucking question, even if it hasn't been asked correctly, or don't reply at all. Given you are a 'PHP Pr

Re: [PHP] SQL+php

2003-01-19 Thread Thomas Seifert
it doesn't change it in the database, just in the output. Thomas On Sun, 19 Jan 2003 03:17:04 +0200 (EET) [EMAIL PROTECTED] (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 displa

RE: [PHP] SQL+php

2003-01-18 Thread Sean Malloy
I apologise for calling you a PHP Professional, clearly I was mistaken. ;) -Original Message- From: John W. Holmes [mailto:[EMAIL PROTECTED]] Sent: Sunday, 19 January 2003 4:36 PM To: 'Sean Malloy'; [EMAIL PROTECTED] Subject: RE: [PHP] SQL+php It's _for_ PHP Professiona

RE: [PHP] SQL+php

2003-01-18 Thread John W. Holmes
or No questions. There's even a funny FAQ on this, but I can't find the link anywhere. ---John Holmes... > > -Original Message- > From: John W. Holmes [mailto:[EMAIL PROTECTED]] > Sent: Sunday, 19 January 2003 11:42 AM > To: 'Paul Marinas' > Cc: [EMAIL

RE: [PHP] SQL+php

2003-01-18 Thread John W. Holmes
> .it's an log for a VoIp network, evrey voip has an ip and i whant > that instad of the VoIp's IP to put his name, instad of "1.1.1.1:xxx" must > be "jhon doe form yyy city", it's easier to read for the people who that > follow the logs. .. that's it ... So where do you get the name from. You

Re: [PHP] SQL+php

2003-01-18 Thread Paul Marinas
t;> > >> ---John W. Holmes... > >> > >> PHP Architect - A monthly magazine for PHP Professionals. Get your copy > >> today. http://www.phparch.com/ > >> > >>> -Original Message- > >>> From: Paul Marinas [mailto:[EMAIL PROTEC

Re: [PHP] SQL+php

2003-01-18 Thread Justin French
ww.phparch.com/ >> >>> -Original Message- >>> From: Paul Marinas [mailto:[EMAIL PROTECTED]] >>> Sent: Saturday, January 18, 2003 7:46 PM >>> To: John W. Holmes >>> Subject: RE: [PHP] SQL+php >>> >>> >>>

RE: [PHP] SQL+php

2003-01-18 Thread Paul Marinas
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 > >

RE: [PHP] SQL+php

2003-01-18 Thread Sean Malloy
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(,,) 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-

RE: [PHP] SQL+php

2003-01-18 Thread Paul Marinas
Message- > > From: Paul Marinas [mailto:[EMAIL PROTECTED]] > > Sent: Saturday, January 18, 2003 7:46 PM > > To: John W. Holmes > > Subject: RE: [PHP] SQL+php > > > > > > what number? .. i really need that . > > On Sat, 18 Jan 2003, John W. Holmes wr

RE: [PHP] SQL+php

2003-01-18 Thread John W. Holmes
L PROTECTED]] > Sent: Saturday, January 18, 2003 7:46 PM > To: John W. Holmes > Subject: RE: [PHP] SQL+php > > > what number? .. i really need that . > On Sat, 18 Jan 2003, John W. Holmes wrote: > > > > Dose anyone know how to search and replace a strin

RE: [PHP] SQL+php

2003-01-18 Thread Sean Malloy
rofessional' John, I would expect a little more from you. -Original Message- From: John W. Holmes [mailto:[EMAIL PROTECTED]] Sent: Sunday, 19 January 2003 11:42 AM To: 'Paul Marinas' Cc: [EMAIL PROTECTED] Subject: RE: [PHP] SQL+php > Dose anyone know h

RE: [PHP] SQL+php

2003-01-18 Thread John W. Holmes
> Dose anyone know how to search and replace a string in a > mysql_query output. Yes. ---John W. Holmes... PHP Architect - A monthly magazine for PHP Professionals. Get your copy today. http://www.phparch.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: ht

Re: [PHP] SQL / PHP Join issue.

2002-01-22 Thread clint
You need to either alias the columns i.e. career.id as careerid or rename your columns i.e. change the id to careerid & calendarid. The second option would be best because that way your columns are descriptive. HTH Clint -- Original Message -- From: Mich