MySQL help please D:

[splap]

Can someone explain to me why this code:

PHP Code:

if (isset($_GET['action']))
{
    if ($_GET['action'] == "delete")
    {
        $sql = "DELETE FROM invest WHERE 'id' = '$id' LIMIT 1";
        $result = mysql_query("DELETE FROM `invest` WHERE `invest`.`id` = 2 LIMIT 1") or die ("Invalid query: " . mysql_error());
    }
} 


Wouldn't delete the page? The connection is working fine because I can select from the table no problem. I can even delete things from other tables from this page if I want to, but I can't delete rows from the 'invest' table...

[warnesey333]

Hm, can I ask why there is a limit?

I'm not sure whether that could be the problem, but if there were 2 records with the same ID, which would it choose to delete?

I cannot see anything different from what I normally do, try running the code in the sql section on phpmyadmin

[splap]

I put the limit because 1) there should not be two rows with the same id, that defeats the purpose and 2) because it should not delete more than one row at a time.

I've tried running the code in the SQL section from phpmyadmin and it works...

[warnesey333]

And the code is definitely getting into the 2 if statements?

[splap]

well I originally set it up so that the first variable is the query, and then I just put mysql_query($query) but that didnt work so I tried it like you see it there.. no help..

[Saints]

Its currently:

"DELETE FROM `invest` WHERE `invest`.`id` = 2 LIMIT 1"

Did you try:

"DELETE FROM `invest` WHERE `id` = 2 LIMIT 1"

After all, if your deleting from invest, I'm presuming id would be based on the invest table in the first place, thus you do not require the additional invest before it.

And are you sure its running the query in the first place? There could be a circumstance where it bypass the if check as the condition was not met.

[splap]

Yes, I tried that query too.

I do think that it's not running the conditional if statement, but I don't know why.. I've tried to change the $_GET['id'] to things like letters and characters that SHOULD generate an error, but it doesn't.

Why would it not run the if statement?

[warnesey333]

Well it will initiate if:

The variable 'action' is set and equals "delete"

You are definitely using GET? it is not posting from a form is it and you are using POST?

[splap]

Nope, I'm using GET. It's in the URL.

PHP Code:

<a href="investments.php?id=<? echo $row['id'] ?>?action=delete"><img src="images/delete.gif" alt="" /></a>

That's the link that's supposed to delete the page

[seoitc]

 if ($_GET['action'] == "delete") 
    { 
              $result = mysql_query("DELETE FROM `invest` WHERE `invest`.`id` = 2 LIMIT 1") or die ("Invalid query: " . mysql_error()); 
    }

try above i think this is code php code error not connection to db error or mysql error. Thanks

[splap]

nope, didn't work

[Silverday]

PHP Code:

if (isset($_GET['action'])) 
{ 
    if ($_GET['action'] == "delete") 
    { 
        $sql = "DELETE FROM invest WHERE `id` = '$id' "; 
        $result = mysql_query($sql) or die ("Invalid query: " . mysql_error()); 
    } 
} 


here it's, by the way are you sure is $id set?

[splap]

yes, I've tried that, and yes I'm sure $id is set

[FGTH]

Check your MySQL privileges (GRANTS)... if the account you're using doesn't have DELETE privileges for the table, you won't be able to DELETE.

SHOW GRANTS FOR CURRENT_USER();

[Silverday]

ohhhh! just replace this

PHP Code:

$result = mysql_query($sql) or die ("Invalid query: " . mysql_error()); 


PHP Code:

mysql_query($sql); 


[splap]

Nope, I tried that already. Don't worry about it, I just told someone else to do it they can figure it out.

I'm almost 100% sure it was a connection problem

[Cabloo]

if (isset($_GET['action'])) 
{ 
    if ($_GET['action'] == "delete") 
    { 
        $sql = "DELETE FROM invest WHERE 'id' = '$id' LIMIT 1"; 
        $result = mysql_query("DELETE FROM `invest` WHERE `invest`.`id` = 2 LIMIT 1") or die ("Invalid query: " . mysql_error()); 
    } 
}

Hey, try changing that to

if (isset($_GET['action'])) 
{ 
    if ($_GET['action'] == "delete") 
    { 
        $sql = "DELETE FROM invest WHERE 'id' = '$id' LIMIT 1"; 
        echo'ATTEMPTED TO DELETE ID: ' . $id;
        $result = mysql_query("DELETE FROM `invest` WHERE `invest`.`id` = 2 LIMIT 1") or die ("Invalid query: " . mysql_error()); 
    } 
}

That'll tell you if it's running or not.
[Removed]