RE: [PHP-DB] problem getting form input field to become part ofquery statement

2002-08-04 Thread Chip Wiegand
On Sat, 2002-08-03 at 06:05, Rich Hutchins wrote: Try referencing the $listbox variable in you SQL statement like this: $sql = insert into .$listbox. values(NULL,'$date','$exercise','$reps','$comments'); I'm guessing that it might also work like this: $sql = insert into '$listbox'

Re: [PHP-DB] SELECTing a date range from a table

2002-08-04 Thread Jason Wong
On Sunday 04 August 2002 11:33, Chase Knott wrote: I am a newbie. There, I said it! *gryn* Maybe someone here can help me out... I am trying to figure out how to select a range of dates from my table to be used in a dynamic page. I know it is something simple, but I just can't seem to

[PHP-DB] Re: Mail problem

2002-08-04 Thread Georgie Casey
maybe use a for loop and mail command. should work Unknown Sender [EMAIL PROTECTED] wrote in message 002701c23924$da9b1e40$539f4dd5@administrator">news:002701c23924$da9b1e40$539f4dd5@administrator... Sorry to be a little bit off topic. I need a tool or script in PHP, that will automaticaly send

[PHP-DB] Fw: Date Add

2002-08-04 Thread John Fishworld
I thought I had this working, but it seems unfortunately not !!! I'm trying to list events for each month and my select query is as follows SELECT DISTINCT t_city_name,t_city_id_city FROM t_city,t_zipcodecity,t_location,t_event WHERE (t_city_id_city = t_zipcodecity_id_city) AND

Re: [PHP-DB] Fw: Date Add

2002-08-04 Thread Pierre-Alain Joye
On Sun, 4 Aug 2002 17:30:31 +0200 John Fishworld [EMAIL PROTECTED] wrote: Why not simply does the where clause like : for a whole month, here is july: WHERE YEAR(t_event_date)='2002' AND MONTH(t_event_date)='7' For a specific day, here the current day WHERE t_event_date=NOW() That means you

Re: [PHP-DB] Fw: Date Add

2002-08-04 Thread Pierre-Alain Joye
On Sun, 4 Aug 2002 17:42:17 +0200 Pierre-Alain Joye [EMAIL PROTECTED] wrote: On Sun, 4 Aug 2002 17:30:31 +0200 John Fishworld [EMAIL PROTECTED] wrote: For a specific day, here the current day WHERE DAYOFMONTH(t_event_date)=DAYOFMONTH(NOW()) AND MONTH(t_event_date)=MONTH(NOW()) if you store

Re: [PHP-DB] SELECTing a date range from a table

2002-08-04 Thread Chase Knott
Oh sure... Use logic!!! I am using a MySQL database that has 4 columns, right now, they are all set to VARCHAR since I was getting errors trying to make them date fields. The column names are vendor, edate, cdate, and fname. I want to pull all entries in the database where cdate is