Execute a Mysql Query when hyperlink clicked

[Vivid Lust]

With the codes here how could i run a mysql cuery when the hyperlink is clicked?

 

This is so that i can add the amount of hits to the database

 

Thanks.

[p2grace]

The ideal way would be to use ajax (I prefer xajax).  Otherwise the best way is to have it refresh the page with a get variable attached, and then run the query based off of the $_GET Variable.

 

Example:

 

<?
if(isset($_GET['command'])){
$command = $_GET['command'];

$query = "SELECT ... WHERE `field` = '$command'";
$run = mysql_query($query);

}
?>

<a href="#" onclick="window.location='filename.php?command=runQuery; return false;">Run Query</a>

 

You'd have to write the query to do whatever it is you need.  But that shows you an example of having a link run a php command.

[Vivid Lust]

Could you give an example with the following code to add +1 to hits?? Thanks

 

//connects to mysql .... then
$query = mysql_query( "SELECT id, image, url FROM banner WHERE id = '{$_GET['id']}'" )
or die(mysql_error());
$row = mysql_fetch_assoc($query);

echo( "<a target=_blank href=" );
echo $row['url'];
echo( ">" );
echo( "<img border=0 src=" );
echo $row['image'];
echo( ">" );
echo( "</a>" );
?>