note 64346 deleted from function.mysql-data-seek by bjori
| From: | bjori@php.net | Date: | Wed, 12 Apr 2006 20:00:50 +0000 |
| Subject: | note 64346 deleted from function.mysql-data-seek by bjori | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-107923@lists.php.net to get a copy of this message | ||
Note Submitter: markfisk at nospam dot com
Reason: useless
----
This is the easiest way I have found to call a reuseable query.
..Simplicity ..
<?
$db = "mydatabase";
$hostname = "localhost";
$username = "me";
$password= "secret";
$connection=mysql_connect($hostname,$username,$password);
mysql_select_db($db, $connection);
$somename_query = "SELECT * FROM table_name WHERE...";
$somename_result = mysql_query($somename_query);
$somename_count = mysql_num_rows($somename_result);
?>
<html>
<body>
<?
for($i=0;$i<$somename_count;$i++){
$somename_item = mysql_fetch_array($somename_result);
print("Field One:
".$somename_item["fieldname1-goes-here"]."<br>");
print("Field One:
".$somename_item["fieldname2-goes-here"]."<br>");
mysql_data_seek($somename_result,0);
}
?>