Hi there everyone:
I have a generic query containing variables, substituted for values dependant upon
specific
circumstances:
//----query the DB on the basis of searches employing text input fields (LIKE)
if($sql_clause == 'LIKE') {
$sql = "SELECT * FROM $table WHERE $field $sql_clause '%$query%'";
}
//----query the DB on the basis of searches employing select menus ('=')
else if($sql_clause == '=') {
$sql = "SELECT * FROM $table WHERE $field $sql_clause '$query'";
}
$result = mysql_query($sql,$connect) or printerror("Query Failure!","06");
$numrows = mysql_num_rows($result);
Instead of the usual 'hard-coded' method within the loop as below:
//----loop using hard-coded variables
while($row = mysql_fetch_array($result)) {
$field1 = $row[fieldname1];
$field2 = $row[fieldname2]; //----etc
}//----end while loop
I'd like to be able to have this dynamically enabled as below:
//----loop using relevant field names to display correct page content
while($row = mysql_fetch_array($result)) {
//----generic method of extracting rownames according to '$table' (above) goes here
}//----end loop
Does anyone have a clue how to do this???
Many Thanks!
Russ
#-------------------------------------------------------#
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
