<br><br><div class="gmail_quote">2009/11/5 Erik Lewis <span dir="ltr"><<a href="mailto:elewis@ngrl.org">elewis@ngrl.org</a>></span><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div style="word-wrap: break-word;">Been playing with this for awhile<div><br></div><div><div style="margin: 0px;">SELECT CONCAT('<a href="http://images.amazon.com/images/P/%27isbn%27.01.TZZZZZZZ.jpg%27%29" target="_blank">http://images.amazon.com/images/P/'isbn'.01.TZZZZZZZ.jpg')</a> FROM isbn_experiment LIMIT 10;</div>
</div></div></blockquote><div><br>I think you may need som commas in the parentheses: <br><br>SELECT CONCAT('<a href="http://images.amazon.com/images/P/%27isbn%27.01.TZZZZZZZ.jpg%27%29" target="_blank">http://images.amazon.com/images/P/', isbn, '.01.TZZZZZZZ.jpg')</a> FROM isbn_experiment LIMIT 10;<br>
<br><a href="http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_concat">http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_concat</a> ;-) <br><br>Regards, <br>Magnus Enger<br><a href="http://libriotech.no">libriotech.no</a><br>
</div></div>