limiting results or something

[robsgaming]

I have the following code:

					if($number!=0){
						$i = 0;
						while($i < $number){
						echo "<option value=" . MYSQL_result($result,$i,"sku") . ">" . MYSQL_result($result,$i,"prodname") . "</option>\n";
						$i = $i + 1 ;
						}
					}

I want the result of prodname to be limited to ONLY 7 characters... lets say for instance in the db $bob = AAA-10045339

I only want $bob to be AAA-100

i know that
$bob = substr($bob, "0", "7"); would limit it to 7 chars, but the question i have is how do i get it to work with the code above?

with the code above, how do i limit it? thanks in advance for the help.

[robsgaming]

wait, scratch all of that, i got it working with the following code:

					if($number!=0){
						$i = 0;
						while($i < $number){
						$sku = MYSQL_result($result,$i,"sku");
						$skushort = substr($sku, "0","7");
						echo "<option value=\"$skushort\">" . MYSQL_result($result,$i,"prodname") . "</option>\n";
						$i = $i + 1 ;
						}
					}

but, i dont want to use that, figured out this is what i need to do instead:

lets say $bob = APC-100B or $bob might be BELK-100A

i want to remove AT THE END any character that is not a number, is this possible and how? thanks again.