Home

mysqlresult.phps

<HTML>
<HEAD>
<TITLE>List</TITLE>
</HEAD>
<BODY><br><Br><br>
<basefont face="verdana">
<table width="60%" align="center">
<tr><td> <font size="-1">
 
<?php
  include("database connection file here");
 
$result = mysql_query("SELECT ID, Name, Description FROM Categories where id=1");
$cid=mysql_result($result,0,"id");
$cname=mysql_result($result,0,"name");
$desc=mysql_result($result,0,"description");
echo "<i>$cid $cname: $desc </i><br>\n";   
 
?>
<p>mysql_result() example
<hr width=300>
<?php
 
$result4 = mysql_query("SELECT ID, Description FROM Categories");
$rows = mysql_num_rows($result4);
//echo $rows;
if($rows>0){
mysql_data_seek($result4,3);
$row = mysql_fetch_array($result4);
echo "<u>".$row["ID"] ."</u> ". $row["Description"] ."<br>\n";
}
 
?>
<p>mysql_data_seek() example
<hr width=300>
<?php
 
$cats = mysql_query("SELECT ID, Name FROM Categories");
  while ($cat = mysql_fetch_array($cats)) {
    $cid = $cat["ID"];
    $cname = $cat["Name"];
    echo("<b>$cid - $cname</b><br>\n");
  }
 
?>
<p>mysql_fetch_array() example
<hr width=300>
<?php
 
$result5 = mysql_query("SELECT ID, Name FROM Categories where id=5");
while ($row=mysql_fetch_object($result5)){
  echo $row->ID." : ". $row->Name;
}
 
?>
<p>mysql_fetch_object() example
<hr width=300>
<?
 
$cats = mysql_query("SELECT ID, Name FROM Categories");
while ($cat = mysql_fetch_row ($cats)){
print "$cat[0]/ $cat[1]<br>\n";
}
 
?>
<p>mysql_fetch_row()
<hr width=300>
<?php
 
$query2 = "SELECT * FROM Categories";
$result2 = mysql_query($query2);
while(list($cid,$cname)=mysql_fetch_array($result2)){
echo "<b>$cid</b> $cname<br>\n";
}
 
?>
 
<p>mysql_fetch_array() example using list()
<hr width=300>
<?php
 
$query3 = "SELECT * FROM Categories";
$result3 = mysql_query($query3);
while (list($cid, $cname, $desc)=mysql_fetch_row($result3)){
print("$cid <b>$cname</b> $desc<br>\n");
}
 
?>
<p>mysql_fetch_row() example with list()
 
</td></tr>
</table>
</body>
</html>