Dynamic MySql Update Query
| From: | David Rice | Date: | Tue, 12 Nov 2002 15:15:42 +0000 |
| Subject: | Dynamic MySql Update Query | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-23239@lists.php.net to get a copy of this message | ||
Okay this is a tough one.
I want to make a dynamic mysql update query that takes results entered into a series of text boxes (changes from page to page) and then updates that record in my Mysql table.
the name of the form fields are $value[$x]
where 1 <= $x <= Total number of fields
===================================================
$query = "UPDATE ".$table." WHERE ".$table_headers[0]." = ".$id."
VALUES
===================================================
I have gotten this far, but don't know where to go next.
check out www.filterseven.co.uk/admin/index.php
and if you check a table, and choose an edit query on one of the records to see what i am trying to do.
thank's for your time!
cheers,
David Rice
_________________________________________________________________
The new MSN 8: smart spam protection and 2 months FREE* http://join.msn.com/?page=features/junkmail