[Wolves] Php question

[Wayne Morris]

On Mon, 2005-01-17 at 20:24, Alan Pope wrote:
> On Mon, 17 Jan 2005 20:19:45 +0000, Wayne Morris <wayne at machx.co.uk> wrote:
> >         $time = time();
> >         $result = mysql_query( "SELECT ad_id, cat_id, subject, add_date FROM
> > ads WHERE exp_date>$time ORDER BY add_date DESC LIMIT 20" ) or error(
> > mysql_error() );
> 
> > Can anyone see why it breaks at the point it does, the page works fine
> > on its own.
> 
> I'm no PHP exprt but should it be
> 
> ..... exp_date>".$time." ORDER .....
> 
> ?

Didn't seem to make any diff either way.

I think I'm going at this the wrong way tho.
The php page that i want to be displayed is being entered into $message
field of the emailer page.
So I guess the email page probably just wants to send the entire page as
text or html, rather than perform more php/mysql operations and then
send the results.  
Can anyone confirm that this is what will happen.
I guess what I need to do is merge the two pages together properly, do
the db look up and then put the result into $message.

Right this should be fun!