PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!
select * from tbl_workshop where frn_cid = $frn_cid order by w_location asc
w_location is stored in the db as "<a href="mypage?wid=1">New York</a>"
The order by w_location in the query orders the list by "wid=1" as it is stored in the field, how can i order by lets say New York and strip the html when doing my query?
you can't easily strip the html during the query. It'd require a stored function/procedure or a bunch of SUBSTRING type calls.. if may be better if you stored the data in a form that was easier to work with.