Hello,
I have an image upload script, and at the bottom of that script I added the following SQL query to add the photo and thumbnail names to my database.
The photo upload works fine, but my database isn't getting updated. Is there something wrong with my query?
<?php
require('../includes/connMyConnection.php');
$query = "UPDATE auction_items SET item_photo_big = '$f_org' , item_photo_thumb = '$f_res' WHERE item_id = $item_id";
$result = mysql_query($query);
mysql_close($connMyConnnection);
?>
The included file connMyConnection.php contains:
<?php
# FileName="SomeFileName.htm"
# Type="MYSQL"
# HTTP="true"
$hostname_connMyConnection = "localhost";
$database_connMyConnection = "db_name";
$username_connMyConnection = "db_username";
$password_connMyConnection = "db_password";
$connMyConnection = mysql_pconnect($hostname_connMyConnection, $username_connMyConnection, $password_connMyConnection) or die(mysql_error());
?>
Thank you for your help!
Peter
