Re: [PHP-DB] Re: SELECT

2011-10-20 Thread tamouse mailing lists
On Mon, Oct 17, 2011 at 12:58 PM, Jim Giner wrote: > I would do it this way: > > Where >  $sel_d = (the day # you want) >  $sel_m = (the month # you want) > > The "where" clause would be: > > Where  (start_month => $sel_m and start_day => $sel_d) and >     (end_month =< $sel_m and end_day =< $sel_

Re: [PHP-DB] SELECT

2011-10-20 Thread tamouse mailing lists
On Tue, Oct 18, 2011 at 5:36 AM, Ford, Mike wrote: >> -Original Message- >> From: Ron Piggott [mailto:ron.pigg...@actsministries.org] >> Sent: 17 October 2011 18:38 >> >> I need help creating a mySQL query that will select the correct >> introduction message for a website I am making.  The

Re: [PHP-DB] SELECT

2011-10-20 Thread tamouse mailing lists
On Thu, Oct 20, 2011 at 3:36 PM, tamouse mailing lists wrote: > On Tue, Oct 18, 2011 at 5:36 AM, Ford, Mike wrote: >>> -Original Message- >>> From: Ron Piggott [mailto:ron.pigg...@actsministries.org] >>> Sent: 17 October 2011 18:38 >>> >>> I need help creating a mySQL query that will sele

[PHP-DB] PHP + SQLite - Issues with update

2011-10-20 Thread Prashant Prabhudesai
Hello, I am running into some issues trying to update a column in a table in a SQLite database using PHP on Windows and was hoping could get some help on this mailer. Here is the create and insert statement - CREATE TABLE SERVER ( IPAddress varchar(100) not null unique primary key, Token va

[PHP-DB] Re: PHP + SQLite - Issues with update

2011-10-20 Thread David Robley
Prashant Prabhudesai wrote: > Hello, > > > I am running into some issues trying to update a column in a table in a > SQLite database using PHP on Windows and was hoping could get some help on > this mailer. > > > Here is the create and insert statement - > > > CREATE TABLE SERVER ( > IPAddre