FUDforum: comp.lang.php » mysql_fetch

Home » Imported messages » comp.lang.php » mysql_fetch_array

Show: Today's Messages :: Polls :: Message Navigator

Re: mysql_fetch_array [message #169771 is a reply to message #169768]

Sat, 25 September 2010 21:50

TechieOldFox
Messages: 1
Registered: September 2010

Karma:

Junior Member

On Sep 26, 4:28 am, MikeB <mpbr...@gmail.com> wrote:
> I have the following code:
>
> $query = "SELECT * FROM classics";
> $result = mysql_query($query);
>
> if (!$result) die ("Database access failed: " . mysql_error());
> $rows = mysql_num_rows($result);
>
> for ($j = 0 ; $j < $rows ; ++$j)
> {
> $results[] = mysql_fetch_array($result);
>
> }
>
> mysql_close($db_server);
>
> My question, in the loop, why does tha author use:
>
> $results[] = mysql_fetch_array($result);
>
> instead of (as I would expect):
>
> $results[$j] = mysql_fetch_array($result);?
>
> What PHP magic is at work here?
>
> Thanks.

$results[] is equivalent to "add record". SO if you assign a value to
it, it will add a new record in $results for you.

Report message to a moderator

[Message index]

		mysql_fetch_array By: MikeB on Sat, 25 September 2010 20:28
		Re: mysql_fetch_array By: Marious Barrier on Sat, 25 September 2010 21:08
		Re: mysql_fetch_array By: TechieOldFox on Sat, 25 September 2010 21:50
		Re: mysql_fetch_array By: Captain Paralytic on Sat, 25 September 2010 22:50
		Re: mysql_fetch_array By: MikeB on Sat, 25 September 2010 23:36
		Re: mysql_fetch_array By: Captain Paralytic on Sun, 26 September 2010 11:44
		Re: mysql_fetch_array By: sheldonlg on Sun, 26 September 2010 23:24
		Re: mysql_fetch_array By: The Natural Philosoph on Mon, 27 September 2010 07:15
		Re: mysql_fetch_array By: sheldonlg on Mon, 27 September 2010 12:23
		Re: mysql_fetch_array By: Hamish Campbell on Mon, 27 September 2010 07:44
		Re: mysql_fetch_array By: matt[1] on Mon, 27 September 2010 12:37
		Re: mysql_fetch_array By: MikeB on Mon, 27 September 2010 13:18
		Re: mysql_fetch_array By: Captain Paralytic on Mon, 27 September 2010 13:35
		Re: mysql_fetch_array By: MikeB on Mon, 27 September 2010 14:12

Previous Topic:	Group sort syntax?
Next Topic:	Code to create a cookie in PHP

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Oct 20 08:08:54 GMT 2024

Total time taken to generate the page: 0.04112 seconds