I was confused on how to do this:
I have a database.
I know how to display all of the records.
if(mysql_num_rows($result)) {
while($myRow = mysql_fetch_row($result)){
$eventTitle = $myRow[0];
$eventDate = $myRow[1];
blah, blah, blah.....
echo $eventTitle."<br>
";
echo $eventDate."<br>
"
}
}
As you know, each DataBase RECORD has it’s own fields. Let’s say mine has 3.
ex:
Record 1
[Field 1] [Field 2] [Field 3]
Record 2
[Field 1] [Field 2] [Field 3]
etc…
So the data would be:
Record 1
[Meeting 1] [2005/04/01] [Conference Room]
Record 2
[Meeting 2] [2005/04/30] [Staff Room]
etc…
How would I have a string split into an array, with only the “Date” field from EACH Record in it??
(I am looking to do this dynamically, without physically inputting the dates myself…)
ex:
$myDatesArray =
// the array above would have this in it:
("2005/04/01","2005/04/30", etc...)