On Monday 24 March 2003 17:30, JeRRy wrote:

> 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 this in PHP?
> I'd prefer to keep it all on one page to make it alot
> easier to manage.  SO if +1 in table1 than update
> table2 with +1 also.  If no matches than do nothing to
> both.
> Could someone please help me with this, is it a 'if'
> statement or something?  Help is appreciated and
> thanks in advance.
> I alsready have the script to update table1 and does
> this fine but am not sure how to do mulitple queries
> in the one PHP page.

Quite simply, repeat what you did for the first table on the second table, 

 if (match) {

Jason Wong -> Gremlins Associates -> www.gremlins.biz
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *
Search the list archives before you post
Order and simplification are the first steps toward mastery of a subject
-- the actual enemy is the unknown.
                -- Thomas Mann

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to