#mysql - Fri 6 Apr 2007 between 00:00 and 01:57

NY Lost Funds



rook2pawnanyone know how to get freebsd to get mysql? (i.e. through a freebsd service)
chadmaynardmattpat: echo $PATH
mattpatchadmaynard: Yeah, they're not there... which should I put? The bin and lib dirs?
Siggy_closebyI have a forum with a table called posts. It has authorid and a 'created' date. How do a query to list the number of posts each month, and the number of unique authors? I can't figure out how to do the second part. This does my first request, fine: SELECT date_format( Created, "%M %Y" ) AS
MONTH , count( Created ) AS NumberJoined
FROM Post
GROUP BY date_format( Created, "%M %Y" )
mattpatchadmaynard: OK, put them in the path, but the config still failed... any more suggestions?
Anyone have any other suggestions?
wblendhello all
chadmaynardSiggy: you just want the number of unique authors added to that?
!tell chadmaynard about a not in b
the_wenchchadmaynard SELECT a.* FROM a LEFT JOIN b ON a.id = b.id WHERE b.id IS NULL;
ncallerso this morning my box shutdown from a power outage. When I turn it back on and run mysqld_safe & several of my sites which are mysql driven are complaining that they cannot find various .frm files. Is my mysql database lost or is there something I should do to fix it?
thumbsncaller: do you have backups?
caoticchadmaynard, hi, how is your bash.org going on :P
thumbsncaller: guess not
DavidMJwhat is the max number of rows in a table?
caotic__having a compound field (for lack of a better word) example: code:NumNumNum...LetterLetterLetter.... in table1, how can i make an inner join of t1, t2 where t2.code = t1.code(LetterLetterLetter....)
shadowvyceforgot my root password for mysql (or Im not logging in right) any suggestions?
nm...
SmokkieHello, I was wondering what is some scripts that will let me download files to my web server through a control panel, that uses the servers resources?
thumbsSmokkie: you're awfully persistent
SmokkieYes thumbs, I had the web client before
I forgot the name
thumbscpanel
webmin
webdav
SmokkieIt would let me create accounts and access it through a control panel and it would let me set to a directory in my hosting I wanted it to download files to and all I would do is put the link in and click download and it would have the server download the file with a progess bar
and when it was done, I would download it from the FTP at any time I wanted
and those mods you are saying, you have to have root admin access
thumbsSmokkie: you're daydreaming
SmokkieNo, I had this
it was kinda like www.torrentflux.com
but it wasn't for torrents
thumbs: did you see www.torrentflux.com?
thumbsyes
I have no idea what project you're referring to that resembles that
asking in ##php might yield better results.
chadmaynardthumbs: are you crazy? ##php and better?

Page: 2 9 16 23 30 37 44 51 

IrcArchive

NY Lost Funds