Here's what I am trying to do.
Retrieve "title" and "slug title" from all the rows in a table. Update them with new "title", "slug title" and "brand name".
Here's my query. It updates the table with the brand names for each row. But for some reason, it removes the title and slug title from all the rows in the table. Is there a reason why it's doing that?
function getIt($var) {
$pos = strpos($var, ' - ');
echo(substr($var, $pos+3)."\n");
}
if(isset($_POST['submit'])) {
$get_record = $db->prepare("SELECT * FROM items");
$get_record->execute();
$result_record =