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
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
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
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
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
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
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
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