Re: [PHP-DB] mysql query

2013-08-22 Thread Michael Oki
Try the insertion like this: $sql2 = mysql_query(insert into Inventory (`UPC` , `quant`, `manuf`, `item`, `orderpt`, `ordrpt_flag`, `stock`) .values ('$upc', $qnt,'$mnf','$itm', '$odrpt', '0', '$stk') ) or die(mysql_error()); On 22 August 2013 05:10, Daniel Krook

Re: [PHP-DB] mysql query

2013-08-22 Thread Vinay Kannan
$sql2 = insert into Inventory (UPC, quant, manuf, item, orderpt, ordrpt_flag, stock) values ('$upc', '$qnt','$mnf','$itm', '$odrpt', 0, $stk); Looks like, you have the ' ' missing for $qnt and odrpt had the $ and the '' missing. The above query should work, I haven't tested it though. Also for

[PHP-DB] Re: mysql query

2013-08-22 Thread Jim Giner
On 8/21/2013 7:48 PM, Ethan Rosenberg wrote: Dear List - I can't figure this out mysql describe Inventory; +-+-+--+-+-+---+ | Field | Type| Null | Key | Default | Extra | +-+-+--+-+-+---+

[PHP-DB] Re: mysql query

2013-08-22 Thread Jim Giner
On 8/21/2013 7:48 PM, Ethan Rosenberg wrote: Dear List - I can't figure this out mysql describe Inventory; +-+-+--+-+-+---+ | Field | Type| Null | Key | Default | Extra | +-+-+--+-+-+---+

[PHP-DB] Re: mysql query

2013-08-22 Thread Jim Giner
On 8/22/2013 9:52 AM, Jim Giner wrote: On 8/21/2013 7:48 PM, Ethan Rosenberg wrote: Dear List - I can't figure this out mysql describe Inventory; +-+-+--+-+-+---+ | Field | Type| Null | Key | Default | Extra |

Re: [PHP-DB] Re: mysql query

2013-08-22 Thread Vinay Kannan
Jim, I know this is a stupid question to be asking this far into PHP Development, maybe was a bit lazy, or just got too used to Notepad++, which editor for PHP are you using? The feature which you mentioned for a good php editor, sounds exciting, offcourse i would be looking only at the free ones

Re: [PHP-DB] Re: mysql query

2013-08-22 Thread Toby Hart Dyke
Notepad++ will do syntax highlighting. Go to Language P PHP with a PHP file open, and see the colours change! It should be automatic - are you using something other than 'php' as a file extension? Toby On 8/22/2013 5:27 PM, Vinay Kannan wrote: Jim, I know this is a stupid question to

Re: [PHP-DB] Re: mysql query

2013-08-22 Thread Vinay Kannan
Thanks Toby, Using Notepad ++ with the language selected to PHP, the syntax coloring is on On Thu, Aug 22, 2013 at 11:00 PM, Toby Hart Dyke t...@hartdyke.com wrote: Notepad++ will do syntax highlighting. Go to Language P PHP with a PHP file open, and see the colours change! It should

Re: [PHP-DB] Re: mysql query

2013-08-22 Thread Lester Caine
Vinay Kannan wrote: Jim, I know this is a stupid question to be asking this far into PHP Development, maybe was a bit lazy, or just got too used to Notepad++, which editor for PHP are you using? The feature which you mentioned for a good php editor, sounds exciting, offcourse i would be looking

Re: [PHP-DB] Re: mysql query

2013-08-22 Thread Ethan Rosenberg, PhD
On 08/22/2013 09:51 AM, Jim Giner wrote: On 8/21/2013 7:48 PM, Ethan Rosenberg wrote: Dear List - I can't figure this out mysql describe Inventory; +-+-+--+-+-+---+ | Field | Type| Null | Key | Default | Extra |

Re: [PHP-DB] Re: mysql query

2013-08-22 Thread Ethan Rosenberg
On 08/22/2013 11:54 AM, Jim Giner wrote: On 8/22/2013 9:52 AM, Jim Giner wrote: On 8/21/2013 7:48 PM, Ethan Rosenberg wrote: Dear List - I can't figure this out mysql describe Inventory; +-+-+--+-+-+---+ | Field | Type| Null | Key

Re: [PHP-DB] Re: mysql query

2013-08-22 Thread Ethan Rosenberg
Ethan Rosenberg, PhD /Pres/CEO/ *Hygeia Biomedical Research, Inc* 2 Cameo Ridge Road Monsey, NY 10952 T: 845 352-3908 F: 845 352-7566 erosenb...@hygeiabiomedical.com On 08/22/2013 06:56 PM, Jim Giner wrote: On 8/22/2013 4:14 PM, Ethan Rosenberg wrote: On 08/22/2013 11:54 AM, Jim Giner wrote:

[PHP-DB] Bluefish for PHP

2013-08-22 Thread Ethan Rosenberg
Dear List - How do I configure Bluefish for PHP? I am running version 2.2.4 of Bluefish. TIA Ethan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php