PHP.lt konferencija [ php-konf@php.lt ] :: Re: [php-konf] HELP su MySQL


Re: [php-konf] HELP su MySQL From: \ (nwdg@takas.lt)
Date: 2002-03-05 14:44:25


Sveki turiu tokia problema

SELECT id, kodas, pavadinimas, aprasymas,
(blablabb*1.2)+(blablaaa*1.3)+(blablads*1.2)+(blablad*1.1), gamintojas,
naujiena, akcija, kaina FROM dekorasdata WHERE grupe='1' ORDER BY id DESC
LIMIT 0, 30

viska veikia gerai o

SELECT id, kodas, pavadinimas, aprasymas,
(blablabb*1.2)+(blablaaa*1.3)+(blablads*1.2)+(blablad*1.1), gamintojas,
naujiena, akcija, kaina FROM dekorasdata WHERE grupe='1' ORDER BY
(blablabb*1.2)+(blablaaa*1.3)+(blablads*1.2)+(blablad*1.1), DESC LIMIT 0, 30

meta klaida:

You have an error in your SQL syntax near
'(blablabb*1.2)+(blablaaa*1.3)+(blablads*1.2)+(blablad' at line 1

veiksmas vyksta ant PostgreSQL(LINUX)

Ant mySQl 3.23 (win2000) viskas gerai

Jei galit padekit kasnors !!!!

Aciu.




© MMI www.php.lt | E-mail: webmaster@php.lt