Re: upload data to MySql

In article <20021114024607.95201.qmail@pb1.pair.com>, jacco@vliegt.nl 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