[PHP-DB] parameters not working under PDO

2007-10-31 Thread Chris Curvey
It's quite possible that I'm missing something obvious here. The following code fragment does not return any rows, but if I take out the parameters and replace them with hardcoded strings (enclosed in single quotes), I get the right results. I've scattered print statements throughout, and

Re: [PHP-DB] parameters not working under PDO

2007-10-31 Thread Thodoris
O/H Chris Curvey ??: It's quite possible that I'm missing something obvious here. The following code fragment does not return any rows, but if I take out the parameters and replace them with hardcoded strings (enclosed in single quotes), I get the right results. I've scattered print

Re: [PHP-DB] parameters not working under PDO

2007-10-31 Thread Michael Preslar
Check $parts.. print_r($parts) and make sure its 1) an array 2) contains 2 values On 10/31/07, Chris Curvey [EMAIL PROTECTED] wrote: It's quite possible that I'm missing something obvious here. The following code fragment does not return any rows, but if I take out the parameters and replace

[PHP-DB] Trouble with Text Area

2007-10-31 Thread Stephen Sunderlin
When I put his line outside of the php tags I get the correct size: textarea name='name' value='$String' rows='10' cols='10'/textareap When I put this line inside the php tags the size comes out about 2 rows by 10 columns regardless of the value of rows and cols. Any ideas on how to format

Re: [PHP-DB] parameters not working under PDO

2007-10-31 Thread Chris Curvey
good thing to check...it seems to be OK. Array ( [0] = montclair [1] = nj ) Michael Preslar wrote: Check $parts.. print_r($parts) and make sure its 1) an array 2) contains 2 values On 10/31/07, Chris Curvey [EMAIL PROTECTED] wrote: It's quite possible that I'm missing something obvious here.

Re: [PHP-DB] Re: backup of database record before update

2007-10-31 Thread Leo G. Divinagracia III
Stephen Sunderlin wrote: Neil, Have you had success with triggers. I couldn't get one to work and then saw discussion on the board here that MYSQL triggers were not so reliable and still somewhat problematic so I archive through the application. Just curious. i have used a couple simple

Re: [PHP-DB] Trouble with Text Area

2007-10-31 Thread Stut
Stephen Sunderlin wrote: When I put his line outside of the php tags I get the correct size: textarea name='name' value='$String' rows='10' cols='10'/textareap That's not how you specify the value of a textarea. It should be between the tags like so... textarea name=name rows=10