Get data from mysql : mysql_query « MySQL Database « PHP






  1. PHP
  2. MySQL Database
  3. mysql_query

Get data from mysql

 
<html>

 <head>
  <title>Get data</title>
 </head>

 <body>

 <?php

 $conn = @mysql_connect( "localhost", "userName", "password" ) or die( "Err:Conn" );

 $rs = @mysql_select_db( "my_database", $conn ) or die( "Err:Db" );

 $sql = "select id,first_name from my_table where id=3";

 $rs = mysql_query( $sql, $conn );

 while( $row = mysql_fetch_array( $rs ) )
 {
   echo( "ID: " . $row["id"] );
   echo( " - FIRST NAME: "  .$row["first_name"] . "<br>" );
 }

 ?>

 </body>

</html>








Related examples in the same category

1.Add record to my_database/my_table
2.Adding a Row to a Table
3.Deleting Data
4.mysql_query.php
5.function mysql_query() queries the database.
6.Storing Information in a Database
7.Using PHP variables wherever you want inside SQL queries
8.Sign the guestbook