trying to convert asp to php, need help or source to find help

tazdog

I have some asp code that I want to try and do the same thing with php, and I quite cannot figure it out.
What I really want to do is have an ID say XYZ1000
But everytime someone signs up I would like it to take the next number in the sequence. (ie XYZ1001)
Is there anywhere on the net or a book that could somehow explain this?
Below is the ASP code currently used. But I'm unable to convert it into php.

Here is the asp code:

PilotID = 1000 

strSQL = "SELECT * FROM Pilots" 
RS.Open strSQL,CONN,1,1 
Do Until RS.EOF 
   If RS.Fields("Name") = "Available" Then 
      PilotID = Mid(RS.Fields("PilotID"),4) 
      WTD = 1 
   Else 
      PilotID = PilotID + 1 
      WTD = 0 
   End If 
   RS.MoveNext 
Loop 
RS.Close 

PilotID = "ZAV" & PilotID

After I get this done then I need to integrate it into more code that I have and make it all work somehow.. 😕

thanks
Scott

beedge_returns

I dont know asp but from the code it looks like you are reading a number from a file and incrementing, what do you do with the incremented number write it to a new record?

tazdog

yes I do..

Here is the scenario..

User fills out a form, name, blah, blah, etc.

But when it writes to the DB I want to add this specific ID to the same row as the other fields.

Here is the code so far:

$sql = "INSERT INTO Pilots (Name, State, Country, Email, Passwd, BirthDate, Vatsim, BVIAccount, HubID) VALUES ('$fullname', '$state', '$country', '$email', '$passwd', '$birthdate', '$vatsim', '$bviaccount', '$hub')";
	$result = mysql_query($sql);
	echo "<b>Thank you!</b>&nbsp;Your Information has been entered.";

This all works from the form and gets an auto assign single numeric ID in the PilotID field..

What I want to do is have lets say ZAV1001 for the first person to sign up and then when the next one signs up, it will get ZAV1002 or the next available..!!

Is this possible..?

I know it works on the asp side.
But I want to learn more Php so using this as a learning tool..

thanks
Scott