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  Database Design and Application Architecture  ID to Name

Author  Topic  revo Starting Member 1 Post Posted - 2009-06-11 : 22:07:58 I was pulling the records by ID and now want to pull them by store. well if I can keep pulling them by ID but only show my links as the store names if that would be possible. I changed the href= to the store name instead of the ID, then in my receiving page I changed $_GET['store'] variable instead of $_GET['ID']). but it does not show any stores, I think because I have FROM (`deals` join `sellers` on((`deals`.`ID` = `sellers`.`ID`))) WHERE sellers.ID = columname my columname is equal to the $_GET['info'] variable and this comes from the link the visitor clicks. the text link is href="modes.php?info=<?php echo $row_rsdeals['store']; ?> My novice thought:: In my sql database- how can I make "store" equal "ID" in the same table, so that then "ID" equals "ID" in a different table? setting two columns equal to each other like linking within a table so in the same table like store = id so that sears=322 thanks