Usage of PHP mysql_fetch_array() Function Example
Filed under Labs
The mysql_fetch_array() in PHP allows you to retrieve data from mysql_query. IT always returns the first row in a MySQL Resource in the form of an associative/ numeric array.
Syntax
<?php
mysql_fetch_array(data,array_type)
?> |
Example
<?php
// Your Connection Code here
$query = "SELECT * FROM Demo_Table";
$result = mysql_query($query) or die(mysql_error());
$row = mysql_fetch_array($result) or die(mysql_error());
echo $row['name']. " - ". $row['age'];
?> |
The output will be: James Shadow – 33
Posts you may like:
Delete records within a specific Range from MySQL table
If you want to delete a range of records from MySQL table then you can …
php pagination code example using MySql database
Here is a working code for pagination using PHP and MySql database. Its is tested …
How to include php headers on html site
PHP is a powerful language for web development, it have many in built functions. Here …
Meta refresh tag HTTP-EQUIV “REFRESH”
The refreshing time of a webpage can be define by using html tag HTTP-EQUIV “REFRESH”. …
Open link in a new window
Here is some ways to make html links for a webpage, it will be useful …
