RE: DAYOFYEAR()

2002-01-15 Thread Curtis Gordon
PROTECTED]> >Reply-To: <[EMAIL PROTECTED]> >To: "Curtis Gordon" <[EMAIL PROTECTED]> >Subject: RE: DAYOFYEAR() >Date: Mon, 14 Jan 2002 16:36:07 +1300 > >Curtis, > >This is not a mysql issue ('Error - Perl execution failed') > >works fi

Re: DAYOFYEAR()

2002-01-13 Thread Curtis Gordon
incase anybody else was having similar trouble. (C: >From: "Curtis Gordon" <[EMAIL PROTECTED]> >To: [EMAIL PROTECTED] >Subject: DAYOFYEAR() >Date: Mon, 14 Jan 2002 03:24:02 + > >Hi! I'm storing a date in this format : > >2002-01-13 11:08:40 >

DAYOFYEAR()

2002-01-13 Thread Curtis Gordon
Hi! I'm storing a date in this format : 2002-01-13 11:08:40 -mm-dd hh:mm:ss This is great because it gives me the date and the time, which I need. I want to compare this date from the database to the current DAYOFYEAR() but when I do this select DAYOFYEAR('2002-01-13 11:08:40') I get this

database accessable by everybody

2001-12-30 Thread Curtis Gordon
Hi i'm a linux newbie! I need to create a database that is accessable by everybody but i can't find an "easy to use" example of this. I have seen many attempts at it, but none that say, do this and that, here is an example "TAH DAH!". That is what I need. I have setup a database and that was q

creating new users

2001-12-19 Thread Curtis Gordon
Hi everybody, I'm still new to Linux, and mySQL. I have a mySQL db on a win32 box that I want replicated on my new Linux box. I have managed to do a mySQLdump on the win32 box and have successfully relocated the db to the Linux box, I could though, only do it if I was logged into mySQL as root

RE: i own it but i can't use it %$#$@

2001-12-06 Thread Curtis Gordon
blem before I get this fixed. Any ideas what would cause that error in linux? (off topic I know, sorry) >From: "Todd Williamsen" <[EMAIL PROTECTED]> >To: "'Curtis Gordon'" <[EMAIL PROTECTED]> >Subject: RE: i own it but i can't use it %$#$@

RE: i own it but i can't use it %$#$@

2001-12-06 Thread Curtis Gordon
EMAIL PROTECTED]> >To: "'Curtis Gordon'" <[EMAIL PROTECTED]> >Subject: RE: i own it but i can't use it %$#$@ >Date: Thu, 6 Dec 2001 18:45:17 -0600 > >Is mysql on a separate machine? If not, then use this to connect: > >$db = mysql_connect("lo

i own it but i can't use it %$#$@

2001-12-06 Thread Curtis Gordon
Hi again, thank you to all that helped me out with my last "query". I'm on a linux box now (YIPEE) I have created a database, and I have actually managed to load data in that I backed up from a win32 based mysql database (I'm toally pumped at this point), I set some permissions on the dir t

Re: just moved from windows to linux mysql

2001-12-06 Thread Curtis Gordon
Thank you Eric and Mike, I really appreciate the help! >From: "Mike(mickalo)Blezien" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: "Curtis Gordon" <[EMAIL PROTECTED]> >CC: [EMAIL PROTECTED] >Subject: Re: just moved from windows to lin

just moved from windows to linux mysql

2001-12-06 Thread Curtis Gordon
Hi, I have just setup a dedicated linux/php/mysql dev box in my office and I am gearing up to move my databases from a windows box to the linux box. There are a couple of things I would like to be clear on before I start. 1) when I am logged into linux as "user1" and I create a database, does t

RE: PHP4 and MySQL

2001-11-02 Thread Curtis Gordon
No Benj, it's not built in, just support for it is, I'm using apache, PHP4 and mysql on a win32 box and you have to grab and install all the parts yourself. It's not difficult though, I managed to do it! (C: >From: "Benj Arriola" <[EMAIL PROTECTED]> >Reply-To: <[EMAIL PROTECTED]> >To: <[EMAIL

insert statement new trouble

2001-10-30 Thread Curtis Gordon
I have a query where I am inserting a record into a db, and would like to have the primary key value returned, I have been reading and reading, but I can't seem to find any mention of this. I would think that this would be useful. Can anybody help? __

RE: persistant insert trouble

2001-10-30 Thread Curtis Gordon
Thank you for the tip Johnny, I'll copy that code to a snippet and use that from now on. (C: >From: "Johnny Withers" <[EMAIL PROTECTED]> >To: "'Curtis Gordon'" <[EMAIL PROTECTED]> >Subject: RE: persistant insert trouble >Date: Tue,

Re: persistant insert trouble

2001-10-29 Thread Curtis Gordon
Michael Stassen I owe you my sanity!!! THANK YOU THANK YOU THANK YOU!!! (my wife is laughing at me for being such a dork) I really appreciate your help thank you very much. >From: Michael Stassen <[EMAIL PROTECTED]> >To: Curtis Gordon <[EMAIL PROTECTED]> >Subject:

persistant insert trouble

2001-10-29 Thread Curtis Gordon
"INSERT INTO duser (username, upass, fname, lname, hphone, haddress, hcity, hstate, hcountry, hemail, utype) VALUES ('$username','$upass'.'$fname','$lname','$hphone','$haddress','$hcity','$hstate','$hcountry','$hemail','$utype')" this is an insert statement that works fine in the console, but n

Re: insert statement

2001-10-27 Thread Curtis Gordon
omg! code red!! I JUST installed apache and mysql the other day because my host went down and I didn't want to miss out on dev time! Is is possible that the downloads i grabbed were already infected? _ Get your FREE download of MSN

insert statement

2001-10-27 Thread Curtis Gordon
hi Jim, I am finding a TON of errors like this one.. [Sat Oct 27 01:14:57 2001] [error] [client **.***.***.**] File does not exist: c:/phpweb/scripts/..%5c/winnt/system32/cmd.exe I am not on a winnt system though, I'm running winME here at home. It looks to me like somebody is trying to access

Re: insert trouble

2001-10-27 Thread Curtis Gordon
Thanks Jim! That didn't even occur to me! Now I looking all through the mysql folder and I can't find a single log file, where are they kept on a win32 machine? Do you know? >From: jim barchuk <[EMAIL PROTECTED]> >To: Curtis Gordon <[EMAIL PROTECTED]> >Subject

insert trouble

2001-10-27 Thread Curtis Gordon
Hello, I am attempting to insert user information into a mysql db, I am using php4 and the lastest win32 distribution of mysql. I don't get an error when I try the insert, but the data is not saved. I can create tables just fine. Also when I enter the same information in the console it insert