Updating a mysql table with php
if it makes it through an "if" statement & then downloads it anyway, if it is duplicate info, it will not insert it [I can use the date for this]). Thanks Do you have some sort of datafeed you can run through to check for new data? $item); $available = $results['available'] 1; $result = mysqli_query($db, "UPDATE inventory SET available = " . " WHERE item = " $item); // Close connection mysqli_close($db); echo '$results = mysqli_query($db,"SELECT * FROM inventory WHERE item = " .
I currently am using the information_schema UPDATE_TIME info for the table, so I have that info.
I'm trying to update my MYSQL table based on whether or not the user wants to mark an item off a list.
When i use my script below nothing happens and I'm not sure why or whats even going wrong.
The following code block has a generic SQL syntax of the UPDATE command to modify the data in the My SQL table − The WHERE clause is very useful when you want to update the selected rows in a table.
This will use the SQL UPDATE command with the WHERE clause to update the selected data in the My SQL table tutorials_tbl.
The following example will update the tutorial_title field for a record having the tutorial_id as 3.