Good ideas needed - a.s.a.p.

**David Robley** · Jul 17 '05, 12:19 AM

Re: Good ideas needed - a.s.a.p.

In article <1QUeb.5832$tv1 .630078@news02. tsnz.net>,
wes.parish@para dise.net.nz says...[color=blue]
> Hi. sorry for the stinger title - I need to know as quickly as possible if
> and where and when it might be possible to set up a php script to read the
> date and/or time, pass the variables on to another part of the script, and
> call an SQL script to delete the variables for that particular row?
>
> I don't know much about php and mySQL, the only thing I've learnt so far is
> that php looks a lot like C and Perl and I've got some books on the full
> SQL standard so my problem with that is not knowing just where mySQL
> diverges...
>
> Any help will be gratefully received.
>
> Thanks.
>
> Wesley Parish[/color]

If - yes, it's possible; where - depends on where you have the required
software/hardware to run it; when - as soon as you start.

You might want to look at the date/time functions and using the resultant
values in a SQL query.

If you have a more specific query, come back to us.

Cheers
--
Quod subigo farinam

$email =~ s/oz$/au/o;
A: Because it messes up the order in which people normally read text.
Q: Why is top-posting such a bad thing?
A: Top-posting.
Q: What is the most annoying thing on usenet?

**Jordan Smith** · Jul 17 '05, 12:20 AM

Re: Good ideas needed - a.s.a.p.

David Robley <robleyd[spam]@ozemail.com.au > wrote in message news:<MPG.19e6c 2d126304d8c9896 ea@news.spiderw eb.com.au>...[color=blue]
> In article <1QUeb.5832$tv1 .630078@news02. tsnz.net>,
> wes.parish@para dise.net.nz says...[color=green]
> > Hi. sorry for the stinger title - I need to know as quickly as possible if
> > and where and when it might be possible to set up a php script to read the
> > date and/or time, pass the variables on to another part of the script, and
> > call an SQL script to delete the variables for that particular row?
> >
> > I don't know much about php and mySQL, the only thing I've learnt so far is
> > that php looks a lot like C and Perl and I've got some books on the full
> > SQL standard so my problem with that is not knowing just where mySQL
> > diverges...
> >
> > Any help will be gratefully received.
> >
> > Thanks.
> >
> > Wesley Parish[/color]
>
> If - yes, it's possible; where - depends on where you have the required
> software/hardware to run it; when - as soon as you start.
>
> You might want to look at the date/time functions and using the resultant
> values in a SQL query.
>
> If you have a more specific query, come back to us.
>
> Cheers[/color]

this is VERY easy... you make it sound so hard ;)

First, get the time using time()
so:
<?
$time=time();

//then run the mySQL query:

mysql_query(DEL ETE FROM tablename WHERE time_field = $time")

?>

**Wesley Parish** · Jul 17 '05, 12:20 AM

Re: Good ideas needed - a.s.a.p.

Jordan Smith wrote:
[color=blue]
> David Robley <robleyd[spam]@ozemail.com.au > wrote in message
> news:<MPG.19e6c 2d126304d8c9896 ea@news.spiderw eb.com.au>...[color=green]
>> In article <1QUeb.5832$tv1 .630078@news02. tsnz.net>,
>> wes.parish@para dise.net.nz says...[color=darkred]
>> > Hi. sorry for the stinger title - I need to know as quickly as
>> > possible if and where and when it might be possible to set up a php
>> > script to read the date and/or time, pass the variables on to another
>> > part of the script, and call an SQL script to delete the variables for
>> > that particular row?
>> >
>> > I don't know much about php and mySQL, the only thing I've learnt so
>> > far is that php looks a lot like C and Perl and I've got some books on
>> > the full SQL standard so my problem with that is not knowing just where
>> > mySQL diverges...
>> >
>> > Any help will be gratefully received.
>> >
>> > Thanks.
>> >
>> > Wesley Parish[/color]
>>
>> If - yes, it's possible; where - depends on where you have the required
>> software/hardware to run it; when - as soon as you start.
>>
>> You might want to look at the date/time functions and using the resultant
>> values in a SQL query.
>>
>> If you have a more specific query, come back to us.
>>
>> Cheers[/color]
>
>
> this is VERY easy... you make it sound so hard ;)
>
> First, get the time using time()
> so:
> <?
> $time=time();
>
> //then run the mySQL query:
>
> mysql_query(DEL ETE FROM tablename WHERE time_field = $time")
>
> ?>[/color]
Thanks heaps! I'll get right onto it!

Wesley Parish
--
First the wife, tone of awe. So much a condition. Kent in the labs, fast
forward. "So how was the worthlessful businessman?" But they hadn't
stopped meat for year ago, that arose hotel facade slowly moved apper.
- Don't let emacs meta-x dissociatedpres s write your speeches!

**Tim Tyler** · Jul 17 '05, 12:21 AM

Re: Good ideas needed - a.s.a.p.

Wesley Parish <wes.parish@par adise.net.nz> wrote or quoted:
[color=blue]
> I don't know much about php and mySQL, the only thing I've learnt so far is
> that php looks a lot like C and Perl and I've got some books on the full
> SQL standard so my problem with that is not knowing just where mySQL
> diverges...[/color]

PHP looks a /lot/ like C/C++.

I had *hoped* we had got away from all those "::" and "->" back in 1995
(when Java came out) - but it looks like the hangover is proving to be
a persistent one :-(
--
__________
|im |yler http://timtyler.org/ tim@tt1lock.org Remove lock to reply.

Good ideas needed - a.s.a.p.

Good ideas needed - a.s.a.p.

Comment

Comment

Comment

Comment