> Hi everyone,
> I don't get my upload to work properly. It's a tutorial of the web, but it
> doesn't function (unless I made a mistake). Please help me...
> I have a form passing on 5 fields (text for testing), name: year, make,
> model, price, picture and submit to PHP_SELF
> <?php
> if ($submit) {
> $db = mysql_connect("localhost","myname","mypassword");
> mysql_select_db("$test",$db);
> //DB Test for testing...
> $sql = "INSERT INTO test (year,make,model,price,picture) VALUES
> ('$year,$make,$model,$price,$picture')";

This line looks like your first problem. Each value being inserted which 
is a text type should be separately surrounded by single quotes. So:


As a debugging aid, use 

echo mysql_error()

after you pass the query to mysql with mysql_query() I don't see where you 
actually do that in this code snippet??

> //I created these columns in the table test
> echo "year: $year<br>\n";
> echo "make: $make<br>\n";
> echo "model: $model<br>\n";
> echo "price: $price<br>\n";
> echo "picture: $picture<br>\n";
> }
> ?>
> I know I need globals on for this.
> Thanx for the help,

David Robley
Temporary Kiwi!

Quod subigo farinam

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to