Re: [PHP-DB] PHP&MySQL left/substring etc problem

> But when I tried, "select left (loc1,3) from openart_table where......"

Try without the space between 'left' and '(',
I mean... LEFT(loc1, 3)
where loc1 is the name of the column,
and 3 the characters you want to show.

--=20
Atte, Andr=E9s G. Monta=F1ez
T=E9cnico en Redes y Telecomunicaciones
Montevideo - Uruguay