Generate Random number each query?

[Gayner]

I want to make it so

 

each time a user uploads a image, it gives it a unique user_id

 

Is there  php function to generate a unique id starting from number 500?

 

and goes each time that query is ran, 501,502,503, etc.. each time the query is ran

 

thx

[Alex]

You should use an AUTO_INCREMENT field

[Gayner]

You should use an AUTO_INCREMENT field

 

Wont work as there's alrdy one in user_id

 

i made new field cimage, people upload image, i need id for each image too ??

 

Unless i can have 2 auto increment fieldS?

[Philip]

Can you post your table schema?

[Gayner]

Can you post your table schema?

 

include(ROOT_PATH . 'includes/init.php');
global $DB, $settings, $user_info, $forum_info_arr, $language;
if ($user_arr['points'] >= 100)
$lol = "I have more then 100 FC!";
else
$lol = " I haveless then 100FC!";
echo $lol;
if ((($_FILES["file"]["type"] == "image/gif")
|| ($_FILES["file"]["type"] == "image/jpeg")
|| ($_FILES["file"]["type"] == "image/pjpeg"))
&& ($_FILES["file"]["size"] < 10000))
  {
  if ($_FILES["file"]["error"] > 0)
    {
    echo "Return Code: " . $_FILES["file"]["error"] . "<br />";
    }
  else
    {
    echo "Upload: " . $_FILES["file"]["name"] . "<br />";
    echo "Type: " . $_FILES["file"]["type"] . "<br />";
    echo "Size: " . ($_FILES["file"]["size"] / 1024) . " Kb<br />";
    echo "Temp file: " . $_FILES["file"]["tmp_name"] . "<br />";

    if (file_exists("avatars/" . $_FILES["file"]["name"]))
      {
      echo $_FILES["file"]["name"] . " already exists. ";
      }
    else
      {
  $timestamp = date("D, M j Y, h:ia");
	 mysql_query("INSERT INTO `la_items_purchased` (`item_id`,`user_id` ,`points_spent` ,`purchase_date` ,`cimage`) VALUES (
  '". mysql_real_escape_string($_FILES["file"]["name"]) ."',
'". mysql_real_escape_string($user_info[user_id]) ."',
'". mysql_real_escape_string('100') ."',
'". mysql_real_escape_string($timestamp) ."',
  '". mysql_real_escape_string($_FILES["file"]["name"]) ."');
");		


      move_uploaded_file($_FILES["file"]["tmp_name"],
      "avatars/" . $_FILES["file"]["name"]);
      echo "Stored in: " . "avatars/" . $_FILES["file"]["name"];
      }
    }
  }
else
  {
  echo "Invalid file";
  }

 

 

 

[Philip]

user_id doesn't look like its an auto incremented field to me... Use an auto incremented key on item_id, and when inserting, use mysql_insert_id()

[redarrow]

Sorry but it looks like you got a real good understanding of database normalization, why are you generating  the item id like that...

 

Was you suppose to add a auto increment_id at the beginning of that database?

 

Just make no seance with that grate database structure.

 

actually thinking about it, if you make the field item_id UNIQUE, in the database, you could use mysql_insert_id() function, but i would take the below advise,might go wrong my idea mate.

 

sorry to go on but dam dam dam normalization for mysql is a hard subject on it own, don't get why your item_id looks this way please tell me lol.

[Gayner]

Sorry but it looks like you got a real good understanding of database normalization, why are you generating  the item id like that...

 

Was you suppose to add a auto increment_id at the beginning of that database?

 

Just make no seance with that grate database structure.

 

actually thinking about it, if you make the field item_id UNIQUE, in the database, you could use mysql_insert_id() function, but i would take the below advise,might go wrong my idea mate.

 

sorry to go on but dam dam dam normalization for mysql is a hard subject on it own, don't get why your item_id looks this way please tell me lol.

 

item_id joins with user_id which is joined table from forums.

[Philip]

But user_id isn't an auto_incre'd field in this table. Thus, you can have one - your item id.

[redarrow]

so you forgot to add a auto increment to the database structure interesting.

 

KICK UR SELF LOL

 

 

1 min let think, if the id of the forum is item_id now, that means in theory that there be no duplicates, so u can just use insert_id() innit?