[thelist] php query problem
Dunstan Orchard
dunstan at 1976design.com
Tue Oct 15 16:57:01 CDT 2002
can anyone tell me why this code reults in _two_ copies of each image being
inserted into table 'cart'?
// adds all images from a user's lightbox to their cart
function lightbox_add_cart_all($userid)
{
$query = ("SELECT * FROM lightbox WHERE (userid = '$userid')");
$result = mysql_query($query);
while ($row = mysql_fetch_array($result))
{
$imageid = $row['imageid'];
$query2 = ("INSERT INTO cart (userid, imageid) VALUES
('$userid', '$imageid')");
$result2 = mysql_query($query2);
}
}
thanks very much - dunstan
---------------------------
Dorset, England
http://www.1976design.com/
http://www.orchard.it/
http://www.maccaws.org/
More information about the thelist
mailing list