pedrobcabral Posted July 3, 2007 Share Posted July 3, 2007 <a href="<?php $query_apagar = mysql_query("DELETE FROM contacto WHERE id = '1'");?>">Say hello</a> Why does this code deletes the row when the page loads? It is supposed to only do it then I click on the link. Besides that if I have an echo "something.php" as the link, it will only go to the URL "something.php" after clicking, so I don't know why this different type of behaviour. Any help? Thanks in advance. Quote Link to comment Share on other sites More sharing options...
jscix Posted July 3, 2007 Share Posted July 3, 2007 place the code inside of a external file. whatever.php... then simply link to the file instead of using the code imbedded in the a href Quote Link to comment Share on other sites More sharing options...
ivalmian Posted July 3, 2007 Share Posted July 3, 2007 Lol, all php code is executed at page load. If you want a row deleted only when you click the link you must have something along the lines of main.html <a href="delterow.php">Delete Row FTW!</a> delterow.php <?php $query_apagar = mysql_query("DELETE FROM contacto WHERE id = '1'");?> Quote Link to comment Share on other sites More sharing options...
jscix Posted July 3, 2007 Share Posted July 3, 2007 and it's because the php processor isnt reading the HTML. the php processor begins when it sees <?php..... it performs the action reguardless of what the html surrounding it does.. Quote Link to comment Share on other sites More sharing options...
pocobueno1388 Posted July 3, 2007 Share Posted July 3, 2007 You can't do that with PHP....Do something like this: <?php if (isset($_GET['id'])){ $id = $_GET['id']; mysql_query("DELETE FROM contacto WHERE id = '$id'")or die(mysql_error()); } ?> <a href="<?php echo $_SERVER['PHP_SELF']; ?>?id=1">Say hello</a> Quote Link to comment Share on other sites More sharing options...
pedrobcabral Posted July 3, 2007 Author Share Posted July 3, 2007 All the replies were pretty explanatory, pocobueno1388 nice way to deal with it. Going also to follow your signature suggestion. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.