Part Mysql part PHP question....

2003-03-08 Thread C. Reeve
automatically appears (and if there should be a power failure orWindows crashes, or whatever else - I want the process to start at the last player being updated - I don't want to have to start again from player one). I'm not sure if this is more a PHP or MySQL question - or both - so I have sent

RE: Part Mysql part PHP question....

2003-03-08 Thread Roger Davis
. Roger -Original Message- From: C. Reeve [mailto:[EMAIL PROTECTED] Sent: Saturday, March 08, 2003 6:44 PM To: MySQL List Subject: Part Mysql part PHP question Hi, I have a hockey database with players names in it and I want to be able to update their stats one after the other. To be more

Re: MySQL and PHP question

2002-12-18 Thread C. Reeve
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']; } Loop through the result and return the value from the last row

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

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

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 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 C. Reeve
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 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

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

2001-02-08 Thread Cal Evans
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 and country

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|

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 |