Hi All, I need with an SQL statement.
I have two tables in my database (mySQL): portfolio and categories. In the portfolio table, I have a column called categories, and there is a number value int here depending on where the item is placed in my portfolio. So value 1 is web design, value 2 is flash, etc etc etc. In the categories table, I have a column called categoryvalue and categorydescription. Categoryvalue has a number value and categorydescription has, well, a description of that category. On my detail page, can I setup the SQL statement to show the description of the category and not the numerical value of the category? Does this make sense? Thanks, Justin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
