Re: [PHP-DB] Incrementing Primary Key

2010-10-28 Thread Max E.K
From: Ethan Rosenberg eth...@earthlink.net To: rquadl...@googlemail.com, Ethan Rosenberg eth...@earthlink.net Cc: php-db-lists.php.net php-db@lists.php.net Sent: Thursday, October 28, 2010 4:55:34 AM GMT +01:00 Amsterdam / Berlin / Bern / Rome / Stockholm / Vienna Subject: Re: [PHP-DB]

Re: [PHP-DB] Incrementing Primary Key

2010-10-28 Thread Ethan Rosenberg
At 03:40 AM 10/28/2010, Max E.K wrote: From: Ethan Rosenberg eth...@earthlink.net To: rquadl...@googlemail.com, Ethan Rosenberg eth...@earthlink.net Cc: php-db-lists.php.net php-db@lists.php.net Sent: Thursday, October 28, 2010 4:55:34 AM GMT +01:00 Amsterdam / Berlin / Bern / Rome / Stockholm

Re: [PHP-DB] Incrementing Primary Key

2010-10-28 Thread Bastien Koert
On Thu, Oct 28, 2010 at 1:00 PM, Ethan Rosenberg eth...@earthlink.net wrote: At 03:40 AM 10/28/2010, Max E.K wrote: From: Ethan Rosenberg eth...@earthlink.net To: rquadl...@googlemail.com, Ethan Rosenberg eth...@earthlink.net Cc: php-db-lists.php.net php-db@lists.php.net Sent: Thursday,

Re: [PHP-DB] Incrementing Primary Key

2010-10-28 Thread Ethan Rosenberg
At 01:17 PM 10/28/2010, Bastien Koert wrote: On Thu, Oct 28, 2010 at 1:00 PM, Ethan Rosenberg eth...@earthlink.net wrote: At 03:40 AM 10/28/2010, Max E.K wrote: From: Ethan Rosenberg eth...@earthlink.net To: rquadl...@googlemail.com, Ethan Rosenberg eth...@earthlink.net Cc:

RE: [PHP-DB] Incrementing Primary Key

2010-10-28 Thread Jimmy Sole
The () around null seem like that could be the issue, just try to put NULL for the value -Original Message- From: Ethan Rosenberg [mailto:eth...@earthlink.net] Sent: Thursday, October 28, 2010 2:02 PM To: Bastien Koert Cc: Max E.K; php-db-lists.php.net; rquadl...@googlemail.com Subject:

RE: [PHP-DB] Incrementing Primary Key

2010-10-28 Thread Jimmy Sole
Actually, after looking at it further, you have the records set to only have not null values yet you are passing a null value to it. -Original Message- From: Ethan Rosenberg [mailto:eth...@earthlink.net] Sent: Thursday, October 28, 2010 2:02 PM To: Bastien Koert Cc: Max E.K;

Re: [PHP-DB] Incrementing Primary Key

2010-10-28 Thread Bastien Koert
On Thu, Oct 28, 2010 at 2:14 PM, Jimmy Sole jimmys...@gmail.com wrote: Actually, after looking at it further, you have the records set to only have not null values yet you are passing a null value to it. -Original Message- From: Ethan Rosenberg [mailto:eth...@earthlink.net] Sent:

[PHP-DB] Variable Assignment

2010-10-28 Thread Ethan Rosenberg
Dear List - I cannot figure this one out: mysql $st=1000; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '$st=1000' at line 1 Ethan MySQL 5.1 PHP 5 Linux [Debian (sid)] -- PHP

Re: [PHP-DB] Variable Assignment

2010-10-28 Thread Andrés G . Montañez
mysql SET @st=100; mysql SELECT @st; +--+ | @st | +--+ | 100 | +--+ Cheers. On 28 October 2010 19:10, Ethan Rosenberg eth...@earthlink.net wrote: Dear List - I cannot figure this one out: mysql $st=1000; ERROR 1064 (42000): You have an error in your SQL syntax; check the

Re: [PHP-DB] Variable Assignment

2010-10-28 Thread Ethan Rosenberg
At 05:13 PM 10/28/2010, Andrés G. Montañez wrote: mysql SET @st=100; mysql SELECT @st; +--+ | @st | +--+ | 100 | +--+ Cheers. On 28 October 2010 19:10, Ethan Rosenberg eth...@earthlink.net wrote: Dear List - I cannot figure this one out: mysql $st=1000; ERROR 1064

Re: [PHP-DB] Variable Assignment

2010-10-28 Thread Chris
However, I am totally confused. All the texts state that to set a variable, the code is: $st=100; That's how you do it in php. Doing it in the db is different and depends on the db you are using. -- Postgresql php tutorials http://www.designmagick.com/ -- PHP Database Mailing List

[PHP-DB] printf

2010-10-28 Thread Ethan Rosenberg
Dear List - I am afraid that I am missing something in a major way. mysql printf(%b %d %f %s\n, 123, 123, 123, test); ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'printf(%b %d %f

Re: [PHP-DB] printf

2010-10-28 Thread Peter Lind
Mysql doesn't have a printf function Regards Den 2010 10 29 00:47 skrev Ethan Rosenberg eth...@earthlink.net: Dear List - I am afraid that I am missing something in a major way. mysql printf(%b %d %f %s\n, 123, 123, 123, test); ERROR 1064 (42000): You have an error in your SQL syntax;