[PHP] Re: left

2005-04-06 Thread Ken Robinson
Marco J.L wrote: > Hello, > > how can I change the lenght of an value in basuc it's called LEFT or RIGHT > and MID . I read the filenames but I want to strip the extension from the > filename. > > SCRIPT == > > $handle=opendir('news'); > while (false!==($file = readdir($hand

[PHP] Re: Left Join extremely slow (MySQL)

2001-08-03 Thread Richard Lynch
Use MySQL's built in "analyze" ("describe"? SQL statement to see what's taking so long). I'm betting on one server having an INDEX on the id or ex fields, and the other not. -- WARNING [EMAIL PROTECTED] address is an endangered species -- Use [EMAIL PROTECTED] Wanna help me out? Like Music? Bu

Re: [PHP] Re: Left Join extremely slow (MySQL)

2001-08-03 Thread Queen
>"explain" >> >> Use MySQL's built in "analyze" ("describe"? SQL statement to see what's >> taking so long). The statement is called EXPLAIN. You can find it described here: http://www.mysql.com/doc/E/X/EXPLAIN.html >> I'm betting on one server having an INDEX on the id or ex fields, and the >>

Re: [PHP] Re: Left Join extremely slow (MySQL)

2001-08-03 Thread William Poarch
"explain" - - - - - - - - - - Scott Poarch www.globalhost.com - - - - - - - - - - > From: "Richard Lynch" <[EMAIL PROTECTED]> > Organization: Lynch Interplanetary Enterprises > Date: Fri, 3 Aug 2001 17:09:49 -0500 > To: <[EMAIL PROTECTED]> &