Hi,I'm making a website that uses data stored in SQL.One of my pages allows the user to enter a new product into a product table. I was wondering if somebody could help me with some validation or Query that will not allow the user to enter a product name that already exists in the table? $nameNew = $_POST['new];$nameID = $_POST['newID];$namePrice = $_POST['newPrice];$editQuery = "INSERT INTO productsVALUES ($nameNew, $newID, $newPrice)"'$describeQuery = "SELECT ID, Name, Price FROM Products";$results = sqlsrv_query($conn, $describeQuery);echo '<table border="1" BORDERCOLOR=Black>';echo '<tr><th bgcolor = "LightBlue">Name</th><th bgcolor = "LightBlue" >ID</th> <th bgcolor = "LightBlue" >Price</th></tr>';while($row = sqlsrv_fetch_array($results, SQLSRV_FETCH_ASSOC)) { echo '<tr>'; echo '<td >' .$row['Name'].'</td>'; echo '<td>' .$row['ID'].'</td>'; echo '<td>' .$row['Price'].'</td>'; echo '</tr>'; } echo '</table>';sqlsrv_close($conn); Can anybody help I'm totally out of ideas.
Checking for duplicates before adding data
Posted - 2012-05-08 : 18:09:33
