I remember I had a similar problem, and did all the changes suggested here, but the script actually only worked after I restarted the machine (my machine was relocated...so it was a complete...

Cool...I'll try that way...I'll keep you posted...

Hi Nav33n,

I followed your advice and I got it to work. Thanks alot...
:)

I got the problem sorted out...honestly I did not do anything to it...what happened is that a technician came and installed the cd/dvd writer on the machine, I started the machine and loaded...

Hello Everyone,

Scenario:
I have an application where users are required to register to gain access. I want to set an 'automatic timer' on their access so that after 1 month, their access level...

Hi kkeith29,

Thanks so much, it works now...I did try using the &&, but not !==, and since that didn't work, I posted it here...thanks again...:)

May

Hi All,

Could you help/guide me accordingly please...My intentions with this piece of code is for the relevant image to display with the respective user...my problem is that it doesn't work for...

I think he meant http://www.shortsurvey.here.ws/

Hi R0bb0b,

I echoed my $query and this is how it looks:


SELECT * FROM tsttbills where DATE_FORMAT(billDate, '%b-%e-%Y') between 'Nov-1-2007' and 'Nov-9-2007'


When I copied this query...

Hello R0bb0b,

I was able to remove the testGCR.php code from the results page and I tested it with the following data:


Start Date = Nov-1-2007
End Date = Nov-1-2007
I got all the records...

Strange?!? :-/ ...I'm just editing my script with the changes you said to, and saving it in the folder on the server...and running it on the browser...I selected the dates from the pop-up calender,...

Hi R0bb0b,

Firstly, let me thank you for all that you've done till now, I am truely grateful for your guidance.... :)

Now the problem at hand:
I made the necessary changes and it works to an...

.
.
.
include('./connect.php');
global $conn;

// Start our query of the database
$query = "SELECT * FROM tsttbills where DATE_FORMAT(billDate, '%b-%e-%Y') >= '$sDate' and...

but the connection script works properly for all the other parts of the application...

Here is the code....and still nothing shows...

.
.
.
include('./connect.php');
global $conn;

// Start our query of the database
$query = "SELECT * FROM tsttbills...

I have those 2 statements already...and it doesn't echo anything...

I think the problem lies here


$sql = mysql_query($query, $conn);

it doesn't echo anything, but if I remove the $conn, I get the "Resource ID#6" error being displayed...:confused: :confused:...

I added it here:

.
.
.
include('./connect.php');
global $conn;

// Start our query of the database
$query = "SELECT * FROM tsttbills where DATE_FORMAT(billDate, '%b-%e-%Y')...

*sigh*...ok, so I looked over the syntax in the db manager program, and I realized that I actually copied it twice and then tried to execute that...:$ :icon_redface: :$

It works, and I am getting...

here is the error message:

In my DB Manager.......you mean MySQL Query Browser?

if that's what you mean.....then here is the error message:

Did that and I am still getting:

Er....well, I changed this:

my input box on the form

<a href="javascript:NewCal('sDate','mmmddyyyy')"><img src="images/cal.gif" width="16" height="16" border="0" alt="Pick a Start Date"></a>
...

I have done what you said to, and here is the result:


SELECT * FROM tsttbills where DATE_FORMAT(billDate, '%e-%m-%Y') >= '11-1-2007' and DATE_FORMAT(billDate, '%e-%m-%Y') <= '11-1-2007'

...

yes i did, this is what I see after clicking the generate button...

So this is my changed chunk of code:

.
.
.
include('./connect.php');
global $conn;

// Start our query of the database
$query = "SELECT * FROM tsttbills where...

Why don't you post your code, then we may be able to assist...

Here is the output:

I commented off most of the code for it to echo the sql...here is the edited code:

.
.
.
function parseCSVComments($comments)
{
// First off escape all " and make them "" ...

When I echoed the query statement, I am getting a runtime error on the browser, and all the browser windows closed after...here is the code:


gcrFunction.php


<?
include('./connect.php');
...

I am still getting the entire table of data, and the data within the dates selected...

Thanks for that link....I understand now what you were trying to say before...
:):):)

Question

Could I change "SELECT * FROM tsttbills where DATE_FORMAT(billDate, '%e-%m-%Y') >= '$sDate' and...

Would that require me changing the date format in the javascript or something? because there is the little calendar icon next to the input box that I would click and select the date, the date is then...

Here is the result after i ran the script....the dates i entered for the search were: 1-11-2007 and 9-11-2007...

Ok, So I did a little changing in the $sql syntax from $sql = mysql_query("SELECT * FROM tsttbills where DATE_FORMAT(date, '%d-%m-%Y') >= '$sDate' and DATE_FORMAT(date, '%d-%m-%Y') <= '$eDate'",...

testGCR.php


<?php
error_reporting(E_ALL ^ E_NOTICE);
include("./gcrFunction.php");
if(count($_POST['btnSubmit']) == 0)
{
?>

Ok, Well now that the data is consistent, the testGCR.php still doesn't work....

Oho.......I see.......

R0bb0b, why are you sweating so much:?:

Hey R0bb0b,

I tried your first method, and it worked perfectly....

the date in the database looks like "2007-11-06"