For Programmers: Free Programming Magazines  


Home > Archive > PHP DB > July 2007 > Re: [PHP-DB] Individual Array Entries









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Re: [PHP-DB] Individual Array Entries
Keith Spiller

2007-07-12, 9:58 pm

> I am using a mini calendar script which uses the following array to enter
> event dates.
>
> $days = array(
> 3=>array("/weblog/archive/2004/Jan/03","linked-day"),
> 8=>array("/weblog/archive/2004/Jan/08","linked-day"),
> 22=>array("/weblog/archive/2004/Jan/22","linked-day")
> );
> // 3, 8 & 22 = the day
> // weblog/archive... = the link
> // linked-day = the CSS class.
>
> Because I get the event data from a database and loop through the results
> of a query, I need to be able to insert each entry individually instead of
> as a group.
>
> The following code fails in that it only lists the last entry:
>
> $days = array($theday[$y]=>array("#$thelink[$y]","linked-day"));
>
> Using a concatenation fails altogether:
>
> $days.= array($theday[$y]=>array("#$thelink[$y]","linked-day"));
>
> I just do not know the proper syntax to individually insert entries into
> this multidimensional array... Please help. Thank you.



I tried:
$days[$theday] = array("$thelink","linked-day");

But it only displays the last event.

Keith
James Gadrow

2007-07-13, 6:58 pm

Here's how you can fill a multi-dimensional array:

$days = array(); //Declare $days
to be an array
while ($row = mysql_fetch_assoc($result)) //set variable $row to be an
associative array containing a row of results from your mysql query
array_push($days, $row); //Inserts a new record
into $days and stores $row in it. This creates a multi-dimensional array

Or, if you want it associative:

$days = array();
while ($row = mysql_fetch_assoc($result))
$days['whatever here'] = $row;

Hope that helps!
Enceterjo

2007-07-16, 7:15 am

http://www.thetubebender.com/player.php?watch=148803
Sponsored Links







Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive

Copyright 2008 codecomments.com