[PHP-WIN] Re: [phpXperts] Re: [PHP-WIN] Need help with mysql error

2013-06-20 Thread Shiplu
You can use reserved keywords as column names too. Just use ` to enclose the name. Like `add`

[PHP-WIN] Re: [phpXperts] Re: [PHP-WIN] Need help with mysql error

2013-06-20 Thread shiplu
On Jun 7, 2013 9:28 PM, "Gu®u" wrote: > > > > Hi All, > > Yes 'add' is a reserved word & that was my mistake. I was looking it from PHP side all the time. I didn't thought about MYSQL stuff. I have changed it to 'os_add' and now its working. Thanks guys. You guys rock :) > You can use reserved ke

Re: [PHP-WIN] Need help with mysql error

2013-06-07 Thread Gu®u
Hi All, Yes 'add' is a reserved word & that was my mistake. I was looking it from PHP side all the time. I didn't thought about MYSQL stuff. I have changed it to 'os_add' and now its working. Thanks guys. You guys rock :) On Fri, Jun 7, 2013 at 8:47 PM, Arno Kuhl wrote: > -Original Messa

RE: [PHP-WIN] Need help with mysql error

2013-06-07 Thread Arno Kuhl
-Original Message- From: GuRu [mailto:nagendra802...@gmail.com] Sent: 07 June 2013 12:22 PM To: php-windows@lists.php.net; php mysql; phpexpe...@yahoogroups.com Subject: [PHP-WIN] Need help with mysql error Hi All, I am working a a project in which there is a table with some variables. I

Re: [PHP-WIN] Need help with mysql error

2013-06-07 Thread Jacob Kruger
What's the sort of final result version of $sql look like? I am assuming that you're using something like sprintf function to build it up based on original string, and values, etc.? As in, I myself would generally have used something like $sql = sprintf("insert into %s...", $tableName); etc. -