MySQL入门问题 [英] MySQL Entry Problem
问题描述
我在将条目放入表格时遇到问题。
我有一个工作板,我想阻止某些公司再次注册。我不允许使用某些类型的广告,所以当他们第一次注册并删除它们时,他们只需重新注册,这个过程就会继续进行。
我放了注册表单中的一段代码,用于检查该公司是否在列表中,如果是,则返回一条消息,说注册被拒绝。唯一的问题是我必须打开页面并将公司名称硬编码到脚本中。
这些人会做的是稍微改名称他们是允许重新注册,例如:公司名称:Redstar,公司名称:RedStar,公司名称:Red-star,公司名称:Red-Star,以及等等。
这就是我现在所拥有的:
I''m having a problem putting entries into a table.
I have a job board and I want to prevent certain companies from being able to register - again. I don''t allow certain type ads, so when they register the first time and I delete them they just re-register and this process goes on and on and on.
I put a piece of code into the registration form that checks to see if if this company is in a list and if so a message is returned saying "registration denied". Only problem with this is that I have to open the page and hard code the company name into the script.
What these people will do is to change the name slightly and they''re allowed to re-register, for instance: Company name: Redstar, Company name: RedStar, Company name: Red-star, Company name: Red-Star, and on and on and on.
Here''s what I have right now:
推荐答案
表格结构是什么?我之前从未遇到过这个错误。
What''s the table structure? I''ve never had this error before.
MySQL版本:4.1.20
字段类型为空额外的
id int(11)没有auto_increment
b_name varchar(60)否
b_email varchar(55)否
Keyname类型基数字段
PRIMARY PRIMARY 2 id
MySQL version: 4.1.20
Field Type Null Extra
id int(11) No auto_increment
b_name varchar(60) No
b_email varchar(55) No
Keyname Type Cardinality Field
PRIMARY PRIMARY 2 id
@DavidPr
我做了一些研究,看起来你的AI字段的值对于它的数据类型来说太大了。尝试将其更改为BIGINT。
@DavidPr
I did some research and it looks like the value for your A.I field is too large for it''s data type. Try changing it to BIGINT.
这篇关于MySQL入门问题的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!