Searching database problems

[ehask]

I have a database with UPC codes in it. I thought I could use LIKE in the MySQL statement to find an item but it doesn't return any items.

if($ndc != "") {
  $ndc1 = substr($ndc, 1, -1);
  $nc = "Select * FROM drug_info WHERE ndc like '%".$ndc1."%'";
  } else {
  $ndc1 = substr($ndc2, 1, -1);
  $nc = "Select * FROM drug_info WHERE ndc like '%".$ndc1."%'";
  }
  $sql=mysql_query($nc) or die("ERROR!!!");

The UPC is 359930156012

The substr removes some whacky stuff in barcode so that it is the true NDC number (Sort of) 5993015601

The real NDC for this product is 59930156001 so I am in a bind would there be a better way to get this search??

Thx for any insight

[ehask]

Does anyone have any idea on how to count 9 chars and insert a 0

5993015601 so it will become 59930156001 ??

The original app was run on an access database and it is able to search the original without the 0

I am lost on this one.

[chyan]

first make a query to your database with PHP

then you can count the data length with

$length=strlen($yourqueryresult)

if($length==9){

$yourqueryresult=$yourqueryresult."0"; //adding 0 if character count is 9
}