slaterino Posted July 8, 2009 Share Posted July 8, 2009 I was wondering if anyone knew how to resolve the following. I am using a database that has stored some information as Submitted. Some entries have these markings around them and some don't. How can I amend a query so that it is always shown correctly as just text. And a couple of other quick things I thought I would ask, seeing as they're kind of related: I have an auto-id that started at 1, and then is increasing slowly from there. Is there anyway that I can make it 8 digits, so that 1 would be 00000001 and so on from there. Is this something that can be done in the MySQL database or would it need to be done in PHP? Lastly, what code would I use to make 0 and 1 into Yes and No when being displayed using PHP? Thanks Russ Quote Link to comment Share on other sites More sharing options...
fenway Posted July 15, 2009 Share Posted July 15, 2009 That's your browser displaying those characters, not the database. You can pad numbers in PHP -- don't make the DB do the work. And you can translate 0 and 1 easily in PHP. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.