5 Nov
2009
5 Nov
'09
8:57 p.m.
2009/11/5 Erik Lewis <elewis@ngrl.org>
Been playing with this for awhile
SELECT CONCAT('http://images.amazon.com/images/P/'isbn'.01.TZZZZZZZ.jpg')<http://images.amazon.com/images/P/%27isbn%27.01.TZZZZZZZ.jpg%27%29>FROM isbn_experiment LIMIT 10;
I think you may need som commas in the parentheses: SELECT CONCAT('http://images.amazon.com/images/P/', isbn, '.01.TZZZZZZZ.jpg')<http://images.amazon.com/images/P/%27isbn%27.01.TZZZZZZZ.jpg%27%29>FROM isbn_experiment LIMIT 10; http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_concat...) Regards, Magnus Enger libriotech.no