Well, from what limited info I have, it looks like your image tag is not closed properly.
Regards, Mike Hillyer www.vbmysql.com > -----Original Message----- > From: Rolf C [mailto:[EMAIL PROTECTED] > Sent: Thursday, June 19, 2003 2: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="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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
