Code works on page refresh but not frim dif page

sal

Hello

The following code works when I do a page (page2.php) refresh

$ip = getenv(REMOTE_ADDR);
$date=date('YmdHis');

$sql = "INSERT INTO referer (ip, date, referer, browser) VALUES ('$ip', '$date', '$ref', '$brw')";
//echo "$sql";

All values are entered as they should be. BUT..

If I come from page1.php into page2.php, the values are not entered! They do show on the screen though with echo "$sql";

Can anyone help please?
Thanks
Sal

mogster

Hmmmm... do you actually execute the insert?
Like:
$something = mysql_query($sql);

knutm 😉

sal

Yes 🙂

Sorry I should have put that line in the code

sal

I meant to say, yes I did put the code in question and spite of that am still having the problem.

The query is proparly executed. The results are shown as they should on screen when using the echo command. They simply are not inserted in the tables.

Anyone please?

mogster

You're absolutely bankers sure that this sentence is ok?

$sql = "INSERT INTO referer (ip, date, referer, browser) VALUES ('$ip', '$date', '$ref', '$brw')";

I mean that all fields in db exists, have correct names and so on?

If not, I can't see any other possibility than that your mysql-user don't have the right grants.
Don't consider that very likely, but... 😉
It did work on the refresh?

What other code do you have on the page?

knutm