PHP - Consultar bd y cambiar los registros visualizados

$sql = "SELECT DISTINCT jos_vm_orders.order_id, jos_vm_orders.cdate, jos_vm_orders.order_total, jos_vm_order_user_info.first_name, jos_vm_order_user_info.last_name,jos_vm_orders.order_status, jos_vm_order_user_info.user_email, jos_vm_product.product_sku,jos_vm_order_item.order_item_sku, jos_vm_order_item.product_quantity, jos_vm_product.caducidad,  jos_vm_order_item.order_item_name,  jos_vm_order_item.product_final_price, jos_vm_order_item.order_consumo  FROM jos_vm_orders, jos_vm_order_item, jos_vm_order_user_info, jos_vm_product WHERE jos_vm_orders.order_id = '$q' AND jos_vm_orders.order_id = jos_vm_order_item.order_id AND jos_vm_order_item.order_item_sku = jos_vm_product.product_sku";

$result = mysql_query($sql);

while($campo = mysql_fetch_assoc($result))

  {

  echo "    <tr>";

  echo "         <td>".$campo [ "order_id" ]."</td>";

   echo "         <td>".$campo [ "first_name" ]."</td>";

    echo "         <td>".$campo [ "last_name" ]."</td>";

     echo "         <td>".$campo [ "order_status" ]."</td>";

	   echo "         <td>".$campo [ "order_item_sku" ]."</td>";

   echo "    <tr>";

  }

  echo "</table>";

mysql_close($con);

?>