Re: query + loop problem

Nice one folks! Thanks for your help - it's amazing what happens to one's brain once you start to think about the problem in hand enough (enough that is, to attmept to make it make sense to others!..) - I sussed the problem, using a similar method described to me my several of you. (and a little bit of RFTM on my part r.e: mysql_fetch_assoc() and mysql_fetch_array() ... Many thanks for your help. Russ On Wed, 28 Nov 2001 17:49:54 +0200 Andrey Hristov <ahristov@icygen.com> wrote: > echo "<table>\r\n"; > while($row = mysql_fetch_assoc($result)) { // if assoc is not available - will work but double > > results foreach($row as $key => $value){ > echo > "<tr><td>$key</td><td>$value</td></tr>\r\n"; } > }//----end loop echo "</table>\r\n"; > > HTH > Regards, Andrey Hristov > IcyGEN Corporation http://www.icygen.com > BALANCED SOLUTIONS > > ----- Original Message ----- > From: "Russ Michell" <r.j.michell@apu.ac.uk> > To: <php-db@lists.php.net> > Sent: Wednesday, November 28, 2001 5:36 PM > Subject: [PHP-DB] query + loop problem > > > > Hi there everyone: > > > > I have a generic query containing variables, substituted for values dependant upon > > specific > > circumstances: > > > > file://----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%'"; > > } > > file://----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: > > > > file://----loop using hard-coded variables > > while($row = mysql_fetch_array($result)) { > > $field1 = $row[fieldname1]; > > $field2 = $row[fieldname2]; file://----etc > > }//----end while loop > > > > I'd like to be able to have this dynamically enabled as below: > > > > file://----loop using relevant field names to display correct page content > > while($row = mysql_fetch_array($result)) { > > > > file://----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: php-db-unsubscribe@lists.php.net > > For additional commands, e-mail: php-db-help@lists.php.net > > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > #-------------------------------------------------------# "Believe nothing - consider everything" Russ Michell Anglia Polytechnic University Webteam Room 1C 'The Eastings' East Road, Cambridge e: r.j.michell@apu.ac.uk w: www.apu.ac.uk/webteam www.theruss.com #-------------------------------------------------------#