Re: MySQL and PHP question

2002-12-18 Thread C. Reeve
"MySQL List" <[EMAIL PROTECTED]> Sent: Wednesday, December 18, 2002 1:32 AM Subject: Re: MySQL and PHP question > On Wed, 18 Dec 2002 22:54:53 -0500, C. Reeve wrote: > >while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) { > >$num1 = $line['number

Re: MySQL and PHP question

2002-12-17 Thread Steve Yates
On Wed, 18 Dec 2002 22:54:53 -0500, C. Reeve wrote: >while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) { >$num1 = $line['number']; >} Loop through the result and return the value from the last row? Did you want "select sum(number) as SubTotal1 from table1 where userid=$user1

Re: MySQL and PHP question

2002-12-17 Thread C. Reeve
ge - From: "Steve Yates" <[EMAIL PROTECTED]> To: "MySQL List" <[EMAIL PROTECTED]> Sent: Tuesday, December 17, 2002 5:12 PM Subject: Re: MySQL and PHP question > On Wed, 18 Dec 2002 16:05:35 -0500, C. Reeve wrote: > > >I can not use two mysql queries

RE: MySQL and PHP question

2002-12-17 Thread Fraser Stuart
List | Subject: MySQL and PHP question | | | Hi, | | Why is it that I can not use two mysql queries in the same PHP | file. I have | tried to do this several times trying to put my site together and have had | nothing but problems. | | The recent one is this: | | I use a SELECT statement to get some

Re: MySQL and PHP question

2002-12-17 Thread Steve Yates
On Wed, 18 Dec 2002 16:05:35 -0500, C. Reeve wrote: >I can not use two mysql queries in the same PHP file Please post code snippets, this is possible. - Steve Yates - Burger Borg: We do it our way; yours is irrelevant. ~ Taglines by Taglinator - www.srtware.com ~ --

Re: MySQL and PHP question

2002-12-17 Thread Chris Boget
> Why is it that I can not use two mysql queries in the same PHP file. You can, I assure you. > Any info is appreciated. Perhaps if you could provide your code? W/o it there is no way we can determine where the problem might be coming from. Chris

MySQL and PHP question

2002-12-17 Thread C. Reeve
Hi, Why is it that I can not use two mysql queries in the same PHP file. I have tried to do this several times trying to put my site together and have had nothing but problems. The recent one is this: I use a SELECT statement to get some info from a table, then I modify that info and use an UPDA

Re: MySQL and PHP Question

2001-02-08 Thread Ing . Alejandro Vázquez C .
Adrian D'Costa wrote: > Hi, > > I have two tables city and country > +---+-+--+-+-++ > | Field | Type| Null | Key | Default | Extra | > +---+-+--+-+-++ > | id

RE: MySQL and PHP Question

2001-02-08 Thread Cal Evans
Cal http://www.calevans.com -Original Message- From: Adrian D'Costa [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 06, 2001 12:01 AM To: [EMAIL PROTECTED] Subject: MySQL and PHP Question Hi, I have two tables city a

MySQL and PHP Question

2001-02-07 Thread Adrian D'Costa
Hi, I have two tables city and country +---+-+--+-+-++ | Field | Type| Null | Key | Default | Extra | +---+-+--+-+-++ | id| int(5) | | PRI | 0 | aut