Could somebody please help me before i jump out of my window!!!
This is the first time that i am working with a database and i tought it was sepose to be easy!! Anyway i have made a form in html that is ment to send its variables to a database, i’m doing this trough a php file. So the html form is using this php file but i’m doing something wrong. i don’t uderstand how u can send the variables from the html form wich input field are called artiest, plaat, winst, file1 into a table in the database. The table in the database is using the same names like so: artiest, plaat, winst, file1. Does somebody understand my problem and if you do could you be so kind not to post a tutorial but ectually change the file i just posted?? because i never understand those tutorials anyway!!!
p.s. the php file does connect to my databse but then it says this: ‘Error, insert query failed’
<?php $username = "blabla1"; $password = "blabla2"; $hostname = "localhost"; $dbh = mysql_connect($hostname, $username, $password) or die("Unable to connect to MySQL"); print "Connected to MySQL<br>"; // you're going to do lots more here soon // insert data into database mysql_select_db($dbhl); $query = "INSERT INTO namedatabase VALUES (artiest, plaat, winst, file1)"; mysql_query($query) or die('Error, insert query failed'); mysql_close($dbh); ?>