thanks guys.
i am on the right track now.
used mx for some dummy insert update type stuff.
just to look at the syntax..
now just playing with setting vars & doing dynamic sorting through url
variables..
just going to take a while to get the syntax down..
-paul
~~
CREATE TABLE animals (
id MEDIUMINT NOT NULL AUTO_INCREMENT,
name CHAR(30) NOT NULL,
PRIMARY KEY (id)
);
It is the not null autoincrement on the id line.
(You do know about mysql.org and the doc index, yes?
http://www.mysql.com/doc/en/index.htm
rom: "Paul Ihrig" <[EMAIL PROTECTED]>
To: "CF-Community" <[EMAIL PROTECTED]>
Sent: Tuesday, November 05, 2002 1:29 PM
Subject: RE: php & mySql (WAS: got a job..)
> nm
> got it.
>
> now to figure out how to register a datasource with out using the cf
a
a sample db
auto_increment is the way
- Original Message -
From: "Paul Ihrig" <[EMAIL PROTECTED]>
To: "CF-Community" <[EMAIL PROTECTED]>
Sent: Tuesday, November 05, 2002 1:05 PM
Subject: RE: php & mySql (WAS: got a job..)
> ok..
> looking throug
.
--
> -Original Message-
> From: Paul Ihrig [mailto:pihrig@;columbus.rr.com]
> Sent: Tuesday, November 05, 2002 1:30 PM
> To: CF-Community
> Subject: RE: php & mySql (WAS: got a job..)
>
>
> nm
> got it.
>
> now to figure out how to register a data
nm
got it.
now to figure out how to register a datasource with out using the cf admin??
-Original Message-
From: Paul Ihrig [mailto:pihrig@;columbus.rr.com]
Sent: Tuesday, November 05, 2002 1:05 PM
To: CF-Community
Subject: RE: php & mySql (WAS: got a job..)
ok..
looking through
autoincrement.
;o)
- Original Message -
From: "Paul Ihrig" <[EMAIL PROTECTED]>
To: "CF-Community" <[EMAIL PROTECTED]>
Sent: Tuesday, November 05, 2002 6:05 PM
Subject: RE: php & mySql (WAS: got a job..)
> ok..
> looking through all docs on
ok..
looking through all docs on mySql...
using the mysqlCC which is the visual editor for the db..
now what is the equivalent of a auto number for a primary key??
think this would stand out but i can only assign primary key..
but it isn't auto numbering...
: ]
thanks!
-paul
~
Thanks William..
Just did what you suggested
seems fine as well on iis..
just wanted to try it all
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=5
Subscription:
http://www.houseoffusion.com/cf_lists/index
ROTECTED]>
To: "CF-Community" <[EMAIL PROTECTED]>
Sent: Tuesday, November 05, 2002 11:30 AM
Subject: RE: php & mySql (WAS: got a job..)
> ok so i just set up apache, mySql & PHP on my localhost..
>
> what i am not sure of is how to switch from IIS to Apache & so o
ok so i just set up apache, mySql & PHP on my localhost..
what i am not sure of is how to switch from IIS to Apache & so on
so i can do cf & php
do i just hit the stop apache & iis will still run?
or should i configure cf server to use apache??
again, just starting out.
Congrats on the new job Paul!!
The mySQL web site is pretty good in terms of its own documentation...
http://www.mysql.com/
Plus we have this book here : http://makeashorterlink.com/?C47E21952 which
is fairly canny.
>
> Not a book, but have you tried going here?:
> http://hotwired.lycos.com/webm
inal Message-
> From: Paul Ihrig [mailto:pihrig@;columbus.rr.com]
> Sent: Tuesday, November 05, 2002 9:09 AM
> To: CF-Community
> Subject: php & mySql (WAS: got a job..)
>
>
> Guys..
> don't mean to interrupt.
>
> but any one have a good list of url
Guys..
don't mean to interrupt.
but any one have a good list of url's
and books on php & mySql
i only have a few days to hose around..
and with d3 its going to be hard.
-paul
~|
Archives: http://www.houseoffusion.com/cf_lists/in
14 matches
Mail list logo