[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 Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.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 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 Database Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php





-- 
Andrés G. Montañez
Zend Certified Engineer
Montevideo - Uruguay

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

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 (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 Database Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php





--
Andrés G. Montañez
Zend Certified Engineer
Montevideo - Uruguay


Andres -

Thanks.

It works!

However, I am totally confused.  All the texts 
state that to set a variable, the code is:  $st=100;


What are they missing and what am I missing?

Ethan

MySQL 5.1  PHP 5  Linux [Debian (sid)] 




--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

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 (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php