insert sql breaking after alter table

[frontlinegamerz]

I altered a table now the insert command will not work, anyone have this problem?

[premiso]

Umm post the code.

 

Chances are it is due to a column issue...

[frontlinegamerz]

$sql = 'ALTER TABLE `list` ADD `reason` VARCHAR(30) NOT NULL;';

 

after adding this now it doesn't insert anything at all and there is another field that was working

[matto]

I think premiso meant post the code you are using when you are doing the insert.

 

could also be useful to see the table definition:

 

mysql>desc tablename

 

[frontlinegamerz]

function admin_list() {

global $blackorwhite;

$bwurl = $_POST['bwurl'];

$bwreason = $_POST['bwreason'];

$bwsub = $_POST['bwsub'];

$remove = $_POST['remove'];

if($bwsub) {

if($bwurl) {

@mysql_query("INSERT INTO ".addslashes($blackorwhite)."list VALUES ('".addslashes($bwurl,$bwreason)."')");

[matto]

Can I suggest you change this line

 

@mysql_query("INSERT INTO ".addslashes($blackorwhite)."list VALUES ('".addslashes($bwurl,$bwreason)."')");

 

to this:

 

@mysql_query("INSERT INTO ".addslashes($blackorwhite)."list VALUES ('".addslashes($bwurl,$bwreason)."')") or die(mysql_error());

 

Once you have done this try to do the action that does the insert and see what error message you get.

 

 

[frontlinegamerz]

Column count doesn't match value count at row 1

table is empty

[matto]

You could fix this by altering the insert statement to define the fields that are going to have data populated into.

 

Example:

 

$sql = "insert into tablename (field1, field2) values('$field1','$field2')";
@mysql_query($sql) or die(mysql_error());