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:

< span class =codeLinkonclick =Blur（this，this.parentNode.parentNode，getChildren（this），true）;>展开 | 选择 | Wrap | 行号

推荐答案

表格结构是什么？我之前从未遇到过这个错误。

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屋！