Merge Functions Advice
Posted: Tue Jul 05, 2005 9:43 am
The following two functions almost do the same job, can anyone see a way to merge them?
I was thinking perhaps an If statement like
[psuedocode]if (!stockId > 0) do (listFaceStock function) else (fnListFaceStock function)
Any ideas? tia, will
I was thinking perhaps an If statement like
[psuedocode]if (!stockId > 0) do (listFaceStock function) else (fnListFaceStock function)
Any ideas? tia, will
Code: Select all
function listFaceStock() {
$sql_query = mysql_query("SELECT stockDescription, stockId FROM austock");
$output = "<select name=\"stockId\">\n";
$output .= "<option value=\"\">-- Select Option --</option>\n";
while(list($stockname, $stockId)=mysql_fetch_array($sql_query)) {
$stockname = stripslashes($stockname);
$output .= "<option value=\"$stockId\">$stockname</option>\n";
}
$output .= "</select>";
mysql_free_result($sql_query);
return $output;
}
function fnListFaceStock($stockId) {
$sql = mysql_query("SELECT stockDescription, stockId FROM austock WHERE stockId = $stockId");
$query_data = mysql_fetch_array($sql);
$result = $query_data["stockDescription"];
$sql_query = mysql_query("SELECT stockDescription, stockId FROM austock");
$output = "<select name=\"stockId\">\n";
$output .= "<option value=\"\">$result</option>\n";
while(list($stockDescription, $stockId)=mysql_fetch_array($sql_query)) {
$stockDescription = stripslashes($stockDescription);
$output .= "<option value=\"$stockId\">$stockDescription</option>\n";
}
$output .= "</select>";
mysql_free_result($sql_query);
return $output;
}