Adding the Dashes before searching?

[shakim]

I am using PHP/MYSQL. I have a search page that queries a database field called "id." This field contains a 10 digit number that is seperated by "-". Example, (10-10-131-131). Now when I do a search and enter the id number with the dashes included, the results are fine. But if I just enter the numbers the results are not accurate. What I need help with is to have a function that would look at the number entered and see if it has dashes in it. If it does have the dashed then go and query the database. But if there are no dashed it should add the dashes in the right places and then query the database.

[Mordecai]

[man]strlen/man should be of use here. If it has the dashes, it should be 13 characters long. If it doesn't, it should be 10 (or anything but 13). From this, we can conclude that:

if (strlen($string) == 13) {
  /* it has the dashes */
}
else {
  /* it doesn't. */
}

Now, all you need to do is shove some -s in there. This can be done by using [man]substr/man and concatenating with '-':

$string = substr($string,0,2)
    . '-' . substr($string,2,2)
    . '-' . substr($string,4,3)
    . '-' . substr($string,7,3);

[shakim]

I am a total newbie. How would I add that code to mine.

//Connection statement
require_once('../../Connections/assessing.php');

// begin Recordset
$colnameRSparcel = '-1';
if (isset($HTTP_GET_VARS['Parcel_Number'])) {
$colnameRSparcel = $HTTP_GET_VARS['Parcel_Number'];
}
$query_RSparcel = sprintf("SELECT * FROM parcel WHERE Parcel_Number = '%s'", $colname__RSparcel);
$RSparcel = $assessing->SelectLimit($query_RSparcel) or die($assessing->ErrorMsg());
$totalRows_RSparcel = $RSparcel->RecordCount();
// end Recordset