I Want To Make A Link, That Runs A ySql Query When Pressed [Please Help]

[-CrAzY-]

Ok, I Want To Make A PHP Text Link, When You Press The Text Link, It Runs A MySql Query, Can Someone Post The Coding

 

Thank You!

[HuggieBear]

This is a help forum, if you want someone to write it for you, then you should look in the PHP Freelance forum.

 

Regards

Huggie

[-CrAzY-]

Cheers, Sorri Im New

[Fadion]

<?php
echo "<a href=\"mypage.php?query=true\">Run Query</a>";
if(isset($_GET['query']) and $_GET['query'] == 'true'){
    $query = mysql_query('SELECT * FROM table');
}
?>

 

Assume u have mypage.php. When u click the link the page refreshes and becomes mypage.php?query=true. The part after the '?' is the url variable and its value. With the code im checking if the url variable is set, if so run the query. Hope its clear.