[PHP] To Loop or Not to Loop?

[Jay Fitzgerald]

The code below inserts the same inventory item into the db multiple times - 
I just need 1 line entry for each inventory item, but multiple photos of 
each item....How to do this?

I know the code I wrote below is extremely awful, but I am a nebie and that 
was the only way I could get it to half-way do what I am wanting

<SNIP>
for($q=0;$q<$tot;$q++)
{
        $thefile = $_FILES['userfile']['name'][$q];
        $temp_name = $_FILES['userfile']['tmp_name'][$q];
        $thefile1 = $_FILES['userfile']['name']['0'];
        $thefile2 = $_FILES['userfile']['name']['1'];
        $thefile3 = $_FILES['userfile']['name']['2'];
        $thefile4 = $_FILES['userfile']['name']['3'];
        $thefile5 = $_FILES['userfile']['name']['4'];
        $thefile6 = $_FILES['userfile']['name']['5'];
        $thefile7 = $_FILES['userfile']['name']['6'];
        $thefile8 = $_FILES['userfile']['name']['7'];
        if (move_uploaded_file($temp_name, $uploaddir.'/'.$thefile))
        {
                $connection = mysql_connect('localhost','*****','*****') 
or die ('Couldn\'t make connection.');
                $db = mysql_select_db('*****', $connection) or die 
('Couldn\'t select database.');
                $sql = "INSERT INTO inventory (
                id, status, stocknum, year, make, model, price, class, 
type, mileage, slides, extcolor, intcolor, awning, generator, bedsize, 
location, description, picname1,          picname2, picname3, picname4, 
picname5, picname6, picname7, picname8
                ) VALUES (
                '', '$_POST[status]', '$_POST[stocknum]', '$_POST[year]', 
'$_POST[make]', '$_POST[model]', '$_POST[price]', '$_POST[class]', 
'$_POST[type]',            '$_POST[mileage]', '$_POST[slides]', 
'$_POST[extcolor]', '$_POST[intcolor]', '$_POST[awning]', 
'$_POST[generator]', '$_POST[bedsize]', 
'$_POST[location]',              '$_POST[description]', '$thefile1', 
'$thefile2', '$thefile3', '$thefile4', '$thefile5', '$thefile6', 
'$thefile7', '$thefile8'
                )";

                $sql_result = mysql_query($sql) or die ('Couldn\'t execute 
query.');
                if (!$sql_result)
                {
                        echo 'Could not add inventory.<p>';
                        exit;
                }

                $invfile = "$thepath/$thefile";
        }
        else
        {
                $invfile = "$thepath/$spacer";
        }
        ?>
        <img src="<?= $invfile; ?>"><br />
        <?php
}
$myid = mysql_insert_id();
mysql_close($connection);
</SNIP>
================================================
Jay Fitzgerald, Design Director
- Certified Professional Webmaster (CPW-A)
- Certified Professional Web Designer (CPWDS-A)
- Certified Professional Web Developer (CPWDV-A)
- Certified E-Commerce Manager (CECM-A)
- Certified Small Business Web Consultant (CWCSB-A)
Bayou Internet - http://www.bayou.com
Toll Free: 888.30.BAYOU (22968)
Vox: 318.338.2034 / Fax: 318.338.2506
E-Mail: [EMAIL PROTECTED]
ICQ: 38823829 / AIM: bayoujf / MSN: bayoujf / Yahoo: bayoujf
================================================  

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php