Use mysql_result function to get query result -

Ajax
Ajax Examples Ajax Tutorials Scripts and Programs
Javascript
Javascript Examples Tutorials DHTML Tutorials Javascript References Scripts and Programs
HTML
HTML Tutorials HTML References HTML DOM 0 References HTML DOM 2 References
CSS
CSS Tutorials CSS References
PHP
PHP Source Code PHP References Scripts and Programs
C#
C# Source Code C# Examples

PHP Source Code »

Use mysql_result function to get query result



<?php

   mysql_connect("mysql153.secureserver.net","navioo","password");
   mysql_select_db("navioo");


   $query = "SELECT id, firstname FROM Employee";
   $result = mysql_query($query);

   $id = mysql_result($result, 0, "id");
   $name = mysql_result($result, 0, "firstname");
   echo "The first returned id is $id and the name is $name";
?>