Tengo esta funcion en php
Código PHP:
if ($action == "registrar"){
$query = "SELECT * FROM baskets WHERE basketSession = '" . $sessionID . "'";
$result = mysql_query($query);
$row = mysql_fetch_array( $result );
$productPrice = $row['productPrice'];
$productName = $row['productName'];
$productID = $row['productID'];
$query = "INSERT INTO registros (productID, productPrice, basketSession) VALUES ('$productID', '$productPrice', '$sessionID')";
mysql_query($query) or die('Error, insert query failed');
}
Pequeño descubrimiento...
ahora mi funcion es esta:
Código PHP:
if ($action == "registrar"){
$query = "SELECT * FROM baskets WHERE basketSession = '" . $sessionID . "'";
$result = mysql_query($query);
$row = mysql_fetch_array( $result );
while($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
$productPrice = $row['productPrice'];
$productID = $row['productID'];
$query = "INSERT INTO registros (productID, productPrice, basketSession) VALUES ('$productID', '$productPrice', '$sessionID')";
mysql_query($query) or die('Error, insert query failed');
}
$query = "DELETE FROM baskets WHERE basketSession = '" . $sessionID . "'";
mysql_query($query) or die('Error, delete query failed');
}