php

Hvad har jeg lavet forkert i nedenstående:



Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /var/www/html/admin/delete_search.php on line 122
som er    if ($row = mysql_fetch_array($result)) {


$lastTime = strtotime("-1 week");
$lastWeek = date("Y-m-d", $lastTime);
echo "Listen viser alle produkter som ikke er opdateret siden " . $lastWeek;
                           
    echo "<form name=\"update\" id=\"frm1\" method=\"post\" action=\"".$_SERVER["PHP_SELF"]."?action=update_prices\">";
    echo "<table>";
    echo "<tr><th>Image</th><th>Product ID</th><th>Title</th><th>Delete</th><th>Last Modified</th><th>Vendor ID</th><th>Mark All" . "<input type='checkbox' name='checkall' onclick='checkedAll(update);'></th></tr>";
    $sql = mysql_query("SELECT * FROM products WHERE products_last_modified < \'$lastWeek\' AND vendors_id = 2 ORDER BY products_last_modified DESC");
    if ($row = mysql_fetch_array($result)) {
        do {
            $prezzo=round($row['products_price'],2);
                                                                                      echo "<td>".tep_image(DIR_WS_CATALOG_IMAGES . $row['products_image'], $row['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT)."</td>\n";
            echo "<td align=\"center\">".$row["products_model"]."</td>\n";
            echo "<td>".$row["products_name"]."</td>\n";
                                                              echo "<td>".$row["products_last_modified"]."</td>\n";
                                                              echo "<td align=center>".$row["vendors_id"]."</td>\n";
            echo "<td align=\"center\"><input type=\"checkbox\" name=\"product_new_price[".$row['products_id']."]\" value=\"removed\"></td>\n";
            echo "</tr>\n";
        }
        while($row = mysql_fetch_array($result));
    }
    echo "</table>\n";