Member list numbering

homer09001

i have a member list on my site where the id is shown at the moment when a user registers it automatticaly assisns teh enxt available number to the new user but this number shows up as a single digit how do i get it to show as a 3 digit number e.g. 001 so i have to chagne the field typ e in teh DB or can it be done with a simple bit fo code?

kakki

$number='1';
while ( strlen( $number ) <= 3 )
{
    $number = '0'. $number;
}

devinemke

are you using mySQL? if so check out ZEROFILL on the manual page about Numeric Types.

homer09001

col that was quick where do i put htis in teh aply.php3 file behind the applciation form? if it helps heres my code:

<?php
print "<BODY BGCOLOR=\"#CCCCCC\">";
$DBhost = "localhost"; /* DON'T CHANGE should be fine as it is ok*/
$DBuser = "******";
$DBpass = "*****";
$DBName = "******";
$table = "pilotinfo";  /* DON'T CHANGE*/
mysql_connect($DBhost,$DBuser,$DBpass) or die("Unable to connect to database");

@mysql_select_db($DBName) or die("Unable to select
database $DBName");


$name = $_POST['name'];
$email = $_POST['email'];
$age = $_POST['age'];
$history = $_POST['history'];
$webaddyhist = $_POST['webaddyhist'];
$role = $_POST['role'];
$comments = $_POST['comments'];
$registered_on = gmdate("l d M Y");
$registered_at = gmdate("H:i:s");
$regcode = md5(uniqid(rand(),1));

$sqlquery = "INSERT INTO $table values ('$id','$visible','$name','$email','$age','$history','$webaddyhist','$role','$comments',0,'$registered_on','$registered_at','$regcode')";
$results = mysql_query($sqlquery);

$idquery = "SELECT id FROM $table WHERE regcode='$regcode'";  

$results2 = mysql_query($idquery); 
$pid=mysql_result($results2,0,"id");

####################################
#confirmation e-mail settings Below#
####################################
$subject = "easyJet Virtual Registration Confirmation";
$message = "Thank You For Registering At easyJet Virtual

here the information you submitted:

Name:  $name
E-Mail:  $email
Age:  $age
History: $history
Web address or e-mail of previous Site or CEO:  $webaddyhist
Role:  $role
Comments:  $comments
You registered on the:  $registered_on
You registered at:  $registered_at


Before you appear on the roster and before you can file pireps you are required to activate your account to do so please click on this link to activate your account http://www.danhill.frihost.net/easyjetv/activate.php?code=$regcode&id=$pid

May i thank you again for joining us here at easyJet Virtual

Daniel Hill
CEO

If you recieved this e-mail in error please delete it.

PLEASE DO NOT respond to this e-mail as it is an automaticaly generated e-mail.";
$headers = "From: register@easyjet-v.tk";
$mailsend = mail($email,$subject,$message,$headers);
#####################################
#End of confirmation e-mail settings#
#####################################


mysql_close();

print "<HTML><TITLE> PHP and MySQL </TITLE><center><table border=\"0\"
width=\"500\"><tr><td>";
print "<p><font face=\"verdana\" size=\"+0\"> <center>You
Just Entered This Information Into the
Database<p><blockquote>";
print "Name : $name
<p>
E-Mail : $email
<p
age : $age
<p>
History : $history
<p>
Url of previous VA or E-Mail address : $webaddyhist
<p>
Your Role within easyJet-V : $role
<p>
Comments : $comments
</blockquote></td></tr></table>
</center></BODY></HTML>";
?>

homer09001

kakki wrote:

$number='1';
while ( strlen( $number ) <= 3 )
{
    $number = '0'. $number;
}

thanx anyway but i found
this post easier to do and is exactly whtat i need

devinemke wrote:
are you using mySQL? if so check out ZEROFILL on the manual page about Numeric Types.

Thanks Devinemke

although tehre is 1 other thing one of you could help me with here my other post i need help with : http://www.phpbuilder.com/board/showthread.php?t=10308893

i really need this to work