Hi Guys,
No need to think about this.
I solved the problem by putting both scripts under one check
If ($patternThreads || $patternFabrics)
{
//DO STUFF HERE
}
Aaron
-Original Message-
From: Aaron Wolski [mailto:[EMAIL PROTECTED]
Sent: July 22, 2003 10:34 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] why script only updating one table?
Hi All,
I have a form that passes to select box array to my script. Select boxes
are named:
patternThreads[] and patternFabrics[]
My Script:
//Check to see if Threads were selected for this pattern
if ($patternThreads)
{
if (is_array($patternThreads))
{
$str_threads =
implode(,,$patternThreads);
}
else
{
$str_threads = $patternThreads;
}
$threadsArray = explode(,,$str_threads);
for ($i=0;$isizeof($threadsArray);$i++) {
//Grab a listing of all threads
currently in the DB
//associated with the pattern
$allthreadsQuery = db_query(SELECT id FROM kcs_patternthreads WHERE
pattern_index='$id' AND thread_index=.escapeValue($threadsArray[$i]));
//Does a record already exist?
if (db_numrows($allthreadsQuery) 1)
{
//No? Insert a new
record for each new keyword selected
db_query(INSERT INTO kcs_patternthreads
(id,pattern_index,thread_index,avail) VALUES
('','$id',.escapeValue($threadsArray[$i]).,'0'));
}
}
//Check to see if a thread was unchecked.
//If so, delete entry from DB
$db_threads1 = db_query(SELECT * FROM kcs_patternthreads WHERE
pattern_index='$id');
while($db_threads2 = db_fetch($db_threads1))
$db_threads[] = $db_threads2[thread_index];
foreach($db_threads AS $thread) {
if(!in_array($thread, $threadsArray))
db_query(DELETE FROM kcs_patternthreads WHERE pattern_index='$id' AND
thread_index='$thread');
}
}
//Check to see if fabrics were selected for this pattern
if ($patternFabrics)
{
if (is_array($patternFabrics))
{
$str_fabrics =
implode(,,$patternFabrics);
}
else
{
$str_fabrics = $patternFabrics;
}
$fabricsArray = explode(,,$str_fabrics);
for ($i=0;$isizeof($fabricsArray);$i++) {
//Grab a listing of all fabrics
currently in the DB
//associated with the pattern
$allfabricsQuery = db_query(SELECT id FROM kcs_patternfabrics WHERE
pattern_index='$id' AND fabric_index=.escapeValue($fabricsArray[$i]));
//Does a record already exist?
if (db_numrows($allfabricsQuery) 1)
{
//No? Insert a new
record for each new keyword selected
db_query(INSERT INTO kcs_patternfabrics
(id,pattern_index,fabric_index,avail) VALUES
('','$id',.escapeValue($fabricsArray[$i]).,'0'));
}
}
//Check to see if a fabric was unchecked.
//If so, delete entry from DB
$db_fabrics1 = db_query(SELECT * FROM kcs_patternfabrics WHERE
pattern_index='$id');
while($db_fabrics2 = db_fetch($db_fabrics1))
$db_fabrics[] = $db_fabrics2[fabric_index];
foreach($db_fabrics AS $fabric) {
if(!in_array($fabric, $fabricsArray))
db_query(DELETE FROM kcs_patternfabrics WHERE pattern_index='$id' AND
fabric_index='$fabric');
}
}
The scrip is supposed to see if either select box contains data and then
process the data.
Does anyone understand why it would be updating only one table at a time
and not both at the same time? It should be updating both at the same
time!
NOTE: if I remove the processing code for either select box it works
without problem. They just don't seem to work together.
Thanks!
Aaron
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
