Answer / mervin thomas

I think all mysql_fetch_array() is the best one, since we
can get the value of the records using the numeric index (as
numbers) or using the string index (as column).
mysql_fetch_array () => fetches the records using the two
way index method,
(ex). $record[0];
$record['id'];
gives the same value.

mysql_fetch_row() fetches the records using the numerical index
ex. $record[0];

mysql_fetch_assoc() fetches the records using the string
index and returs the records as associative array
ex. $record['id'];

mysql_fetch_object() fetches the records as the object.
ex. $record->id;

Answer / pratik

mysql_fetch_object() is the best method. It is not
generally affected in small result. mysql_fetch_array() has
some limit to fetch data from table. when result it too high
(more than 4000 record) at that time
mysql_fetch_object()will support.

Answer / 24/06/08

mysql_fetch_array() is select total values of tables.
mysql_fetch_object() is select a partcular name of the row
in a tables.
mysql_fetch_row() is select row in tables is saem one
object functionor comment.
mysql_fetch)assoc() it means the same function of
mysql_fetch)row and object function.

Answer / pradeep

hi all,

i think mysql_fetch_object or mysql_fetch_array both are best method bcz both are take same time for result show.

but mysql_fetch_array() fetches the records using the numeric index (as numbers) or using the string index (as column)

mysql_fetch_object() fetches the records as the object.
ex. $record->id;

Answer / devendra modi

mysql_fetch_object() is better then mysql_fetch_array()
because mysql_fetch_array () will return numeric and
associative array if you have 1 lac record then it will
generate two array mean load two lack record. so it is
slower then mysql_fetch_object()

Answer / vinoth

My Opinion is at the developer point of view
mysql_fetch_assoc() is the Best method to fetch data but at
the same time at the user point of view we can use
mysql_fetch_object()for faster execution of the data.

Explain the installation of PHP on UNIX systems?

0 Answers  

How will you create a bi-lingual site (multiple languages) ?

3 Answers  

what are the errors and when we get that particular errors.and who will give that errors

3 Answers  

Are php session secure?

0 Answers  

what is constructor in a class, how it is work, how it is call?

2 Answers  

Does session expire on closing browser?

0 Answers  

What is __ invoke in php?

0 Answers  

How to read and display a HTML source from the website url?

0 Answers  

Can we run php in apache tomcat?

0 Answers  

How to open a file for reading?

0 Answers  

<?php /** * @version 1.0 $ * @package HelloWorld * @copyright (C) 2005 Andrew Eddie * @license http://www.gnu.org/copyleft/gpl.html GNU/GPL */ /** ensure this file is being included by a parent file */ defined( '_VALID_MOS' ) or die( 'Direct Access to this location is not allowed.' ); ?> <?php $database =& JFactory::getDBO(); //$sql = 'SELECT name, username FROM #__users'; $sql="select a.id, a.title, a.introtext, a.created_by, a.created from jos_content a, jos_content_frontpage b where a.id=b.content_id and b.ordering='2'"; $database->setQuery( $sql ); $user = NULL; $user = $database->loadObject(); //echo 'Name: ' . $user->name . '<br />'; echo '<h1>' . $user->title . '</h1><br />'; //echo 'Username: ' . $user->username; echo ' ' . $user->introtext; i write this and fetch the result from the database the result is The Intranet is up and working ! Our intranet is up and working and should be accessible from both Mumbai and NOIDA. As you will notice, this template, look & feel is not in line with our corporate indentity but we chose the route of "form-follows-funtion" In the first phase, we are rolling out functionality that is critical to all of us - Policies and How-to documents. In subsequent phases, we will be launching other features. Keep watching this space for more details i want to see only 4 line of top then how this may done

0 Answers   Infovision,

Are objects passed by value or by reference?

0 Answers