Re: date comes out as '0000-00-00'

2002-02-14 Thread John McConnell
This doesn't really answer your question, but whenever I deal with dates I convert them to Unix and store them in the database, and then convert them back when I use them. Sorting dates doesn't seem to work as well in a non-unix format, and with UNIX dates you have much more control over the

re:update failing when statement includes "\"

2002-02-04 Thread John McConnell
Kinney, I did the following and it worked. $text="Adding FAQ\'s"; $query="Update faqs SET subject='$text' WHERE id='110'"; mysql_query($query); Good luck. -- - Before posting, please check: http://www.mysql.com/manual.php

Re: mysql web-based admin tool?

2002-01-29 Thread John McConnell
ttp://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > >To request this thread, e-mail <[EMAIL PROTECTED]> >To unsubscribe, e-mail ><[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscr

Re: Help! Inserts way too slow in big db

2001-12-20 Thread John McConnell
One thing to keep in mind when using LOAD is to be sure when you telnet to "cd" to the directory where the file is that you want to load, and then get into mysql and do the LOAD statement. It's a simple thing to overlook, and if you don't do this it won