[KeYBLeR]

Hello, Basicly I'm having trouble with MySQL databases, and I need one realy quick.

Requirments,
You must accept Paypal or Checks.
Must have AIM, To talk with me.
The script must also be simple enough to use as a template in the furture.
After that said, heres what I need.

I need a product database.
This database is going to have 5 FEILDS.
1) product_id
2) product_name
3) product_description
4) product_price
5) product_weight

Please use this style script, to create the databse.

PHP Code:

$create = "CREATE TABLE list (

id varchar(50) NOT NULL default '',

name varchar(50) NOT NULL default '',

email varchar(50) NOT NULL default '',

PRIMARY KEY  (id)

) TYPE=MyISAM;";

mysql_query($create) or die ("Could not create tables because ".mysql_error());

echo("Installation Complete!<BR><a href=index.php>here</a></br>"); 

I want the "product_id" to be the primary key, so I can call on each product with a number.


I also want so this form, will add a Item to the database

PHP Code:

echo("

<form action=\"add2database\" method=\"Post\">

<table>    

<tr><td><font class=>ID #</font></td><td><input type=text name=\"product_id\" /></td></tr>

<tr><td><font class=>Item Name</font></td><td><input type=text name=\"product_name\" /></td></tr>

<tr><td><font class=>Item Description</font></td><td><input type=text name=\"product_description\" /></td></tr>

<tr><td><font class=>Price</font></td><td><input type=text name=\"product_price\" /></td></tr>

<tr><td><font class=>Weight</font></td><td><input type=text name=\"product_weight\" /></td></tr>

</table>

<input type=submit value=\"Add Product\" />

</form>

"); 

I also need to be able to EDIT & Delete a Product, threw a HTML FORM.

I hope this doesn't sound hard, But I've given you most of the coding and the Plan, I just need someone to make it work with a MySQL database.

I figure this would take a good MySQL person about 10 mins to put together,

This project is worth: 5.00usd

Thanks Keith

PS, My AIM Is: utearmedown