[PHP] One more time (Duft Punk) about hyperlink

Thank you very much, I do appreciate your help. (B (BUr script doens work, but, curiously, it works when I changed a bit... (B select left(loc1,3) as locx, openart_id, tit1, pub1, id1, ref1 from (Bopenart_table (B (BIf possible, can I ask one more thing? (BThis part is the problem (B .j

[PHP] Thanks but problem again! Re: [PHP] PHP script problem (with MySQL)

Thank you, Richard, (B (BI simply change this part (B(select * from openart_table) into (B(select substring(loc1, 1, 3) as THREE_LETTER_CODE, * from openart_table) (Bbut Ive got this error, whats wrong with it? (B (BWarning: mysql_num_rows(): supplied argument is not a valid MySQL result (B

[PHP] PHP script problem (with MySQL)

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 (