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
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
>
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
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
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
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 %$#$@
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
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
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
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
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
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?
__
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,
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:
"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
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
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
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
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
19 matches
Mail list logo