Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To Query Tables and Loop through the Returning Rows
How To Query Tables and Loop through the Returning Rows? - MySQL FAQs - Managing Tables and Running Queries with PHP Scripts
✍: FYIcenter.com
The best way to query tables and loop through the returning rows is to run the SELECT statement with the mysql_query() function, catch the returning object as a result set, and loop through the result with the mysql_fetch_assoc() function in a while loop as shown in the following sample PHP script:
<?php include "mysql_connection.php"; $sql = "SELECT id, url, time FROM fyi_links"; $res = mysql_query($sql, $con); while ($row = mysql_fetch_assoc($res)) { print($row['id'].",".$row['url'].",".$row['time']."\n"); } mysql_free_result($res); mysql_close($con); ?>
Using mysql_fetch_assoc() is better than other fetch functions, because it allows you to access field values by field names. If you run this script, you will see all rows from the fyi_links table are printed on the screen:
101, dev.fyicenter.com, 2006-07-01 22:29:02 102, dba.fyicenter.com, 2006-07-01 22:29:02 1101, dev.fyicenter.com, 2006-07-01 22:29:02 1102, dba.fyicenter.com, 2006-07-01 22:29:02
Don't forget to call mysql_free_result($res). It is important to free up result set objects as soon as you are done with them.
2007-05-11, 5453👍, 0💬
Popular Posts:
Example of using Regular Expressions for syntax checking in JavaScript ... var re = new RegExp("^(&a...
Does .NET support UNICODE and how do you know it supports? Yes .NET definitely supports UNICODE. Try...
When should the method invokeLater() be used? This method is used to ensure that Swing components ar...
. How can a servlet refresh automatically if some new data has entered the database? You can use a c...
How To Use Subqueries with the IN Operator? - MySQL FAQs - SQL SELECT Statements with JOIN and Subqu...