query works once but dies 2nd time
Posted: Tue Jul 19, 2005 8:02 am
ok i have a loop and it runs this query
in the loop it works perfectly fine the first time but on the second time through the loop i get this error
Check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE fk_user_id = "3"' at line 19
i dont understand cause session userid is "3" and $val is "Commercial and TFP"
here is the whole loop
Code: Select all
$query = '
UPDATE
mdl_work_interest
SET
active = "1"
WHERE
fk_user_id = "'.$_SESSION['userid'].'"
AND
name = "'.$val.'"
';Check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE fk_user_id = "3"' at line 19
i dont understand cause session userid is "3" and $val is "Commercial and TFP"
here is the whole loop
Code: Select all
$query = '
UPDATE
mdl_work_interest
SET
active = "0"
WHERE
fk_user_id = "'.$_SESSION['userid'].'"
';
$do_query = $db->query($query);
foreach ($_POST['worint'] as $key => $val)
{
$query = '
SELECT
*
FROM
mdl_work_interest
WHERE
name = "'.$val.'"
AND
fk_user_id = "'.$_SESSION['userid'].'"
';
$do_query = $db->query($query);
if (mysql_num_rows($do_query))
{
$query = '
UPDATE
mdl_work_interest
SET
active = "1"
WHERE
fk_user_id = "'.$_SESSION['userid'].'"
AND
name = "'.$val.'"
';
$do_query = $db->query($query);
}
else
{
$query = '
INSERT INTO
mdl_work_interest
(
fk_user_id,
name,
active
)
VALUES
(
"'.$_SESSION['userid'].'",
"'.$val.'",
"1"
)
';
$do_query = $db->query($query);
}
}