note 64346 added to function.mysql-data-seek
| From: | markfisk at nospam dot com | Date: | Wed, 12 Apr 2006 18:53:34 +0000 |
| Subject: | note 64346 added to function.mysql-data-seek | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-107912@lists.php.net to get a copy of this message | ||
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);
}
?>
----
Server IP: 64.71.164.2
Probable Submitter: 68.4.211.137
----
X-Spam-Status: Yes, hits=5.0 required=5.0 tests=DATE_MISSING,FROM_NO_LOWER,
HTML_20_30,HTML_MESSAGE,HTML_TAG_BALANCE_BODY,HTML_TAG_BALANCE_HTML
autolearn=no version=2.64
----
Manual Page -- http://www.php.net/manual/en/function.mysql-data-seek.php
Edit -- http://master.php.net/note/edit/64346
Del: integrated -- http://master.php.net/note/delete/64346/integrated
Del: useless -- http://master.php.net/note/delete/64346/useless
Del: bad code -- http://master.php.net/note/delete/64346/bad+code
Del: spam -- http://master.php.net/note/delete/64346/spam
Del: non-english -- http://master.php.net/note/delete/64346/non-english
Del: in docs -- http://master.php.net/note/delete/64346/in+docs
Del: other reasons-- http://master.php.net/note/delete/64346
Reject -- http://master.php.net/note/reject/64346
Search -- http://master.php.net/manage/user-notes.php