[PHP-DB] multiple queries with PHP

2003-09-05 Thread John Ryan
I want to SELECT * from a table and also update the hit counter by 1. So theres 2 different queries which I know I can easily do in PHP seperately, but I thought itd be quicker and more efficient to run them in the same query, ie seperated by a ';'. But PHP returns an error, and it works fine on

Re: [PHP-DB] multiple queries with PHP

2003-09-05 Thread John W. Holmes
John Ryan wrote: I want to SELECT * from a table and also update the hit counter by 1. So theres 2 different queries which I know I can easily do in PHP seperately, but I thought itd be quicker and more efficient to run them in the same query, ie seperated by a ';'. But PHP returns an error, and

Re: [PHP-DB] multiple queries with PHP

2003-09-05 Thread John Ryan
You wouldnt know where to change this setting? John W. Holmes [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] John Ryan wrote: I want to SELECT * from a table and also update the hit counter by 1. So theres 2 different queries which I know I can easily do in PHP seperately, but

Re: [PHP-DB] multiple queries with PHP

2003-09-05 Thread John W. Holmes
John Ryan wrote: You wouldnt know where to change this setting? It's not a setting, you just can't do it. Use two mysql_query() calls. -- ---John Holmes... Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/ php|architect: The Magazine for PHP Professionals www.phparch.com -- PHP

Re: [PHP-DB] multiple queries in PHP to mysql database.

2003-03-28 Thread Ronan Chilvers
Hi Jerry Inline comments On 28 Mar,2003 at 12:31 JeRRy JeRRy wrote: How can I update 2 tables at once if a match occours from information inputed into a PHP form. How about turning this around and re-organising the data a little? Why not have a single score table with references to

[PHP-DB] multiple queries in PHP to mysql database.

2003-03-27 Thread JeRRy
Hi, I just noticed a problem with my question which would cause major problems in my db. So let me re-ask it again. How can I update 2 tables at once if a match occours from information inputed into a PHP form. Now this is what each table has. table1: id username game1 game2 game3 game4

AW: [PHP-DB] multiple queries in PHP to mysql database.

2003-03-27 Thread Blain
Hi After Updateing the table1: SELECT username, score FROM table1 WHERE $select='$winner'; Then you have your Informations.. Cya Blain -Ursprüngliche Nachricht- Von: JeRRy [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 28. März 2003 02:31 An: [EMAIL PROTECTED] Betreff: [PHP-DB] multiple

[PHP-DB] multiple queries in PHP ????

2003-03-24 Thread JeRRy
Hi, I have a query to update a database via PHP after a form is inputed. The form results do a match to the database and if a match occours updates a field with +1 and if no matches it does nothing. Now I want it so if +1 is done I want another table to update as +1 also. How would I achieve