sorting data by first letter.

Michael_Havasu

What I am trying to do here is sort the mysql data returned from php.If the data starts with a number IE:1234 i dont want it displayed, however if the data starts with a letter IE: A1234 I want it to be displayed. Is this posible to do?
the variable is $MF_PART_NO

here is what i have so far, looks funny, but it works 🙂

<?PHP

$db = mysql_connect("xxxx", "xxxx", "xxxx") or die("Problem connecting");

mysql_select_db("Nags") or die("Problem selecting database");

$result = mysql_query("SELECT * FROM glasxref WHERE CAR_ID LIKE '$CAR_ID'", $db);
while (list($CAR_ID, $PART_ID, $ATTACHMENT, $GRAPHIC, $CALL_OUT, $NOTE_ID) = mysql_fetch_row($result)) {
$result2 = mysql_query("SELECT * FROM glass WHERE PART_ID LIKE '$PART_ID'", $db);
while (list($PART_ID, $COLOR, $ATTACH, $PREMIUM, $DESCRIP, $BLOCK_1, $BLOCK_2, $GASKET, $MOULDING, $CLIPS, $ADHESIVE, $TSB, $MF_ID, $MF_PART_NO, $PRICE, $P_DATE, $PREV_P, $P_P_DATE, $PRICE_D, $P_PROCE_D) = mysql_fetch_row($result2)) {

echo " <tr>\n" .
         "  <td><b><a href=\"price.php?MF_PART_NO=$MF_PART_NO\">$MF_PART_NO   $DESCRIP </a></b></td>\n" .
         " </tr>\n";
}
}
?>

Thanks for any help.
Michael

chyan

is your $MF_PART_NO variable is always have plus one character
if its contain a letter?
like 1234= 4 character

A1234=5 character

if that so , you can using php to count the string length
example;

$length=strlen($MF_PART_NO);

if($length=="4"){
$MF_PART_NO= " " ; // empty the $MF_PART_NO so not displayed later
}

Michael_Havasu

no, unfortunately thats not the case, That was just an example. Thevariable hold all different size data.. I am looking for a way to not display the variable if it starts with a letter. any letter.
Thanks for the reply though. 🙂

Michael

chyan

you can used this, if you dont want to display variable started with number

$valid_no="^[0-9,]";

if(eregi($valid_no,$MF_PART_NO )){
$MF_PART_NO=" ";
}

so if your variable is not started by letter, that variable will be emptyed

but if you dont want to display variable started with letter
used this

$valid_no="^[a-z,]";

if(eregi($valid_no,$MF_PART_NO )){
$MF_PART_NO=" ";
}

so if your variable is not started by number, that variable will be emptyed

Michael_Havasu

Perfect ! Thanks for the quick help 🙂
Much appreciated!

Michael