Customer Number Generator

[DoQtor N0]

How can I do the following:

 

1. Upon successful login, generate a random 8-digit customer number and assign it to that customer and writes that data to mYsQl.

2.  Screen then refreshes and reads, "Welcome Mr Smith".

 

[drisate]

You can create a random number like this

 

<?php

$rand = rand(10000000, 99999999);
$INSERT = mysql_query("INSERT INTO $table (rand) VALUES ($rand) WHERE id='$_SESSION[id]'") or die(mysql_error());

?>

[coupe-r]

You don't need to generate a random number.  If they already have an "account" they have an ID.  Simply set a $_SESSION['firstname'] = $row['firstname']; and echo the session var on your page.