If( Query)
| From: | Chris Hale | Date: | Sat, 06 Sep 2008 19:02:08 +0000 |
| Subject: | If( Query) | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-45366@lists.php.net to get a copy of this message | ||
I have the following function:
function add_item($item_name,$item_desc,$item_price,$item_man_id,$item_cat_id,$item_pix)
{
connect();
if($item_pix == "")
{
$sql = "INSERT INTO items (item_name,item_desc,item_price,item_man_id,item_cat_id) VALUES ('$item_name','$item_desc','$item_price','$item_man_id','$item_cat_id')";
}
else {
$sql = "INSERT INTO items (item_name,item_desc,item_price,item_pix,item_man_id,item_cat_id) VALUES ('$item_name','$item_desc','$item_price','$item_pix','$item_man_id','$item_cat_id')";
}
mysql_query($sql);
return;
}
I am using the if statement because i want it so that if no picture is uploaded the entry is blank and the mysql database has a default entry of na.gif which is a "picture coming soon picture".
It works fine when i run in localy on MAMP, but if i run it on my web server it doesnt add the row.
Is this a compatability error? or is there a better way to write this?
Thanks