Hello,
First off let me just say that PHPRunner is one of the greatest pieces of software that I have ever used. I have been using it for almost a year now and it has revolutionized my workplace. Props out to the entire Xlinesoft team!!!
I am working on a rather large project and am close to finishing it off but am looking for the last piece of the puzzle.
I have a duplicate query happening in my code and what I want is to show the "Duplicate found" with a link to go to the edit screen of that duplicate entry.
Example, operator enters an order number - they get a display showing "Duplicate" and a link to the edit screen of that order number. Here is my code and many many thanks in advance!!!
function BeforeAdd(&$values)
{
global $conn;
$values["ordernumber"] = strtoupper($values["ordernumber"]);
$strSQLExists = "select * from allissues where ordernumber='".$values["ordernumber"]."'";
$rsExists = db_query($strSQLExists,$conn);
$data=db_fetch_array($rsExists);
$o=$values["ordernumber"];
$order=$values["id"];
if($data)
{
echo "<h2 style=color=red><a href='allissues_edit.php?$order'><font color=red size=6>Order ".$o." already exists!!<font color=black></a></h2>";
return false;
}
