[PHP] need a new challenge

[php-editors.com]

Im looking for ideas for a 2 programming contests.
What I need is a very basic challenge - that new php programmers can 
do, but involves them mixing there thinking/programming and creative 
abilities.
I also need a challenge for professional programmers - something that 
involves lots of thought, tests their problem solving ability and code 
useage.
I would be very glad to hear your ideas on this.

Stuart

|-|
|- www.php-editors.com|
|- php programming contests   |
|- php tool reviews   |
|- php everything else|
|-|


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP] need a new challenge

[php-editors.com]

George,

Thanks for your idea, I do like it - the only problem is that sound 
very much like the current beginners contest (phone book and diary) - 
great minds think alike :) - it sound like you may be able to tweek 
your code and enter it in the contest !!

I will be adding a repository for php apps in the future - i only have 
a code snippet library (for single scripts) live.

cheers,
Stuart


> Stuart,
> 
> How about a group diary.
> 
> I built a diary for my workgroup, it uses frames, has a frame for 
favourite
> links, a frame with a small calendar and the main frame holds the 
group
> diary.
> 
> Every Friday morning each member of the group is sent an HTML 
formatted
> email with their own diary for the following wee, followed by a diary
> listing the other groupmembers appointments. It took me a week 
starting from
> scratch and I still consider myself a novice.
> 
> This is something that covers several aspects of php coding, how it 
fits
> within webspace and how it deals with email and scheduling.
> 
> Mine is setup on Win NT.
> 
> If you want I can send you my code.
> 
> George in Oxford
> 
> > -Original Message-
> > From: php-editors.com [mailto:[EMAIL PROTECTED]
> > Sent: 14 March 2003 10:13 am
> > To: [EMAIL PROTECTED]
> > Subject: [PHP] need a new challenge
> >
> >
> >
> > Im looking for ideas for a 2 programming contests.
> > What I need is a very basic challenge - that new php programmers can
> > do, but involves them mixing there thinking/programming and creative
> > abilities.
> > I also need a challenge for professional programmers - something 
that
> > involves lots of thought, tests their problem solving ability and 
code
> > useage.
> > I would be very glad to hear your ideas on this.
> >
> > Stuart
> >
> > |-|
> > |- www.php-editors.com|
> > |- php programming contests   |
> > |- php tool reviews   |
> > |- php everything else|
> > |-|
> >
> >
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
> >
> 
> 
> 

|-|
|- www.php-editors.com|
|- php programming contests   |
|- php tool reviews   |
|- php everything else|
|-|


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] php/mySQL time comparison

[php-editors.com]

Try quoting your dates - you could also edit your code by using the 
BETWEEN SQL keywors.

hope this helps

|-|
|- www.php-editors.com|
|- php programming contests   |
|- php tool reviews   |
|- php everything else|
|-|

> Hi all,
> 
> I have been tearing my hair out for weeks with this problem, hope 
someone
> can help. 
> 
> I want to pull all data out of a mysql table that falls between two 
dates (a
> start-time and end-time).
> 
> I use PHP to allow the user to specify the time interval, creating 2
> variables 
> 'startTime' and 'endTime'. These are formatted thus: 2002-02-25 
00:00:00
> (-MM-DD HH:mm:ss).
> 
> I then use the syntax:
> $query = "select * from Job_TB where teamNo = $teamNo AND startTime >=
> $timeFrom AND endTime <= $timeTo";
> $result = mysql_query($query,$db) or die ("somethings wrong");
> 
> to query the mysql DB. But it doesnt work. Is there a glaring error 
in my
> syntax? 
> 
> Can anyone help with this as its driving me nuts
> 
> Hope someone can help, thanks in advance,
> brad
> Cheers,
> 
> Brad 
> 
> 
> Nel vino la verità, nella birra la forza, nell'acqua i bacilli
> --

> In wine there is truth, in beer there is strength, in water there are
> bacteria
> 
> 
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php