hello all, I need to put a bit of html in the display of a column... example: http://www.fanatexe.com/users_last.php I have gotten the sql module to retrieve the information perfectly, but my table only includes the image name. I was using the following php to achieve the effect wanted: //connect to the database $connectionstring = odbc_connect("xxx", "xxx", "xxx"); //SQL query $Query = "SELECT firstname, lastname, username, imagepath FROM users ORDER BY lastname "; //execute query $queryexe = odbc_do($connectionstring, $Query); //query database while(odbc_fetch_row($queryexe)) { $firstname = odbc_result($queryexe, 1); $lastname = odbc_result($queryexe, 2); $username = odbc_result($queryexe, 3); $imagepath = odbc_result($queryexe, 4); //format results print ("

Yes, it's quite possible. In place of your individual fields, just concatenate the required html onto the field data. In your example, you could do something like this: SELECT '' AS ImagePathTitle FROM Users This would return html inside the column that showed the image.

Is it also possible to pass input from a form to select specific results? in example: show all collumns where affiliate code = 12345 (they have to enter their affiliate code before the query is run)?

You can use Query String parameters, [QUERYSTRING:val] where val is the querystring parameter. For example, you could do: SELECT * FROM USERS where AffiliateId = [QUERYSTRING:AffiliateId] and if the url was http://www.myplace.com/default.asp?AffiliateId=1234 it would execute SELECT * FROM USERS where AffiliateId = 1234

One thing I found out is that the sorting doesn't work properly on the column that contains the html. for example I have a grid of names and the name links to a page for that person's name. With the html added in there the sort will order by the whole link's html value not the actual value of the field. How would one go about this? Thanks, Kev

I think the only way around this is to provide two columns, one with the value and one with the link and the users can click on the value column to sort by that value. Or, you could provide both in the same column, but contenate the value onto the front of the link so that is the value used primarily in the sorting. Ex. Richard Edwards View In this case, you provide a user name and then a link that says View instead of the name.

I see... one thing that might be usefull in a later version would be to allow the grid to be sorted by a column that is not in the query... so it would look at the query and what you have entered into the "order by" text box and then it would sort baised on that column name... -Kev