Array Index Help

@GreyfishSep 18.2008

So I realize that the code below doesn’t work, how can I do this though?

[code=php]$array[title][0][/code]

to post a comment

@NogDogSep 18.2008 — #What do you want to do?

@GreyfishauthorSep 18.2008 — #Well I'm grabbing rows of information from a database but I only want to print out the "title" row but not every title just the one with the given index.

@NogDogSep 18.2008 — #Well I'm grabbing rows of information from a database but I only want to print out the "title" row but not every title just the one with the given index.[/QUOTE]
Um...OK...so...where does [b]$array[/b] come from? At this point I still really have no idea what your code does. If $array is a 2-dimension array of each query result row, probably all you need is to reverse the indexes: $array[0]['title'], but I'm really not sure at this point.

@GreyfishauthorSep 18.2008 — #Ahh sorry, my array comes from information stored in a database...here is my code.

[code=php]$getSpotlights = mysql_query("SELECT * FROM spotlight WHERE type='spotlight'");
 $getHighlights = mysql_query("SELECT * FROM spotlight WHERE type='highlight'");
 $getTotal = mysql_num_rows($getSpotlights);
 $printed = 0;
 $break = ceil($getTotal/2);
 
 echo "<?xml version="1.0"?>n";
 echo "<rss version="2.0" encoding="UTF-8">n";
 echo "<channel>n";
 echo "n";
 echo "t<title>Example</title>n";
 echo "t<link>http://www.example.com</link>n";
 echo "t<description>Ministry spotlights and information on upcoming events.</description>n";
 echo "t<language>en-us</language>n";
 echo "t<generator>PHP Baby!</generator>n";
 echo "n";
 while($spotlight = mysql_fetch_array($getSpotlights)){
 echo "t<item>n";
 echo "tt<title>$spotlight[title]</title>n";
 echo "tt<link>$spotlight[link]</link>n";
 echo "tt<description>$spotlight[description]</description>n";
 echo "tt<media>$spotlight[media]</media>n";
 echo "t</item>n";
 echo "n";
 $printed++;
 if($printed == $break){
 $highlight = mysql_fetch_array($getHighlights);
 echo "t<item>n";
 echo "tt<title>$highlight[title][0]</title>n";
 echo "tt<link>$highlight[link][0]</link>n";
 echo "tt<description>$highlight[description[0]</description>n";
 echo "tt<media>$highlight[media][0]</media>n";
 echo "t</item>n";
 echo "n";
 }
 }
 echo "</channel>n";
 echo "</rss>n";[/code]

@NogDogSep 18.2008 — #For the current code, I see no need for the [0] index. If, however, the intent is to get the values from a particular result row, then before you make the call to mysql_fetch_array($getHighlights), do a mysql_data_seek($row) where $row is the desired result row number (starting at 0 for the first row).

Array Index Help

5 Comments(s) _↴

Also in #PHP _↴

Success!

Social

Version

Array Index Help

5 Comments(s) ↴

Also in #PHP ↴

Success!

The web is an endless sea of information. Don't miss the boat... Subscribe!

Social

Version

5 Comments(s) _↴

Also in #PHP _↴