Okay I have gotten my Mysql php to display the links. right now i am trying to complete a redir page and so far just to have it redir is not working.

PHP Code:

<?
require_once("../config/mysql.php");
$linkid = $_GET['id'];

$res = "SELECT link FROM links WHERE id='$linkid'";
$subres = mysql_query($res) or die(mysql_error());

while ($row = mysql_fetch_array($subres)) {
$link = $row['link'];
echo $link;
header("Loacation:" . $link ."");

}

?>

The echo $link works. just not the redir. and according to the php.net manual that is how it needs to be.

Once i can get it to redir is when i will have it add a count to the mysql db to show how many clicks the link has recived

Loacation

should be:

Location

shi* my bad.

If Im thinking straight, though maybe not... 5:43AM :P, that header() will return an error. Headers arent meant to be declared before any HTML output on the page, including plain text... Should be an "Error, headers already sent" or something similar error. To fix this, add the header line BEFORE the "echo $link;" line.

the header did work until i started adding the functions for the counter on it

Right now this draws a blank page and does nothing

PHP Code:

<?
require_once("../config/mysql.php");
$linkid = $_GET['id'];

$res = "SELECT * FROM links WHERE id='$linkid'";
$subres = mysql_query($res) or die(mysql_error());

while ($row = mysql_fetch_array($subres)) {
$link = $row['link'];
$update = $row['link_clicked'];

}
$link_update = $update + 1;
$res0 = "UPDATE links SET link_clicked='$link_update' WHERE id='$linkid'";
mysql_query($res0);
header("Location:" . $link ."");
?>

never mind. i got it working.

Very very simple