Difference Between "mysql_fetch_object", "mysql_fetch_array"?

[Volitics]

Can someone explain the difference between the following PHP database functions:

[FONT=arial]mysql_fetch_object[/FONT]

and

[FONT=arial]mysql_fetch_array[/FONT]

I've been using both of them. The PHP Manual does not have many examples showing the difference between the two.

I know that the [FONT=arial]mysql_fetch_array[/FONT] function uses the array operator [FONT=arial]$Row['Variable'][/FONT] to output the piece of data extracted from the database.

Also, I know that the [FONT=arial]mysql_fetch_object[/FONT] uses the [FONT=arial]$Row->Variable[/FONT] code type snippet to output the same piece of data extracted from the database.

Other than that I'm not sure about the difference. What I'm trying to figure out is in what situation would it would be best to use the [FONT=arial]mysql_fetch_object[/FONT] and in what situation would it be best to use the other function, [FONT=arial]mysql_fetch_array[/FONT]

Thank you in advance.

Volitics

[neon]

Simple.
mysql_fetch_array() returns an object and mysql_fetch_array() returns an array.
See also mysql_fetch_row() and mysql_fetch_assoc() . It's more efficient to work with an array than an object, in my oppinion.

[dalecosp]

So, do you code functionally or objectively? That is the question. If you're into OOP, you probably want mysql_fetch_object...

[epimeth]

but the array is much faster, neh?

[Weedpacket]

Originally posted by epimeth
but the array is much faster, neh?

Dunno; haen't done any timing comparisons in real-world situations yet 🙂

[dalecosp]

but the array is much faster, neh?

I dunno either, in terms of code and machine response; it is faster for me coding; I don't think in OOP. Maybe not at all. Besides, Weekpacket is prolly the guy sitting on some big site somewhere; I think all my sites got 8 hits total last year ... </sarcasm> 🙂