Add a new row in table?

[Breana]

Ok, i bought this script SE and for the last 2 weeks they have not given me support or help so i am seeking help outside

 

I am trying to make my own plugin, and it's 99% done.

I can call the info, save the info by user id. everything but i am stuck at adding the row to the DB!

 

If i ad it maually it works fine but i cant add someone each time they sign up i have a life here lol.

 

I made the id of the row auto_increment. > gametag_id

And added the insert code to the php page. but it just wont add a new row no error nothing.

 

Here is my code from the new plugin for SE

if($task == "create_new_id") {
  
  $database->database_query("INSERT INTO `se_gametags` (`gametag_id`, `gametag_user_id`, `gametag_note`, `gametag_active`) VALUES
( '', '".$user->user_info[user_id]."', 'No Personal Note Set!', 1)");
}

How do i get it to add a new row in the table??

[wizardry]

do you have a connection to the database?

 

echo your statement to see what is going on

 

if (!$con)

{

die ('could not connect: ' . mysql_error());

echo mysql_errno($con) . " : " . mysql_error($con). "\n";

}

 

// in your case change $sql to your sql string name, and $con to your connect name

if (!mysql_query($sql,$con))

  {

  die('Error: ' . mysql_error());

  }

 

 

hope this helps

[Breana]

Yes i have a connect to DB, $database->database_query

 

I have one default in the table all ready id 1, i can update it delete it read it.

It's just not letting me add a new row...

 

I am at my wits end here...

[peranha]

Try this and see what it does.

 

if($task == "create_new_id") {

  $database->database_query("INSERT INTO se_gametags (gametag_user_id, gametag_note, gametag_active) VALUES
('{$user->user_info['user_id']}', 'No Personal Note Set!', '1')");
}

 

Assuming $user->user_info['user_id'] is set.

 

Do yo have any errors?

[Breana]

Lol at first no it did not work... As i was getting ready to break my keyboard i realized i forgot to add.

 

$new_id = $_POST['my_id']; lol.

It works now my bad...