In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
says...
> 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:
('$year','$make','$model','$price','$picture')";
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 (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
