Main program calls this function:
$the_list = list_field("mailingtable","emailfield","*",$UID);
then at some point echo's $the_list.
list_field() declaration is:
function list_field($table_name,$field_name,$value,$UID) {
$search_result = search_field($table_name,$field_name,$value);
if ($search_result = "") {
return 0;
} else {
$separated_list = "fart: ";
while ($val = each($search_result)) {
$separated_list .= "<td><a href=\"http://".$GLOBALS["urlip"]."/blabla/blalba/blablabla.php?UID=$UID&delete=$field_item\">$val</a></td></tr>\n");
}
return $separated_list;
}
}
the search_field() declaration (this function is used above) is:
function search_field($table_name,$field_name,$value) {
if ($value == "*") {
$sql = "SELECT $field_name FROM $table_name";
} else {
$sql = "SELECT $field_name FROM $table_name WHERE $field_name = '$value'";
}
$result = @($sql);
$no_results = mysql_num_rows($result);
if ($no_results > 0) {
while ($myrow = @mysql_fetch_array($result)) {
$the_array[] = $myrow["$field_name"];
}
sort($the_array);
return $the_array;
} else {
$zero[] = 0;
return $zero;
}
}
search_field() works fine on its own, but returns nothing when called from list_field()
what is wrong??
