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
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:[EMAIL PROTECTED]] > > Sent: Sunday, 19 January 2003 11

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
IL PROTECTED]] > Sent: Sunday, 19 January 2003 11:07 AM > Cc: [EMAIL PROTECTED] > 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.n

RE: [PHP] SQL+php

2003-01-18 Thread Sean Malloy
- From: Paul Marinas [mailto:[EMAIL PROTECTED]] Sent: Sunday, 19 January 2003 11:07 AM Cc: [EMAIL PROTECTED] 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

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

[PHP] SQL+php

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

[PHP] SQL / PHP Join issue. - SOLVED

2002-01-22 Thread Michael O'Neal
Hi all. Never mind my previous post. I fixed my SQL statements by using "AS" statements. For example: SELECT calendar.ID AS calendar_ID,calendar.Calendar_Title AS Calendar_Title,calendar.Add_To_Scroller AS calendar_Add_To_Scroller... That worked like I wanted it to. Thanks! mto -- Mich

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

[PHP] SQL / PHP Join issue.

2002-01-22 Thread Michael O'Neal
Hi, I'm having a little trouble with this join statement I'm working on. What I *think* is happening is that PHP is getting confused with the "ID" field that is the same for the three different tables. When I go through the result set, you can see that the field "ID" gets used a couple of times