Rolf, You need to separate your functions. You are adding complexity to your world by storing irrelvant infromation in your database. Critical Data Handling (in a proper world) is ALWAYS handled separately from display. So in your example, You are storing all the html display formatting in your database. Bad idea. Not only does it complicate your SQL like you have found out... but selecting something that your looking for becomes unreadable.
You should do the following. 1) Add a simple index to your table... i.e. an ever increasing number... that will always be unique to the line. Either that, or a short name that describes the line that you're looking for.... 2) Alter your database table to only store the critical information. Such as... ftp://cc278355-a.groni1.gr.home.nl/c64/games/ ---> The URL that alters.. ---> The Filename ---> The URLDesc ---> The desc.... Then In the ASP, you say " Select * from table1 WHERE (Either unique ID = X) or ( ShortName = 'GameName1' ); " Then when you get the recordset out.... you handle it in asp with... <% // Start ASPN insert data inline...%> HTML FORMATTING HERE <%=RS.("URL")%> MORE HTML STUFF HERE LIKE <P> and <FONT> and <ALIGN> <%=URLDESC%> Etc Etc That would be proper programming form... Did that make sense? -----Original Message----- From: Rolf C [mailto:[EMAIL PROTECTED] Sent: Thursday, June 19, 2003 4:57 PM To: [EMAIL PROTECTED] Subject: SQL query question Hello all, 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="' & 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
