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

2005-04-18 Thread Juffermans, Jos
quot;; (B?> (B (BThat prints out a list of all the keys and values of $row and tells you what (Bcolumns you're receiving (and their names). (B (BJos (B (B-Original Message- (BFrom: Sugimoto [mailto:[EMAIL PROTECTED] (BSent: 19 April 2005 07:58 (BTo: php-db@lists.php.net (BS

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

2005-04-18 Thread Andrés G . Montañez
> 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. -- Atte, Andrés G. Montañez Técnico en Redes y Telecomunicaciones Montevide

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

2005-04-18 Thread Sugimoto
Hello, (BI need your help about PHP (ver 4.3.1) and MySQL (ver 3.23) database. (BI am struggling to customise a database (using left command etc), and am (Bstuck now. (BPlease have a brief look at my scripts below. (B (BWhat I do like to do is to get first 3 letters from "loc1" column from (