Re: [PHP-DB] Stuck in apostrophe hell

2010-08-02 Thread Bret Hughes
I would turn on query logging and see what exactly is making it to mysql. Niel Archer wrote: Before I send the following SQL to MySQL from PHP I print it to screen. PHP chokes on it, but I can paste the exact same query from the screen directly to MySQL and it works just fine. For example: He

Re: [PHP-DB] How to emulate phpMyadmin for editing with checkboxes

2005-02-28 Thread Bret Hughes
On Thu, 2005-02-24 at 13:57, Mahmoud Badreddine wrote: > Thank you for your generous response. > I am almost there, but not quite. > > I changed my checkbox statement to looke like the following: > > > try ^ your not doing anything with $row Bret -- PHP Database Mailing List

Re: [PHP-DB] boolean values in postgresql

2005-02-23 Thread Bret Hughes
On Wed, 2005-02-23 at 08:41, Martin Norland wrote: > Bret Hughes wrote: > > I am adding some functionality to a php/postgres based system and have a > > value that I want to be a boolean. digging around the pg doc I see the > > boolean datatype. Cool I say. So I happily al

Re: [PHP-DB] Notice: Undefined index: op

2005-02-22 Thread Bret Hughes
On Tue, 2005-02-22 at 11:31, Martin Norland wrote: > Bret Hughes wrote: > > On Tue, 2005-02-22 at 10:49, Matt M. wrote: > > > >>On Tue, 22 Feb 2005 10:47:43 -0600, Matt M. <[EMAIL PROTECTED]> wrote: > [snip] > >>>try: > >>

Re: [PHP-DB] Notice: Undefined index: op

2005-02-22 Thread Bret Hughes
On Tue, 2005-02-22 at 10:49, Matt M. wrote: > On Tue, 22 Feb 2005 10:47:43 -0600, Matt M. <[EMAIL PROTECTED]> wrote: > > > if ($_POST['op'] != 'ds') { > > > $display_block = " > > > > > > Your E-mail Address: > > > > > >subscribe > > >unsubscribe > > > > > > > >

[PHP-DB] boolean values in postgresql

2005-02-21 Thread Bret Hughes
I am adding some functionality to a php/postgres based system and have a value that I want to be a boolean. digging around the pg doc I see the boolean datatype. Cool I say. So I happily alter the table and add the boolean column notify all is good until I retrieve it using pg_fetch_object and