Reloading PHP file

[Ghezzo]

Hello, I have tried to reload a PHP file using jquery for a while now, the PHP file contains a mysql_query that currently gets a number from the database.

 

$result = mysql_query("SELECT * FROM job");
while($row = mysql_fetch_array($result))
{
$test = $row['test'];
}
echo $test;

 

It shows the number the first time, but when I reload it using jquery it's shows up empty.

I have used jquery .load and I can see, when using fadeout and fadein, that the div is "reloaded", but the PHP file returns nothing and theres no error in firebug.

 

 

Also,

mysql_query("UPDATE job SET test = test + 1");

 

updates the number, and I want to get the updated number.

 

 

Sorry if its hard to understand me, but what I need to do is get the updated number when the mysql_query have been run.

 

[Ghezzo]

Can't seem to edit my post, but I fixed it. I forgot to connect to the database in the PHP file that was reloaded.