Jump to content

Archived

This topic is now archived and is closed to further replies.

biscoe

Help i cant enter data

Recommended Posts

[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 database

thanks in advance.

Share this post


Link to post
Share on other sites
Check the return value from mysql_query() and/or mysql_error().

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.