charles
|
Posted: 07/26/2004, 6:59 AM |
|
Bonjour, hello,
i am sory but my english is not so good.
there is somme thing i cannot understand with codecharge 2.0.7
i use MySql tables
i create a form login as Type login with no thing inside
the propieties Security with the table net_user, when i write the Primary key as user_id, code chage does not remember it after generate and the code of login.php is:
$db->query("SELECT FROM net_user WHERE login="........
it does note write
$db->query("SELECT user_id FROM net_user WHERE login="........
i have to write it by hands
here is the table description
# MySQL-Front Dump 2.1
#
# Host: localhost Database: test
#--------------------------------------------------------
# Server version 3.23.47-nt
#
# Table structure for table 'net_usuers'
#
CREATE TABLE `net_usuers` (
`user_id` tinyint(3) unsigned NOT NULL auto_increment,
`login` char(10) NOT NULL default '',
`passe` char(10) default NULL,
PRIMARY KEY (`user_id`,`login`),
UNIQUE KEY `user_id` (`user_id`),
KEY `user_id_2` (`user_id`),
KEY `login` (`user_id`,`login`)
) TYPE=MyISAM;
thank you,Cordialement, charles baranès
|
|
|
dataobjx
Posts: 181
|
Posted: 07/26/2004, 7:08 AM |
|
Désolé, mais je ne parle pas français, et moi emploie un website de traduction pour écrire ceci. Peut-être si vous employez un emplacement de traduction, il nous aidera en vous aidant. L'emplacement que j'ai employé pour cette traduction est: http://translation.langenberg.com/
_________________
www.DataObjx.net
www.mydigitalapps.com |
|
|
holyboy
|
Posted: 07/26/2004, 7:08 AM |
|
have you choose your login page in site properties / pages?
|
|
|
charles
|
Posted: 07/26/2004, 7:31 AM |
|
have you choose your login page in site properties / pages?
yes i have, it is as if code charge did not recognize the primary kle of the table. thank you for yours answers.
|
|
|
charles
|
Posted: 07/26/2004, 8:25 AM |
|
code charge told me to upload a patch-> it works
thank you
|
|
|
Steven
Posts: 15
|
Posted: 08/06/2004, 6:45 PM |
|
CREATE TABLE `net_usuers`
net_usuers << also your mysql table name is not same in the dump code as the mysql query you show
_________________
|
|
|
|