biscoe Posted October 12, 2006 Share Posted October 12, 2006 [code]$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);[/code]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:[code]INSERT INTO users (image_url, image_name, user) VALUES ( 'upload_img/asdfsdf.txt','asdfsdf.txt','tyler')[/code]Im not even getting any error messages....and nothing is in the databasethanks in advance. Quote Link to comment Share on other sites More sharing options...
fenway Posted October 12, 2006 Share Posted October 12, 2006 Check the return value from mysql_query() and/or mysql_error(). Quote Link to comment Share on other sites More sharing options...
biscoe Posted October 13, 2006 Author Share Posted October 13, 2006 problem solved........... thanks for the help Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.