PHP String Replace Question

The script below works fine for most codes, but I can only use the last
two letters of hyphenated codes, such as these:

us-ak, ca-ab

In other words, I need to strip us- and ca- out of $mycode. I have
another script that does just that, but I haven't been able to adapt it
to this one. can someone show me how to write it?

Thanks.

PHP Code:

<?php
$result = mysql_query('select count(*) from gatesstatesart');
if (($result) && (mysql_result ($result , 0) > 0)) {
// continue here with the code that starts
//$res = mysql_query ("SELECT * FROM type.....
} else {
die('Invalid query: ' . mysql_error());
}
{
$res = mysql_query ("SELECT * FROM gatesstatesart
WHERE IDArea = '$mycode'") or die (mysql_error());
while ($row = mysql_fetch_array ($res))

if ($row['GNArt'])
echo $row['GNArt'];
else
include ($_SERVER['DOCUMENT_ROOT']."/includes/const.php");
}
?>

David B <david_blomstromDELETETHIS (AT) yahoo (DOT) com> wrote in
news:cdt7us$nk1$1 (AT) forums (DOT) macromedia.com:

if (($result) && (mysql_result ($result , 0) > 0)) {
// continue here with the code that starts
//$res = mysql_query ("SELECT * FROM type.....
} else {
die('Invalid query: ' . mysql_error());
}

Zero matching rows is not an invalid query.

$mycode = preg_replace('/^[a-z]{2}-/', '', $mycode);

http://www.php.net/preg_replace
http://www.php.net/pcre.pattern.syntax

.oO(David B)

The script below works fine for most codes, but I can only use the last
two letters of hyphenated codes, such as these:

us-ak, ca-ab

In other words, I need to strip us- and ca- out of $mycode.

substr($mycode, -2)

returns the last two chars.

I have
another script that does just that, but I haven't been able to adapt it
to this one. can someone show me how to write it?

[...]
$res = mysql_query ("SELECT * FROM gatesstatesart
WHERE IDArea = '$mycode'") or die (mysql_error());

$res = mysql_query('SELECT ... FROM gatesstatesart
WHERE IDArea = "'.substr($mycode, -2).'"') or ...

Micha