Select data using mysql_fetch_array()

ComputerEducationWorld.com Categories:
Free Computer Books Online, PHP, PHP 5 Power Programming, C Programming, C For Beginners, Professional C sharp, INDEX - C# Professional in 15 days, Java, Java 2 (simpler way-Old version), Javascript Tutorial for Beginners, HTML, HTML for Beginners, HTML For Advanced, CSS, CSS For Beginners, CSS Advanced, Basic of Computers, Javascript, Free Web Designing Courses, Introduction to JavaScript, Javascript For Beginners, Download Free E-book, .Net, News and Alerts, Ajax, PHP Script, PHP and XML, PHP Ad Management, PHP Classes, MYSQL, Mysql Classes, Mysql Functions, Tips and tricks, Mozilla firefox tricks, Notepad tricks, Windows tricks, MS word tricks, miscellaneous tricks, HTML Tips and Tricks, PHP Tricks, PHP & MySQL, PHP and MySQL - From Beginning to Professional, INDEX, Basic of MySQL, INDEX - MySQL Basic, Wordpress, Wordpress Plugins, Webmasters, Linux/Unix, jQuery

Select data using mysql_fetch_array()

94 views

how to Select data from database table using mysql_fetch_array() with PHP ?? answer goes here:

<?
$result = mysql_query("select * from users order by id");
if(!$result) echo mysql_error();
else {
while($row = mysql_fetch_array($result,MYSQL_ASSOC)) {
echo "$row[id] - $row[Password] - $row[Name] -
$row[email] - $row[ts]
\n";
}
}
?>

« Selecting query in MySQL	Using DATE_FORMAT in MySQL »
Posted on Monday, March 9th, 2009 at 4:33 pm under Basic of MySQL \| RSS 2.0 Feed

One Response to “Select data using mysql_fetch_array()”

Index - MySQL basic Says:
March 9th, 2009 at 5:42 pm
[...] MySQL database 3. Creating MySQL table 4. Insert Query in MySQL 5. Selecting query in MySQL 6. Using mysql_fetch_array() 7. Using DATE_FORMAT in MySQL 8. Using UPDATE in MySQL « Data about pesidential [...]

Post Comment

You must be logged in to post a comment.