I am a totally newby to MYSQL but here i go.
I want to create an ASP page that shows an image (screendump of game) a game name a game description and an url.
I created a database with the following table:
filename, urldesc, desc
Now i have to create an SQL query that will put this information in a webpage: this is what i got.
SELECT '
<img border="0" src="ftp://cc278355-a.groni1.gr.home.nl/c64/games/' & filename & '.gif " </p>
<td>
<a href="ftp://cc278355-a.groni1.gr.home.nl/c64/games/' & filename & '.zip "> ' & urldesc & '</a>
<td>
<p> '& desc &' </p>
<td>
' FROM table1;
The zip file for the download and the gif file for the image have the same filename exept the extention. It nearly works but it won't show all the text in the description.
Any ideas?
_________________________________________________________________ Chatten met je online vrienden via MSN Messenger. http://messenger.msn.nl/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
