[SOLVED] Not updating

[topflight]

This is the problem I am having I posted in another forum but it doesn't seem like it was active so here is the problem please help thanks in advanced.

 

This code I have is suppose to check the member list in the hub field and assign the new member a login id depending on what their hub is +1 well it works for all the other hubs but when the user selects the KSEA then it assigns it a KPDX hub id please help. This is my code:

 

<?php
$plist = mysql_query("SELECT * FROM `members` WHERE hub='$_POST[hub]' ORDER BY login DESC LIMIT 1") or die(mysql_error());
$plrows = mysql_num_rows($plist);
if ($plrows=="0"){ 
if ($_POST[hub]=="KSEA"){ $login = "1000"; }
if ($_POST[hub]=="KLAX"){ $login = "2000"; }
if ($_POST[hub]=="KPDX"){ $login = "3000"; }
if ($_POST[hub]=="PANC"){ $login = "4000"; }} else {

while($plr = mysql_fetch_array($plist)){ $login = $plr[login]; } $login = $login + 1; }
?>

 

Also this is the part of the form that contains the hub part.

 

     

      <select name="hub">
              <option>- SELECT A HUB -</option>
              <option value="KPDX">Portland</option>
              <option value="KSEA">Seattle</option>
              <option value="KLAX">Los Angeles</option>
              <option value="PANC">Anchorage</option>
            </select>

 

thanks in advanced!

[MadTechie]

Have to check the database as thats the likely problem!

[topflight]

what should I check for?

[MadTechie]

run the query

SELECT login FROM `members` WHERE hub='KSEA' ORDER BY login DESC LIMIT 1

if its 3000+ then

 

review all that hub to find the point it messed up..

SELECT login FROM `members` WHERE hub='KSEA' ORDER BY login DESC

 

if they are all 3000 then just update them with +1000

[topflight]

ok I ran the query and I deleted the all the logins with 3000 but the script still doesn't work.

[MadTechie]

run the same query again to double check also whats the highest login number that was in the 2000's

[topflight]

actually I ran the  query and I just deleted all the logins numbers with that HUB and just told all the member to re apply and I tested the script and all is good thanks!

 

 

THANK YOU VERY MUCH!

 

p.s looking at my code why was it doing that?

[MadTechie]

Alot of the time the problem is right under your nose.. but sometimes you need to rip up the floorboards to find it

 

However.. what is going to happen after you get 999 memebers on a hub ?

[topflight]

To be honest I dont know all I did was raned the 1 query and the 2nd query u gave me then I deleted those ones. Next I created a test account and it worked so I said YES!!! lol

[topflight]

does anybody else know why that happen