Help with a simple query

[pwesthead]

hi could someone help me with a query.
what i want to do is this,every time a user goes into there control panel 1 is added to a field called visite in the database, what i want is the code for when the visite field in the database reaches 25 it takes them to a order page instead of them going to there control panel.
thanks paul

[earl-grey]

On each page load (or every time user logs in) execute the query:

UPDATE users
   SET visite = visite + 1

And add a check (assuming $user is coming from the database):

if ($user['visite'] >= 25) {
  header('Location: order.php');
  return;
} 

[pwesthead]

Hi thanks for the fast reply.

i have tried the code but no joy if they have visited 25 0r over it still lets them into the control panel and not the order.php page

here is the full code iam using.

$query = "SELECT id FROM mcgallery_members WHERE login = '$private_login' AND password = '$private_pass'AND level = 'admin'";
$res = mysql_query($query);
$verif = mysql_num_rows($res);
if ($verif == 1)
{
if ($_SESSION['visite'] >= 25) {   header('Location: order.php');   return; } 

$date = date("Y-m-d H:i:s");
$query="UPDATE mcgallery_members SET visite=visite + 1, date='$date' WHERE login ='$private_login'";
mysql_query($query);
} 

[earl-grey]

How do you set $_SESSION['visite']?

[pwesthead]

Hi
i have tried

if ($_SESSION['visite'] >= 25) {   header('Location: order.php');   return; } 

if ($private_login' ['visite'] >= 25) {   header('Location: order.php');   return; } 

if ($user['visite'] >= 25) {   header('Location: order.php');   return; } 

but nothing seems to work

[r937]

change your first query from this --

SELECT id FROM mcgallery_members WHERE ...

to this --

SELECT id, visite FROM mcgallery_members WHERE ...

then do your 25 test on the value returned

[pwesthead]

Hi still lets me go to the control panel and not the order page when they have visited 25 times or over been on this 2 days can't understand why it wont work

[earl-grey]

Can you add this line of code before if statement:

echo '<!-- Session Visite: ' . $_SESSION['visite'] . " -->\n"; 

Login to the contol panel several times, view source of the generated page and check what is visite value and whether it increases.

[pwesthead]

If i check the visite field in the database it adds 1 every time i log in no problem

[r937]

If i check the visite field in the database it adds 1 every time i log in no problem

so your problem is ... ?

[pwesthead]

the problem is when they have loged in 25 times i want it to take them to the order.php page and not the index.php page but it does not work

[r937]

did you understand post #6?

[pwesthead]

hi
i put visite in the query but still makes no difference

i thought this would be simple to do but i must have been wrong,because i have been on this problem for 2 days with no joy.

[spikeZ]

Afternoon Paul,

try

$query = "
	SELECT 
		id, visite 
	FROM 
		mcgallery_members 
	WHERE 
		login = '$private_login' 
	AND 
		password = '$private_pass'
	AND 
		level = 'admin'"; 
 
$res = mysql_query($query); 
$verif = mysql_num_rows($res); 
	if ($verif == 1) {
	$rows = mysql_fetch_assoc($res); 
	if ($rows['visite'] >= 25) {   
	 	header('Location: order.php');   
		exit(); 
	} else { 
		$query="
			UPDATE 
				mcgallery_members 
			SET 
				visite=visite + 1, 
				date=current_timestamp
			WHERE 
				login ='$private_login'"; 
		mysql_query($query); 
	}
}

[r937]

in post #3 you showed "the full code"

could you do this again please, to show how you've changed it to test the visite value out of the database?

[r937]

never mind, it looks like spike beat you to it

spike, remove this --

$date = date("Y-m-d H:i:s");

and change this--

date='$date'

to this--

date=current_timestamp

[spikeZ]

Rudy - done and notice the nice formatting of the queries.......

[pwesthead]

Hi spikz
tried your code works great thanks spikz you have helped me with php for about a year now.
thankyou for everyones input
i

[spikeZ]

no problem Paul, happy to help
Did you get why that code worked an the other didnt?