Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Query data in colums

Author  Topic 

ansipants
Starting Member

1 Post

Posted - 2011-09-25 : 10:34:51
So I've been up all night trying to get these things accomplished and I can't get them to line up right. Sorry I'm a great script kiddie, but terrible at having to code from scratch (severe n00b)

1. I Have a page that will display the data that was posted into a database, but it displays it like this:

id logoname locationname address city state zip phone website etc...

first off, I want to display the data like this:

id <--- this will repeat records 4 colums accross
logoname
locationname
etc...

id <--- this will repeat records 4 colums accross
logoname
locationname
etc...

and then repeat similar for the rest of the data

2. the logoname is an image that is stored in the database and I want to display the actual image, not the name.

3. one of the fields in the table is the website address and I want to make it a click-able link.

any help is greatly appreciated, even getting just the first part accomplished would atleast let me sleep for a few hours

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-09-25 : 12:59:19
these should be done at your front end in html. use a img tag for displaying image and hyperlink for showing it as clickable link.

And for display of data you may use a grid

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -