$database = mysql_connect("localhost", "myusername", "mypassword"); mysql_select_db("mydatabase",$database); $sql = sprintf("INSERT INTO users (image_url, image_name, user) VALUES ( '%s','%s','%s')", mysql_real_escape_string($url),mysql_real_escape_string($file_name),mysql_real_escape_string($uname)); echo $sql; mysql_query($sql);
this code is ran whenever a file is uploaded successfully. I know that it is running cause it prints the sql statement correctly and the sql shows up as:
INSERT INTO users (image_url, image_name, user) VALUES ( 'upload_img/asdfsdf.txt','asdfsdf.txt','tyler')
Im not even getting any error messages....
and nothing is in the database
thanks in advance.