RE: mysql.sock

2003-03-30 Thread Mark Armendariz
I was just receiving that error this morning after I changed my hostname and my mysql server wasn't starting properly. Once I got the server started, the error went away. So, I believe that just means that your server's not running or accepting connections. But, that's just a guess. Mark -

RE: MySql, PHP, and Dates

2003-03-30 Thread Mark Armendariz
Hi Bruce, Try looking at php's date function (http://www.php.net/manual/en/function.date.php). That function allows you to format a date variable however you need it to. And to convert mySQL's returned string into a date php can use, try the strtotime function (http://www.php.net/manual/en/funct

RE: DATE function question

2003-03-26 Thread Mark Armendariz
I believe it's "day" without the s. Not sure if it makes a difference, but that's how it's listed in the manual. date_add([thedatefield],Interval 15 day) Mark -Original Message- From: Serge Paquin [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 26, 2003 10:35 AM To: [EMAIL PROTECTED]

Explain and MYSQL DB Optimization resources...

2003-03-23 Thread Mark Armendariz
Hello All, To start, I'm new to the list. My name is Mark Armendariz, currently from Brooklyn NY. Now for my question. I recently had a site go ballistic because of a huge query I had with about 10 joins and some funky weirdness. It was locking my db and using a temporary db, it was