As you can see by the below code, I have tried many ways to store DB values to a multi-dimensional array and then print them out. The problem is I am missing something somewhere. As you can see at the bottom of the code I created an array and printed the entire content of the array, but getting it from DB to array and dumping it has me lost some where. Any help appreciated!!!! J <% $dbconn = mysql_pconnect("localhost", "joe", "thepassword"); mysql_select_db("barfield", $dbconn); $now=time(); $query = "select * from articles where ( {$now} BETWEEN startdate AND enddate)";
$db_result = mysql_query($query, $dbconn); $db_error = mysql_error(); $db_rows = mysql_num_rows($db_result); while ($db_record < $db_rows) { # ----- METHOD1--------------------------------------------------------------------- -------------------- # $article_array[1]=mysql_result($db_result,$db_record,"articleid"); # $article_array[2]=mysql_result($db_result,$db_record,"title"); # ----- METHOD2--------------------------------------------------------------------- -------------------- $article_array = array ( array( "id" => mysql_result($db_result,$db_record,"articleid")), array( "title" => mysql_result($db_result,$db_record,"title")) ); print "Rec-" . $db_record . mysql_result($db_result,$db_record,"articleid") . "--" . mysql_result($db_result,$db_record,"title") . "<br>"; print "ARec-" . $article_array[$db_record]['id']. "-" . $article_array[$db_record]['title'] . "<br>"; $db_record++; echo $db_record . " ". $article_array['id'] . " ". $article_array['title'] . "<br>"; } echo "=====Old======================<br>"; for($i=0;$i<=count($article_array);$i++) { echo "Record Number = " . $i ." "; echo "ID: " . $article_array[$i][0] . "---- Title: " .$article_array[$i][1] . "<br>"; # echo "<p><header URL-Frame='content' URL='news/view_article.php?id=$article_array[$i][1]'><bullet-image><b>$artic le_array[$i][2]</b></header>"; # echo "<fullstory URL-Frame = 'content' URL='news/view_article.php?id=$article_arra[$i][1]'>Full story</fullstory></p>"; } echo "=====New======================<br>"; for($i=0;$i<=count($article_array);$i++) { print $article_array[$i]['id'];print ("##");print $article_array[$i]['title'] . "<br>"; } echo "=============The Below Works Perfect==============<br>"; $animals = array ( array ( "name" => "Mike", "type" => "dog", "color" => "Blue", "age" => 7 ), array ( "name" => "Bob", "type" => "cat", "color" => "brown", "age" =>7 ), array ( "name" => "Joe", "type" => "squirrel", "color" => "green", "age" =>2 ), array ( "name" => "Jay", "type" => "cow", "color" => "pink", "age" => 5 ) ); print $animals[0]["type"];print ("<br>");print $animals[0]["color"]; echo "===========================<br>"; for($i=0;$i<=count($animals);$i++) { print $animals[$i]["type"];print ("---");print $animals[$i]["color"] . "<br>"; } %> -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php