Quick Help...

[erikhillis]

I have a links database... when you click on a link, it goes to links2.php?id=(whatever link id it is) where it updates the number of hits... how do I then redirect a visitor to the url, which is row #2

<?php 
// connect to mysql database 
$db = mysql_connect("localhost","jointops_site","pw");
mysql_select_db (jointops_site);
// Ask the database for the information from the dl's table
$query = "UPDATE links SET hits = hits + 1 WHERE id='" . $_GET['id'] . "'"; 
$result = mysql_query($query) or die(mysql_error()); 

// send the file (hopefully you knows how to do this...) 
echo "<a href= '$rows[2]' target= '_new'>If you are now redirected, click here...</a><br>";
echo "<meta http-equiv= 'refresh' content= '0; url= $rows[2]'>";

?> 

echo "<meta http-equiv= 'refresh' content= '0; url= $rows[2]'>"; does not work at all... pls help

[stolzyboy]

<?
header("Location: $rows[2]");//if $rows[2] holds something like pageid.php or a full filename
?>

[erikhillis]

dosnt work ?

[stolzyboy]

what does it do

what does it show when you do

echo $rows[2]

[erikhillis]

I got it... had to do this though...

<?php 
// connect to mysql database 
$db = mysql_connect("localhost","jointops_site","pw");
mysql_select_db (jointops_site);
// Ask the database for the information from the dl's table
$query = "UPDATE links SET hits = hits + 1 WHERE id='" . $_GET['id'] . "'"; 
$result = mysql_query($query) or die(mysql_error()); 

// send the file (hopefully you knows how to do this...) 
echo "Your being redirected";

?> 


<?php
// Connect to the database
$db = mysql_connect("localhost","jointops_site","pw");
mysql_select_db (jointops_site);
// Ask the database for the information from the squadlinks table
$sql = "SELECT * FROM links WHERE id='{$_REQUEST['id']}'";
if (!$result = mysql_query($sql)) {
    print "Invalid query ($sql) : " . mysql_error();
    exit;
}
while ($row = mysql_fetch_assoc($result)) {

print "
<meta http-equiv= 'refresh' content= '0; url= {$row['url']}'>";
} 

?>

[tekky]

Originally posted by erikhillis
dosnt work ?

header() requires full web address for future reference 😉

Note: HTTP/1.1 requires an absolute URI as argument to Location: including the scheme, hostname and absolute path, but some clients accept relative URIs. You can usually use $SERVER['HTTP_HOST'], $SERVER['PHP_SELF'] and dirname() to make an absolute URI from a relative one yourself:

[stolzyboy]

Originally posted by tekky
but some clients accept relative URIs

did you read that part, I have never used full path's, either on a hosted site, or on my own development sites

[tekky]

Originally posted by stolzyboy
did you read that part, I have never used full path's, either on a hosted site, or on my own development sites

doh, I did miss that, my bad 🙁

[stolzyboy]

oh well, life goes on 😃