you should Managing Users with PHP Sessions and MySQL
as per this tutorial:
http://www.webmasterbase.com/article.php?aid=319
then you will always have the $userid or $uid (or whatever you wanna call
it )from LOGIN when you need it as a key to restrict a given mysql user to
access only those rows
Better read the manual:
http://www.innodb.com/ibman.html#InnoDB_start
Enjoy,
Ken
- Original Message -
From: "Sunento Wu" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, July 18, 2001 10:34 PM
Subject: Can't initialize InnoDB as 'innodb_data_file_path'
Good tutorial
http://www.mysql.com/articles/ddws/index.html
enjoy
Ken
- Original Message -
From: "Bob Rea" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, July 16, 2001 5:54 PM
Subject: Next Newbie Question
> Still reading SQL in 10 Minutes, and here is the next problem, stri
Hello,
Is there a command to see which tables are supported by mysql from the
mysql>
prompt?
when I am telneted into my remote server?
Ken
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
h
Here;s the tutorial i have been using
http://www.mysql.com/articles/ddws/2.html
Enjoy
Ken
- Original Message -
From: "Channon Quillen" <[EMAIL PROTECTED]>
To: "mysql" <[EMAIL PROTECTED]>
Sent: Thursday, July 12, 2001 7:38 PM
Subject: Multiple input using a form
> This question might b
r |
> | SVP Technology |
> | DFII Atlanta |
> | Office: 01.770.596.1443|
> ||
> --
>|__|__|
> || ||
>ooO Ooo
>
>
>
> -Origin
What didn;t work,,,what happened?
Ken
- Original Message -
From: "Brad Lipovsky" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, July 10, 2001 11:24 PM
Subject: [PHP-DB] cookie problems
> can anyone help me with this code? i cant believe it wont work, it seems
> pretty simp
Please give some examples of 'bad' design where a "foreign key" would have
to be changed..
ken
- Original Message -
From: "Michael Bacarella" <[EMAIL PROTECTED]>
To: "pak" <[EMAIL PROTECTED]>
Cc: "Ken Sommers" <[EMAIL PROT
Please give some examples where you would need the dbms to do the
referential integrity?
Ken
- Original Message -
From: "pak" <[EMAIL PROTECTED]>
To: "Ken Sommers" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, July 10, 2001 8:31 PM
Subjec
hello,
Do simple input validation.
If the user is entering what is supposed to be a primary key value,
make sure it is a valid key before sticking it in any where, If it's a bogus
key .tell the user to try again.
If user wants you to delete rows from a primary table (customer)that have
"foreign
i like www.Missoulweb.com
check em out..
Ken
- Original Message -
From: "Ohannes Murat Berin" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, July 09, 2001 5:12 PM
Subject: MySQL ISP
> I am searching for an ISP which has MySQL, any suggestions?
>
>
> ---
Hello,
a purely "calculated field" ;(one that is calculated from present values in
the row), doesn' t need to be stored at all, just calculate it when someone
needs to see the calculated value.
In other words.. you don't have to store it if you can calculate it from the
present existing field valu
HI,
Does it make any sense to create an index on the primary key?
Ken
- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "Fournier Jocelyn [Presence-PC]" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Friday, July 06, 2001 3:49 PM
Subject: Re: Perhaps a stupid question about
HI,,here's what mine says:
[mysqld]
innodb_data_home_dir = c:/mysql/data
innodb_data_file_path = ibdata1.db:10M
if you can find the proper section in the manuals you will see that you MUST
specify a file size for that database file: innodb_data_file_path =
ibdata1.db:10M
I set mine to to: 10M
the
Hello,
how do I download the Mysql manual to win 95?
what is a Tarball?
Ken
HI,
Is there any way to get from chapter 7 MySQL Language Reference till the end
of the MySql Manual,on my hard drive back home?
using win 95,,cuz it was free..
Ken
-
Before posting, please check:
http://www.mysql.com/manu
HI,
when you created table:
Create a table
CREATE TABLE members (
member_id int(11) NOT NULL auto_increment,
fname varchar(50) NOT NULL,
lname varchar(50) NOT NULL,
tel varchar(15),
email varchar(50) NOT NULL,
PRIMARY KEY (member_id)
);
is that primary Key also an index authoma
Dynamic HTML (DHTML) promises to change radically the way developers build
Web applications. It empowers the client end of the Web server/browser
relationship. The DHTML feature most oriented to the needs of database
developers is data binding. Data binding can deliver data asynchronously
from a s
mySQL says;
"The easiest and therefor the preferred way to install is to use the mysql-server and
mysql-client ports available on http://www.freebsd.org. "
So my question is ,,do these mysql-server and mysql-client ports from FreeBSD include
the Innodb tables support like mySQL-Max does? I can
19 matches
Mail list logo
