RE: [PHP] MySQL Query Help!!!!
| From: | Chris Kay | Date: | Fri, 14 Jun 2002 03:40:06 +0000 |
| Subject: | RE: [PHP] MySQL Query Help!!!! | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-102137@lists.php.net to get a copy of this message | ||
> The query does not error out it just does not give any records, and I
Know
What part of "The query does not error out" do you not understand.
Why are there so many people willing to say what is wrong with a code but when it comes to
A solution that go silent.
I find that the ones most often to find flaws in someones code, are the ones who never provide
Answers.
---------------------------------------------------------------------------
Chris Kay
Technical Support - Techex Communications
Website: www.techex.com.au Email: chris.kay@techex.net.au
Telephone: 1300 88 111 2 - Fax: (02) 9970 5788
Address: Suite 13, 5 Vuko Place, Warriewood, NSW 2102
Platinum Channel Partner of the Year - Request DSL - Broadband for Business
---------------------------------------------------------------------------
> -----Original Message-----
> From: John Holmes [mailto:holmes072000@charter.net]
> Sent: Friday, 14 June 2002 1:26 PM
> To: Chris Kay; 'PHP General List'
> Subject: RE: [PHP] MySQL Query Help!!!!
>
>
> Man, where do I start. There could be so many things wrong.
> First of all, this is a PHP list, not MySQL. Second, use
> MySQL_error() after you issue a query to see if an error was
> returned http://www.php.net/mysql_error. Third, in this line:
>
> 'detail_start_date_y,detail_start_date_m,detail_start_date_d,d
> etail_star
> t_time_h,detail_start_time_m' <= '$ttwo'
>
> You are comparing the literal string of 'detail... ' is less
> than or equal to a string like '200203041234' or something.
> That's going to fail.
>
> You need to go back to your SQL books...
>
> ---John Holmes...
>
> > -----Original Message-----
> > From: Chris Kay [mailto:Chris.Kay@techex.com.au]
> > Sent: Thursday, June 13, 2002 7:33 PM
> > To: PHP General List
> > Subject: [PHP] MySQL Query Help!!!!
> >
> >
> > I have a rather longer query which I would like to get all records
> past
> > todays date.
> > Here is my query
> >
> > $ttwo = date("YmdGi");
> >
> > $dbq = select("select detail.*, type.type_name, status.status_name,
> > staff.staff_name, source.source_long, source.source_short
> from detail,
> > type, status, staff, source where type.type_id =
> detail.detail_type &&
> > status.status_id = detail.detail_status &&
> > staff.staff_id = detail.detail_staff && source.source_short =
> > detail.detail_source &&
> >
> 'detail_start_date_y,detail_start_date_m,detail_start_date_d,d
> etail_star
> t_
> > time_h,detail_start_time_m' <= '$ttwo' order by
> detail.detail_start_date_m
> > DESC, detail.detail_start_date_d DESC");
> >
> > The query works fine before I try to get all records in the
> furure as
> > shown below
> >
> >
> 'detail_start_date_y,detail_start_date_m,detail_start_date_d,d
> etail_star
> t_
> > time_h,detail_start_time_m' <= '$ttwo'
> >
> > The query does not error out it just does not give any
> records, and I
> know
> > there are 4 records
> >
> > Detail_start_date_y = 4 digit year
> > Detail_start_date_m = 2 digit month
> > Deatil_start_date_d = 2 digit day
> > Detail_start_time_h = 24 hour time
> >
> > Can anyone see what I am doing wrong?
> >
> > Thanks in advance.
> >
> >
> --------------------------------------------------------------
> ----------
> --
> > -
> > Chris Kay
> > Technical Support - Techex Communications
> > Website: www.techex.com.au Email: chris.kay@techex.net.au
> > Telephone: 1300 88 111 2 - Fax: (02) 9970 5788
> > Address: Suite 13, 5 Vuko Place, Warriewood, NSW 2102
> Platinum Channel
> > Partner of the Year - Request DSL - Broadband for Business
> >
> --------------------------------------------------------------
> ----------
> --
> > -
> >
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
>
>
>