Insert to MySQL inside foreach

[cordoprod]

Hey.

I am parsing some html, and putting inside an html db.

I need to create a randomized integer to be a unique identifier, and i chose just to use time().

 

But I foreach the results, and inside here i do the inserting.

But when i call time() in foreach, it'll be the same for every entry parsed.

 

foreach code:

foreach($linjerMatches[1] as $k=>$v) {
echo $fylke." <b>".$linjerMatches[1][$k]."</b> ".time()."<br />";

//$sql = "INSERT INTO ruteinfo_linjer(fylke,identifier,linje) VALUES('".$fylke."', '".time()."', '".$linjerMatches[1][$k]."')";
//$result = mysql_query($sql, $linkID) or die("Error");
}

 

time() will output the same for every row. How can i fix that?

[JAY6390]

Use Microtime. You can also use this nifty function taken from the manual page

function microtime_float()
{
    list($usec, $sec) = explode(" ", microtime());
    return ((float)$usec + (float)$sec);
}

[wildteen88]

If you want each row to have a unique identifier then you should look into using auto_increment. With an auto_increment field MySQL will assign a unique identifier for each row inserted into the table.