On Thu, Oct 2, 2008 at 12:35 PM, Jason Pruim <[EMAIL PROTECTED]> wrote:
> Hi Everyone,
>
> I am working on a app where I need to be able to select all the values from
> a database where the 'timein' field is between a certain date range...
> Essentially the last 7 days...
>
> here is the code that
On Tue, Oct 7, 2008 at 9:16 PM, Chris <[EMAIL PROTECTED]> wrote:
> Dan Joseph wrote:
>>
>> On Thu, Oct 2, 2008 at 12:35 PM, Jason Pruim <[EMAIL PROTECTED]> wrote:
>>
>>> SQLTEST: SELECT * FROM `timeStore` WHERE`timein` BETWEEN
>>> 1222315200 AND 122292
>>> Could not perform query:
Dan Joseph wrote:
On Thu, Oct 2, 2008 at 12:35 PM, Jason Pruim <[EMAIL PROTECTED]> wrote:
SQLTEST: SELECT * FROM `timeStore` WHERE`timein` BETWEEN
1222315200 AND 122292
Could not perform query: Query was empty
<[EMAIL PROTECTED]>
Put a ' around your timestamp numbers. I
On Oct 2, 2008, at 1:45 PM, Robbert van Andel wrote:
In the original message you were assigning the query to $SQLTEST,
but in the code below you're using $sql.
It was a clean up... I had a working query... $sql so in attempting to
improve this I didn't want to lose the original sql so I de
Jason Pruim wrote:
>
> On Oct 2, 2008, at 12:39 PM, Per Jessen wrote:
>
>> Jason Pruim wrote:
>>
>>> Hi Everyone,
>>>
>>> I am working on a app where I need to be able to select all the values
>>> from a database where the 'timein' field is between a certain date
>>> range... Essentially the last
On Oct 2, 2008, at 1:31 PM, Robbert van Andel wrote:
What is the actual code that you use to run the query. You've shown
us how you set up the query but not more.
Something like
$result = mysql_query($query,$conn);
Here is the code I use:
$row[]= mysql_query($sql) or die("Could not pe
In the original message you were assigning the query to $SQLTEST, but in the
code below you're using $sql.
On Thu, Oct 2, 2008 at 10:40 AM, Jason Pruim <[EMAIL PROTECTED]> wrote:
>
> On Oct 2, 2008, at 1:31 PM, Robbert van Andel wrote:
>
> What is the actual code that you use to run the query. Y
Dan Joseph wrote:
On Thu, Oct 2, 2008 at 12:35 PM, Jason Pruim <[EMAIL PROTECTED]> wrote:
SQLTEST: SELECT * FROM `timeStore` WHERE`timein` BETWEEN
1222315200 AND 122292
Could not perform query: Query was empty
<[EMAIL PROTECTED]>
Put a ' around your timestamp numbers. I
On Thu, Oct 2, 2008 at 12:35 PM, Jason Pruim <[EMAIL PROTECTED]> wrote:
>
>SQLTEST: SELECT * FROM `timeStore` WHERE`timein` BETWEEN
> 1222315200 AND 122292
> Could not perform query: Query was empty
>
> <[EMAIL PROTECTED]>
Put a ' around your timestamp numbers. I think that
What is the actual code that you use to run the query. You've shown us how
you set up the query but not more.
Something like
$result = mysql_query($query,$conn);
Robbert
On Thu, Oct 2, 2008 at 10:17 AM, Jason Pruim <[EMAIL PROTECTED]> wrote:
>
> On Oct 2, 2008, at 12:46 PM, Jim Lucas wrote:
>
On Oct 2, 2008, at 1:17 PM, Jason Pruim wrote:
On Oct 2, 2008, at 12:46 PM, Jim Lucas wrote:
Jason Pruim wrote:
Hi Everyone,
Could not perform query: Query was empty
This would tell me that the variable that you are passing to your
function
call is either empty or not set. Maybe a t
On Oct 2, 2008, at 12:46 PM, Jim Lucas wrote:
Jason Pruim wrote:
Hi Everyone,
Could not perform query: Query was empty
This would tell me that the variable that you are passing to your
function
call is either empty or not set. Maybe a typo.
Hi Jim,
Wouldn't that have shown up in th
On Oct 2, 2008, at 12:39 PM, Per Jessen wrote:
Jason Pruim wrote:
Hi Everyone,
I am working on a app where I need to be able to select all the
values
from a database where the 'timein' field is between a certain date
range... Essentially the last 7 days...
SELECT * FROM timeStore WHERE
Jason Pruim wrote:
> Hi Everyone,
>
> Could not perform query: Query was empty
>
This would tell me that the variable that you are passing to your function
call is either empty or not set. Maybe a typo.
--
Jim Lucas
"Some men are born to greatness, some achieve greatness,
and some
Jason Pruim wrote:
> Hi Everyone,
>
> I am working on a app where I need to be able to select all the values
> from a database where the 'timein' field is between a certain date
> range... Essentially the last 7 days...
>
SELECT * FROM timeStore WHERE timein>DATE_SUB(now(),INTERVAL 7 DAYS)
/
Hi Everyone,
I am working on a app where I need to be able to select all the values
from a database where the 'timein' field is between a certain date
range... Essentially the last 7 days...
here is the code that I am working with:
$rangeBegin = strtotime("Last week thursday midnig
16 matches
Mail list logo
