Mysql Query Problem

[Areastore]

Hi,

I enter a query mysql going to count visits to each detail page in this way:

<%php%>
$db_host = "";
$db_user = "";
$db_password = "";
$db_name = "";

$db = mysql_connect($db_host, $db_user, $db_password);
mysql_select_db($db_name, $db);
$query="UPDATE idx_link set hits2 = hits2 + 1 where link_id = '<%$link_id%>'";
$ris=mysql_query($query, $db);


<%/php%>


The problem is that the variable "$link_id" is not valued and the number of visits is not increased.

I tried to manually assign the value to $link_id and in this way it works.

$query="UPDATE idx_link set hits2 = hits2 + 1 where link_id = '1210'";


Why the variable $ link_id is not valued?

Where mistake?


Thanks

[FSGDAG]

What file / page are you trying to add this to??? More than likely, the problem is that $link_id is bot being passed to the page your trying to add the code to.

[Areastore]

Thanks for your answer ..........

This page is detail_link.html, it seems that $link_id not be valued in the query.

Thanks

[Bruceper]

<%php%>
$db_host = "";
$db_user = "";
$db_password = "";
$db_name = "";

is all completely un-necessary unless you're connecting to a different database than IndexU already does. That information is already supplied by the include of application.php

$link_id is a valid variable IF you are reading detail.php. My guess is that your php is running before the variables are set.

[Areastore]

Hi Bruce, thank you for your reply.

I can not understand, if the code php is positioned to the top detail_link.html the variable $link_id in the query should valorise.

I do not know what to think more

[Bruceper]

I'm not a programmer, but get rid of the database connection part and it may just work. What I"m thinking is that because you're bypassing application.php you are no longer including any files and there is nowhere to pull the variables from.

[Areastore]

It seems that the variable $link_id not be exploited within tag <%php%> <%/php%> and honestly I can not understand the reason for this error!

How do I work around the obstacle?


Thanks