RE: Form value editing
can someone please just send me or post a example of editing feilds of a mysql database within an html form and then updating the values thanks alot here is a small database u can use i can expand on your example as needed /* CREATE TABLE `kids` ( `id` int(10) NOT NULL auto_increment, `first_name` varchar(30) NOT NULL default '', `last_name` varchar(50) NOT NULL default '', `email` varchar(75) default NULL, `contact_status` tinyint(1) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM ; add form i have working and SQL stuff i have its just bringing up a form from a list and editing values in the form i need help with ,, thanks here is a form i have thats about all i have Manage Contact's Data Form First Name: Last Name: Email Address: Stop Contact? > -- If you can't use a stored procedure, create a dynamic "UPDATE" statement and execute it. Make sure you take care of the single-quotes, for if you do not have magic quotes enabled (I am one of those who never activate them), you need to use the addslashes function to transform ' into ''. Think about data types and field length and you should be fine. Now, if you want me to do it for you, don't forget to give me a piece of your cake. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Form value editing
On Thu, 2006-04-20 at 19:15 -0400, fbsd wrote: > > > can someone please just send me or post a example of editing feilds > of a > mysql database within an html form and then updating the values > thanks alot These should tell you everything you need to know. http://www.php.net/manual/en/ref.mysql.php http://dev.mysql.com/doc/refman/5.0/en/insert.html http://dev.mysql.com/doc/refman/5.0/en/update.html http://dev.mysql.com/doc/refman/5.0/en/select.html -- omni Digital Darkness Promotions Check out the Dallas Music Wiki http://digitaldarkness.com/tiki signature.asc Description: This is a digitally signed message part
Re: Form value editing
Brian E Boothe wrote: can someone please just send me or post a example of editing feilds of a mysql database within an html form and then updating the values thanks alot Google for php,mysql,examples. PB -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.385 / Virus Database: 268.4.4/318 - Release Date: 4/18/2006 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Form value editing
[snip] can someone please just send me or post a example of editing feilds of a mysql database within an html form and then updating the values thanks alot here is a small database u can use i can expand on your example as needed [/snip] PHP question; When you click on the form submission button you must issue an update query. Here is a Google link http://www.google.com/search?hl=en&q=update+mysql+database+PHP -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]