Right, for some reason, my INSERT queries are being weird and are trying to enter the same record twice, even though i only call the function once! It enters the record, then gives me an error message saying that it cant insert the record because it is already there! (Duplicate record). The INSERT function i use is below, which basically returns a list of what has been inserted on successful completion, and returns an error message if failed:
Code: Select all
function insertNewStock($stockArray){
$mysqlAddStock = "INSERT INTO stock (ItemCode, Product, Company, Brand, TypeOfProduct, Colour, Size, Shape, Length, Description, Quantity) values ('".$stockArray['itemCode']."','" .$stockArray['Product']."','" .$stockArray['Company']."','" .$stockArray['Brand']."','" .$stockArray['TypeOfProduct']."','" .$stockArray['Colour']."','" .$stockArray['Size']."','" .$stockArray['Shape']."','" .$stockArray['Length']."','" .$stockArray['Description']."','" .$stockArray['Quantity']."')";
if(mysql_query($mysqlAddStock)){
$response = "<font size=3>The following item has been saved successfully:</font>";
$response = $response + "<table border=1>";
$response = $response + "<tr><td align=right><b>Item Code: </b></td><td align=right>".$stockArray['itemCode']."</tr>";
$response = $response + "<tr><td align=right><b>Description: </b></td><td align=right>".$stockArray['Description']."</tr>";
$response = $response + "<tr><td align=right><b>Product: </b></td><td align=right>".$stockArray['Product']."</tr>";
$response = $response + "<tr><td align=right><b>Company: </b></td><td align=right>".$stockArray['Company']."</tr>";
$response = $response + "<tr><td align=right><b>Brand: </b></td><td align=right>".$stockArray['Brand']."</tr>";
$response = $response + "<tr><td align=right><b>Type Of Product: </b></td><td align=right>".$stockArray['TypeOfProduct']."</tr>";
$response = $response + "<tr><td align=right><b>Colour: </b></td><td align=right>".$stockArray['Colour']."</tr>";
$response = $response + "<tr><td align=right><b>Size: </b></td><td align=right>".$stockArray['Size']."</tr>";
$response = $response + "<tr><td align=right><b>Shape: </b></td><td align=right>".$stockArray['Shape']."</tr>";
$response = $response + "<tr><td align=right><b>Length: </b></td><td align=right>".$stockArray['Length']."</tr>";
$response = $response + "<tr><td align=right><b>Quantity: </b></td><td align=right>".$stockArray['Quantity']."</tr></table><br>";
$response = $response + "<a href='addNewStock.php'><button name='anotherStock'>Add Another</button></a>";
$response = $response + "<a href='mainpage.php'><button name='mainpage'>Mainpage</button></a>";
return $response;
}else{
$response = "<p>Cannot insert new stock due to: ".mysql_error();
return $response;
}
}Code: Select all
$insert = insertNewStock($_SESSION);
echo $insert;Thanks in advance, any and all help will be much appreciated!