Re: [PHP-DB] Re: Database Problems

2012-06-25 Thread tamouse mailing lists
On Mon, Jun 25, 2012 at 9:46 PM, tamouse mailing lists wrote: > On Mon, Jun 25, 2012 at 7:57 AM, Peter Beckman wrote: >>  I'll save you some time, it's not the "where 1" part of the query: >> >>    mysql> select count(*) from numbers where 3 and num like '1212%'; > > The only time the where claus

Re: [PHP-DB] Re: Database Problems

2012-06-25 Thread tamouse mailing lists
On Mon, Jun 25, 2012 at 7:57 AM, Peter Beckman wrote: >  I'll save you some time, it's not the "where 1" part of the query: > >    mysql> select count(*) from numbers where 3 and num like '1212%'; The only time the where clause fails (rightly so) with a single number like what is when you do "whe

Re: [PHP-DB] Re: Database Problems

2012-06-25 Thread Peter Beckman
On Mon, 25 Jun 2012, B. Aerts wrote: On 17/06/12 21:06, Ethan Rosenberg wrote: Dear List - I have a database: +-+ | Tables_in_hospital2 | +-+ | Intake3 | | Visit3 | +-+ Hey Ethan -- Remember that your posts are archived likely f

[PHP-DB] Re: Database Problems

2012-06-25 Thread B. Aerts
On 17/06/12 21:06, Ethan Rosenberg wrote: Dear List - I have a database: +-+ | Tables_in_hospital2 | +-+ | Intake3 | | Visit3 | +-+ mysql> describe Intake3; ++-+--+-+-+---+ | Field | Type | Null

Re: [PHP-DB] Re: Database Problems

2012-06-17 Thread tamouse mailing lists
On Sun, Jun 17, 2012 at 8:22 PM, tamouse mailing lists wrote: > On Sun, Jun 17, 2012 at 5:55 PM, Ethan Rosenberg wrote: >> At 04:21 PM 6/17/2012, Jim Giner wrote: >> >>> "Ethan Rosenberg" wrote in message >>> news:0m5s00mgd2bh7...@mta1.srv.hcvlny.cv.net... >>> > At 03:30 PM 6/17/2012, Jim Giner

Re: [PHP-DB] Re: Database Problems

2012-06-17 Thread tamouse mailing lists
On Sun, Jun 17, 2012 at 5:55 PM, Ethan Rosenberg wrote: > At 04:21 PM 6/17/2012, Jim Giner wrote: > >> "Ethan Rosenberg" wrote in message >> news:0m5s00mgd2bh7...@mta1.srv.hcvlny.cv.net... >> > At 03:30 PM 6/17/2012, Jim Giner wrote: >> >>"Ethan Rosenberg" wrote in message >> >>news:0m5r005qyzrn

Re: [PHP-DB] Re: Database Problems

2012-06-17 Thread Jim Giner
"Matijn Woudt" wrote in message news:cac_gtup8fjuv7jyut89w2491nm-7zno8mrj3w0mep6totm2...@mail.gmail.com... On Sun, Jun 17, 2012 at 10:21 PM, Jim Giner wrote: > > "Ethan Rosenberg" wrote in message > news:0m5s00mgd2bh7...@mta1.srv.hcvlny.cv.net... >> At 03:30 PM 6/17/2012, Jim Giner wrote: >>>"

Re: [PHP-DB] Re: Database Problems

2012-06-17 Thread Matijn Woudt
On Sun, Jun 17, 2012 at 10:21 PM, Jim Giner wrote: > > "Ethan Rosenberg" wrote in message > news:0m5s00mgd2bh7...@mta1.srv.hcvlny.cv.net... >> At 03:30 PM 6/17/2012, Jim Giner wrote: >>>"Ethan Rosenberg" wrote in message >>>news:0m5r005qyzrnm...@mta6.srv.hcvlny.cv.net... >>> > Dear List - >>> >

Re: [PHP-DB] Re: Database Problems

2012-06-17 Thread Ethan Rosenberg
At 04:21 PM 6/17/2012, Jim Giner wrote: "Ethan Rosenberg" wrote in message news:0m5s00mgd2bh7...@mta1.srv.hcvlny.cv.net... > At 03:30 PM 6/17/2012, Jim Giner wrote: >>"Ethan Rosenberg" wrote in message >>news:0m5r005qyzrnm...@mta6.srv.hcvlny.cv.net... >> > Dear List - >> > >> >> > >> > The sam

Re: [PHP-DB] Re: Database Problems

2012-06-17 Thread DZvonko Nikolov
first rule of computer science: if everything else fails, read the manual!!!or short: RTFM!   --- Regards DZvonko Nikolov dzvo...@gmail.com dzvo...@yahoo.com ---

Re: [PHP-DB] Re: Database Problems

2012-06-17 Thread Jim Giner
"Ethan Rosenberg" wrote in message news:0m5s00mgd2bh7...@mta1.srv.hcvlny.cv.net... > At 03:30 PM 6/17/2012, Jim Giner wrote: >>"Ethan Rosenberg" wrote in message >>news:0m5r005qyzrnm...@mta6.srv.hcvlny.cv.net... >> > Dear List - >> > >> >> > >> > The same query in a PHP program will only give m

Re: [PHP-DB] Re: Database Problems

2012-06-17 Thread Ethan Rosenberg
At 03:30 PM 6/17/2012, Jim Giner wrote: "Ethan Rosenberg" wrote in message news:0m5r005qyzrnm...@mta6.srv.hcvlny.cv.net... > Dear List - > > > The same query in a PHP program will only give me results for MedRec 10003 > why the "where 1" clause? Do you know what that is for?

[PHP-DB] Re: Database Problems

2012-06-17 Thread Jim Giner
"Ethan Rosenberg" wrote in message news:0m5r005qyzrnm...@mta6.srv.hcvlny.cv.net... > Dear List - > > > The same query in a PHP program will only give me results for MedRec 10003 > why the "where 1" clause? Do you know what that is for? -- PHP Database Mailing List (http://www.php.net/) To