RE: Form value editing

2006-04-20 Thread Nicolas Verhaeghe

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

2006-04-20 Thread Pat Adams
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

2006-04-20 Thread Peter Brawley

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

2006-04-20 Thread Jay Blanchard
[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]