[SOLVED] MYSQL insert

[lvertel]

hello

i am not a newbie in mysql but it seems i am having an STUPID issue i cant solve....

 

this is my query :

 

  $sql33="INSERT INTO tbl_images (id_artist_img, name_image, img_path, thmb_img_path) VALUES ('".$id_artist."', '".$imagepath."', '".$file."', '".$save."');";

$sql33 = mysql_query($sql33,$db_connection) or die ("Immage not uploaded");

 

it gives me the DIE error(image not uploaded). i cant figure it why,because when i print the $sql33 , i receive the data.... :s

 

what is the problem ? thank you in advance

[Mchl]

Please use

tags for your code

 

Change

$sql33 = mysql_query($sql33,$db_connection) or die ("Immage not uploaded");

 

to

 

$result = mysql_query($sql33,$db_connection) or die (mysql_error().": $sql33");

[lvertel]

hello

thank you for your advice, i receive this error now :

 

Duplicate entry '127' for key 1: INSERT INTO tbl_images (id_artist_img, name_image, img_path, thmb_img_path) VALUES ('189', '1236808442.jpg', 'users/images/1236808442.jpg', 'users/images/thumbs/thmb_1236808442.jpg');

 

what should this mean ?

[Mchl]

What type is id_artist_img field in the tbl_images? I'm guessing TINYINT. Change to INTEGER.

[lvertel]

thank you very much, that solved my problem

 

it was tinyint, hehe. i've put it to INT now.

do you suggest me what LENGHT should i put and what is the maximum ???

 

what happens if i reach the maximum number of user under INT ????

 

anyways,these were just additional questions , thanks for solving my problem !

[Mchl]

As you have seen by yourself, when the maximum is reached, the table will stop accepting new entries (maximum for SIGNED TINYINT is 127)

 

To check maximum values for other datatypes consult the manual

http://dev.mysql.com/doc/refman/5.0/en/numeric-types.html

 

[lvertel]

thanks

[fenway]

You should use INT UNSIGNED -- twice the values, same price -- and the "length" field does nothing.