RE: [PHP-DB] re: mysql ORDER BY problems

2006-06-19 Thread Dwight Altman
I believe I did this one time without changing the database schema; simply by just putting the type in the ORDER BY clause. Something like ORDER BY BINARY numbers ASC or maybe ORDER BY CAST(numbers AS BINARY) ASC Regards, Dwight > -Original Message- > From: J. Alejandro Ceballos Z. -JOAL

Re: [PHP-DB] Conditional updating...

2006-06-19 Thread Jeffrey
Perhaps I have misunderstood something here. But it seems to me that anyone who just happens to put John Smith's name in could alter Mr. Smith's data. If users can update their own data, should you not have a log in process to ensure that only the original user can update his data? Them once h