Query Updated 2

> \n”; print “

“.”

“; $owner = “Pded0phs”; $table = “phone”; $fields = array(id, name, number); $field_to_search = “name”; /* $owner = “Pdit8unx0”; $table = “phones”; $fields = array(id, names, number); $field_to_search = $fields[1]; */ print “Looking for a name like \”$name\”

\n”; $connect = mysql_connect(“mysql.dur.ac.uk”, “”, “”); $query = “select * from ” . $table ; $query = “select * from ” . $table . ” where ” . $field_to_search . ” like \”%$name%\””; $db = “directory”; $database = $owner . “_” . $db; // $database = “Pdit8unx0_directory”; $query_result = mysql_db_query($database , $query ); $numfields = mysql_num_fields($query_result); print $numfields . ” fields:

“; $numrows = mysql_num_rows($query_result); print $numrows . ” rows found:

“; print “”; for ($r = 0 ; $r < $numrows ; $r++) { print “\n”; for ($f = 0 ; $f < $numfields ; $f++) { print “”; } print “\n”; } print “

“; print mysql_result($query_result, $r, “$fields[$f]”); print “

“; print “Try another name:”; print “

“; print “