[PHP-DB] mysql_fetch_array and extract() with LEFT SELECT

I'm having a problem when I use mysql_fetch_array and extract() following a left select query. As an example... $query = SELECT id,LEFT(fluff,80) FROM sometable; $result = mysql_query($query) or die('message'); while ($row = mysql_fetch_array($result){ extract($row); echo P . $id . : . $fluff .

Re: [PHP-DB] mysql_fetch_array and extract() with LEFT SELECT

Try SELECT id,LEFT(fluff,80) as fluffy FROM sometable Then extract() will have a value for fluffy --- Baumgartner Jeffrey [EMAIL PROTECTED] wrote: I'm having a problem when I use mysql_fetch_array and extract() following a left select query. As an example... $query = SELECT