Code Comments
Programming Forum and web based access to our favorite programming groups.Could anyone, please, help me with this one. If I add the insert inside the
loop it inserts as many orders in the order table as products have been chos
en. There is really no way to split this?
I have a problem with a script that gets the ID's of the selected products f
rom the previous script and shows them with mysql_fetch_object. Now I'd like
to insert them in the db, but when I pass every value to $vars and insert t
hem it inserts only one of
the selected products. I tried a change with mysql_fetch_array, with split a
nd implode, ...useless. How can I get the products to be apart without break
ing the values, ie, put name of all the selected products in name field in t
he db, put serial number of
the selected products in serial field in the db, etc?:
...
while($isc = mysql_fetch_object($antw)){
if (!empty($isc->pic)) {
echo ("<img src='$isc->pic' width='50'><br>");
}
if (!empty($isc->Meas)) {
echo ("$isc->infMeas<br>");
}
if (!empty($isc->Name)) {
echo ("$isc->Name, ");
}
if (!empty($isc->Ref)) {
echo ("$isc->Ref,<br>");
}
$ipic = $isc->pic;
$iMeas = $isc->Meas;
$iName = $isc->Name;
$iRef = $isc->Ref;
}
...
$dem = "INSERT INTO orders VALUES('$ipic','$iMeas','$iName','$iRef'
);
...
By the way how can I get them apart in the previous page by rows of 3 produc
ts each in the table?:
...
echo ("<table width=100% border=1 align=center cellspacing=0
cellpadding=5 bordercolor=#0000FF");
while ($inb = mysql_fetch_object($resultprd))
{
echo ("<tr><td width='20%'>");
if (!empty($inb->pic)) {
echo ("<img src='$inb->pic' width='200'><br>");
} else {
echo ("<img src='http://.../notaval.gif' width='200'><br>");
}
if (!empty($inb->Type)) {
echo ("$inb->Type,<br>");
}
if (!empty($inb->Name)) {
echo ("$inb->Name<br>");
}
if (!empty($inb->Ref)) {
echo ("$inb->Ref<br>");
}
if (!empty($inb->Meas)) {
echo ("$inb->Meas<br>");
}
if (!empty($inb->Ref)) {
echo ("$inb->Ref<br>");
}
if (!empty($inb->Serial)) {
echo ("<strong>SERIAL N°: $inb->Serial</strong><br>");
}
if (!empty($inb->Description)) {
echo ("DETAILS: $inb->Description,<br>");
}
if (!empty($inb->Artw)) {
echo ("$inb->Artw,<br>");
}
if (!empty($inb->Cover)) {
echo ("$inb->Cover,<br>");
}
echo ("</td></table>");
---------------------------------
Créez gratuitement votre Yahoo! Mail avec 100 Mo de stockage !
Créez votre Yahoo! Mail
Le nouveau Yahoo! Messenger est arrivé ! Découvrez toutes les nouveautés pou
r dialoguer instantanément avec vos amis.Téléchargez GRATUITEMENT ici !
Post Follow-up to this messagePowered by vBulletin
Copyright 2000-2006 Jelsoft Enterprises Limited.