Am I stupid? What is wrong with this!??!
<?include("../php/dbconnect.php");?>
<?
$get = "select * from storeProduct";
$get_result = mysql_query($get, $mysql_link);
while($row = mysql_fetch_row($get_result))
{
if(preg_match("/<img src=\"https:\/\/www2.serve.com\/ttt\/pf\/casebuy.gif\" width=\"75\" height=\"25\">/", $row[3]))
{
$replace = ereg_replace("<img src=\"https://www2.serve.com/ttt/pf/casebuy.gif\" width=\"75\" height=\"25\">", "<a href=\"javascript:openPeeker()\" onMouseOver=\"document.images['up'].src='../pf/overcase.jpg'\" onMouseOut=\"document.images['up'].src='../pf/upcase.jpg'\">
<img src=\"../pf/upcase.jpg\" width=\"106\" height=\"27\" alt=\"\" border=\"0\" align=\"\" name=\"up\"></a>", $row[3]);
$query1 = "update storeProduct set productDescription = '$replace' where productID = '$row[0]'";
$mysql_result1 = mysql_query($query1, $mysql_link);
$query2 = "select * from storeProduct where productID = '$row[0]'";
$mysql_result2 = mysql_query($query2, $mysql_link);
while($row2 = mysql_fetch_row($mysql_result2))
{
echo $row2[1]." ".$row2[3]."<br>";
}
}
}
?>
$query1 is what is not working correct. Did I go Dumb overnight? That is how you do Update, right? Then why isn't it updating MySQL.
The selects work fine
