Here is my error:
Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /home/thelogic/public_html/admin/upload.php on line 9
Duplicate entry 'Z0001' for key 2
Here's complete script:
Code: Select all
<?php
$price = $HTTP_POST_VARS['price'];
$zoonum = $HTTP_POST_VARS['zoonum'];
$submit = $HTTP_POST_VARS['submit'];
$file = $HTTP_POST_FILES['srcimage'];
$uploaddir = '../sale/';
mysql_connect("localhost","username","password"); //then connect as user
mysql_select_db("thelogic_sale"); //select which database you want to edit
if (mysql_result(mysql_query('SELECT COUNT(*) FROM zoos WHERE zooID='.$zoonum),0)==0) {
mysql_query("INSERT INTO zoos (ID,zooID,avail,price,code)"."VALUES ('NULL', '$zoonum', 'avail', '$price', 'Yummy Zoos')") or die(mysql_error());
echo "$zoonum added!";
}
else
{
mysql_query('UPDATE zoos SET avail="avail", price="'.$price.'", code="Yummy Zoos" WHERE zooID='.$zoonum) or die (mysql_error());
echo "$zoonum updated!";
}
print "Creating thumbnail from source image...";
echo $file['name']."<br>\n";
echo $file['tmp_name']."<br>\n";
copy($file['tmp_name'], $uploaddir.$zoonum.'.jpg');
$src = ImageCreateFromJPEG($uploaddir.$zoonum.'.jpg');
$org_h = imagesy($src);
$org_w = imagesx($src);
$img = ImageCreateTrueColor(150,100);
ImageCopyResampled($img, $src, 0, 0, 0, 0, 150, 100, $org_w, $org_h );
ImageJPEG($img, $uploaddir.$zoonum.'thumb.jpg', 100);
ImageDestroy ($img);
ImageDestroy ($src);
echo "Finished, click <a href='index.php'>here</a> to add additional entries.<br>";
echo "Below is the thumbnail that was generated:<br>";
echo "<img src='http://www.logicalreef.com/sale/"."$zoonum"."thumb.jpg'>";
?>Ryan