For Programmers: Free Programming Magazines  


Home > Archive > PHP DB > April 2005 > Re: [PHP-DB] PHP&MySQL left/substring etc problem









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Re: [PHP-DB] PHP&MySQL left/substring etc problem
Andrés G. Montañez

2005-04-19, 8:55 am

> 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
Sponsored Links







Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive

Copyright 2008 codecomments.com