PHP/MySQL Database/mysql result

function mysql_result() produces a data set.

   <source lang="html4strict">

Its syntax is: int mysql_result (int result_id, int row [, mixed field]) <? @mysql_connect("localhost", "root","") or die("Could not connect to MySQL server!"); @mysql_select_db("mydatabase") or die("Could not select database!"); $query = "SELECT * FROM mytable"; $result = mysql_query($query); $x = 0;

print ""; print "";

while ($x < mysql_numrows($result)) :

    $id = mysql_result($result, $x, "id");
    $name = mysql_result($result, $x, "title");
    $price = mysql_result($result, $x, "myvalue");

print ""; print ""; print ""; $x++; endwhile;

ID	Title	MyValue
$id	$title	$myvalue

mysql_close(); ?>

 </source>
   
  

mysql_result-2.php

   <source lang="html4strict">

<?php

  ...
  $query = "SELECT productid, name FROM product ORDER BY name";
  $result = mysql_query($query);
  for ($count=0; $count <= mysql_numrows($result); $count++)
  {
     $productid = mysql_result($result, $count, "productid");
     $name = mysql_result($result, $count, "name");
     echo "Product: $name ($productid) 
";
  }
  ...

?>

 </source>
   
  

mysql_result.php

   <source lang="html4strict">

<?php

    ...
    $query = "SELECT productid, name FROM product ORDER BY name";
    $result = mysql_query($query);
    $productid = mysql_result($result, 0, "productid");
    $name = mysql_result($result, 0, "name");
    ...

?>

 </source>