Im having problem writing my cms. The part thats not working is the delete part...
<?php
session_start();
include 'config.php';
include 'opendb.php';
$_SESSION['modifyform'] = $_POST;
$modifycat = $_POST['modifycat'];
if(isset($_GET['del']))
{
$query = "DELETE FROM {$_SESSION['modifyform']['modifycat']} WHERE id = '{$_GET['del']}'";
mysql_query($query) or die('Error : ' . mysql_error());
exit;
}
?>
Ive searched everywhere but no solution
the error i come up with is
Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE id = '3'' at line 1
If i put a table name where "{$_SESSION['modifyform']['modifycat']}" , it works fine.
I use the same variable in a "SELECT FROM" query, and it works fine, if i echo "{$_SESSION['modifyform']['modifycat']}" it comes up with the correct value
this is the link which calls the query
<a href="javascript:delArticle('<?php echo $id;?>', '<?php echo $item_name;?>');">delete</a>
and heres the javascript
<script language="JavaScript">
function delArticle(id, item_name)
{
if (confirm("Are you sure you want to delete '" + item_name + "'"))
{
window.location.href = 'modify.php?del=' + id;
}
}
</script>
Can anyone point me in the right direction?
DELETE FROM WHERE help....
Moderator: General Moderators
- Kieran Huggins
- DevNet Master
- Posts: 3635
- Joined: Wed Dec 06, 2006 4:14 pm
- Location: Toronto, Canada
- Contact:
Re: DELETE FROM WHERE help....
Yeah, ive started the session, its my very first line of code....
if i echo "$_SESSION['modifyform'] = $_POST;" outside of this code
"""""""""""""""""""""""""""""""""""""
if(isset($_GET['del']))
{
$query = "DELETE FROM {$_SESSION['modifyform']['modifycat']} WHERE id = '{$_GET['del']}'";
mysql_query($query) or die('Query sent: ' . $query . '<br><br>Error : ' . mysql_error());
exit;
}
""""""""""""""""""""""""""""""""""""
it prints the value...but as soon as it goes between that code...it doesnt print anything? the only thing i can think of is the get and post are conflicting, but i thought even if i store the post value in another variable...and place it in..it will work..but that doesnt work either? any ideas?
if i echo "$_SESSION['modifyform'] = $_POST;" outside of this code
"""""""""""""""""""""""""""""""""""""
if(isset($_GET['del']))
{
$query = "DELETE FROM {$_SESSION['modifyform']['modifycat']} WHERE id = '{$_GET['del']}'";
mysql_query($query) or die('Query sent: ' . $query . '<br><br>Error : ' . mysql_error());
exit;
}
""""""""""""""""""""""""""""""""""""
it prints the value...but as soon as it goes between that code...it doesnt print anything? the only thing i can think of is the get and post are conflicting, but i thought even if i store the post value in another variable...and place it in..it will work..but that doesnt work either? any ideas?