I don't understand

nomad9

I've got a button that link to a script page, that contain just php4 code, no html.

This page is supposed to update my db and redirect toward another page.

But when i click on the button, the only thing i see is my script ???
And the browser don't redirect me ...

Why???

hkucsis

That is because the PHP script is NOT executing, make sure you have properly installed PHP...

ofSHIZ

Umm.. I don't want to be rude or anything.. but.. maybe you could include the code with PHP tags around it??

nomad9

here's my link :

<a href="php/tracker.php?link=elite" ...

here's the code (tracker.php):

<?
//Connect DB 
$db = mysql_connect('localhost', 'xxxxxx', 'xxxxxx');
mysql_select_db('cabanon',$db);

//Update Stats
$sql = "UPDATE Stats SET Click=Click+1 WHERE StatsName = '".$link."'";
$result = mysql_query($sql,$db) or die(mysql_error()); 

//Redirection
header ("Location: '".$link."'.php4");

//Disconnect DB
mysql_close();
?>

I change the extension tracker.php4 to tracker.php and now it goes like this :

Warning: mysql_connect() [function.mysql-connect]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /home/www/cabanons.com/v2/php/tracker.php on line 3

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /home/www/cabanons.com/v2/php/tracker.php on line 4

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/www/cabanons.com/v2/php/tracker.php on line 8
Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

?????

ofSHIZ

check if your MySQL server is up and running...

nomad9

the prob is that my client is on an hosting cie .... so i guess i'll just wait until tomorrow and call support ;(

Thanx ofSHIZ for the help

Steve

ofSHIZ

No prob.. reply back and I'll help when I can..

cgraz

i'd also get in the habit of using mysql_error() to see what the problem is. But if you have the correct username, password, and server, then contact your host and they'll help you out.

Cgraz