Insert into db help

Hello!I’m new to php and i have some problems :smiley:
Well, my code looks like this:
FINISH.PHP:
[php]
if (isset($_SESSION[‘cart’]))
{
$total=0;
echo “

Complete the forms below:

”;

echo “”;
echo "

Nume:      ";
echo “

”;

echo “

Prenume:”;
echo “

”;

echo "

Telefon:   ";
echo “

”;

echo "

E-Mail:     ";
echo “

”;
echo “

I WANT TO BUY FROM SITE.COM THE NEXT PRODUCTS:

”;

foreach($_SESSION[‘cart’] as $id => $x)
{
$result = mysql_query(“SELECT firma, model, pret FROM store WHERE id=$id”);
$myrow = mysql_fetch_array($result);
$name=$myrow[‘model’];
$name=substr($name,0,40);
$price=$myrow[‘pret’];
$line_cost=$price * $x;
$total=$total+$line_cost;

echo “

”;
echo “”;
echo "";
echo "";
echo "";
echo “”;
echo “
$myrow[firma] $name $x bucati Subtotal: $line_cost lei
”;
echo “”;
}
echo "
.
.
.
.
. } [/php] POST.PHP: [php] $sql="INSERT INTO comenzi (nume, prenume, produse, serviciu, judet, locatie, numar, telefon, email, prod) VALUES ( '$_POST[nume]', '$_POST[prenume]', '$_POST[produse]', '$_POST[serviciu]', '$_POST[judet]', '$_POST[locatie]', '$_POST[numar]', '$_POST[telefon]', '$_POST[email]', '$_POST[prod]' )"; [/php] The problem is that i want to insert into my db those values from the found in the foreach sentence.How can i do that?For example when i want to insert from "prod" i only get the last information inserted now all the products...:( Please, help :)

simple fix
on post.php
[php]

$sql=“INSERT INTO comenzi (nume, prenume, produse, serviciu, judet, locatie, numar, telefon, email, prod) VALUES ( ‘$_POST[nume]’, ‘$_POST[prenume]’, ‘$_POST[produse]’, ‘$_POST[serviciu]’, ‘$_POST[judet]’, ‘$_POST[locatie]’, ‘$_POST[numar]’, ‘$_POST[telefon]’, ‘$_POST[email]’, ‘$_POST[prod]’ )”;

mysql_query("$sql") or die(mysql_error());
[/php]

Hope that helps.

Sponsor our Newsletter | Privacy Policy | Terms of Service