[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