[RESOLVED] page redirect based on query?

BEFOR

Is it possible to have a page automatically redirect as the result of a query?

This will be for an interim page, placed before the login landing page.

Those users that are paid for, will be automatically redirected. Those that aren't will have scaled question-response actions (echoes placed on interim page)

How might a page look like based on a query? Would this be a meta refresh? If not how else could this be done based a query that would automatically redirect? - don't intend to be vague in what is supplied in the question (below) but since I'm not sure how this might be structured, I don't know what might be required. Any real-world example, much appreciated.

note: will send users to "interim" page directly from the login. There are date ranges that each user must fall between to use the service/automatically reach the landing page.

WHERE (CURRENT_DATE () =< CRTrial) OR ((CURRENT_DATE () =< CREnddate)AND CRPaid=='2'))

Weedpacket

1) Yes, it is possible.

2) However you want it to look.

3) Why bother when there's [man]header[/man]('Location: URI');?

Running a database query and page redirection are two entirely different things. If you undestand one and you understand the other then there's nothing more to learn about putting the two together.

BEFOR

thanks Weedpacket,

<?php if (((CURDATE () <=($row_Calm['CRTrial'].'30 days')) AND ($row_Calm['CRPaid']==''))
header{"Location: http://www.mysite.com/web/entry.php?view=able"};?>

gives: parse error on the header portion. 'unexpected T_STRING in...'

As does:

<?php if (((CURDATE () <=($row_Calm['CRTrial'].'30 days')) AND ($row_Calm['CRPaid']==''))
header{"Location: http://www.mysite.com/web/entry.php?view=able". $_SERVER['HTTP_HOST']
                     . rtrim(dirname($_SERVER['PHP_SELF']), '/\\')
                     . "/" . $relative_url}
;?>

Any ideas why?

BEFOR

Must include at head
<?php ob_start(); ?>

and within the code (end flush):

<?php if (((CURDATE () <=($row_Calm['CRTrial'].'30 days')) AND ($row_Calm['CRPaid']==''))
header("Location: http://www.mysite.com/web/entry.php?view=able");
ob_end_flush();
?>