[SOLVED] MYSQL PHP Foreach

[papillonstudios]

i have research for about almost an hour now and haven't quite found out how to do it

 

I want to use a php for each statement to display the news from a database.

 

i would like to know how to do this.  Thanks in advance

[Ken2k7]

What's wrong with a while loop?

[papillonstudios]

a for each only goes to the a certain number a while goes until error

 

and i have only used For each loops, while testing Codeigniter

[Ken2k7]

What do you mean a foreach goes to a certain number? You make no sense.

[papillonstudios]

theres nothing wrong with an while statement but i want to use a foreach

[elis]

I believe s/he means that a while loop will continue until it fails a condition while a foreach will continue until it cycles completely through an array.

 

 

Sample usage

<?php


//declare an array - or use an array pulled from a query
$var1 = array();
$var1[0] = "a";
$var1[1] = "b";
$var1[2] = "c";
$var1[3] = "d";
$var1[4] = "e";


foreach( $var1 as $content){
echo $content . "<br>";
}
?>

 

Or through using a while:

<?php

//declare an array - or use an array pulled from a query
$var1 = array();
$var1[0] = "a";
$var1[1] = "b";
$var1[2] = "c";
$var1[3] = "d";
$var1[4] = "e";

$count = 4;
$i = 0;

while($i <= $count) {
echo $var1[$i] . "<br>";
$i++;
}

 

foreach is a little shorter

[papillonstudios]

thanks elis for explaining that, but could i get help with what i started this topic for

 

Could you guys help me with getting all the data pulled from my database table for my news feed into an array so i can display them

[Philip]

$query = "SELECT * FROM `table`";
$result = mysql_query($query);

while($row = mysql_fetch_assoc($result)) {
   echo $row['col'], '<br>';
}

 

If you wanted to use a foreach statement, it would seem rather pointless because it would do something like:

$query = "SELECT * FROM `table`";
$result = mysql_query($query);

$array = array();
// gather each row into the array
while($row = mysql_fetch_assoc($result)) {
   $array[] =  $row['col'];
}
foreach($array as $key=>$value) {
   echo $value,'<br>';
}

[papillonstudios]

hey thanks man for the help. your a great help.

 

I love this forum, will never leave

[papillonstudios]

got one more question i want it to how to make the while loop go in reverse order. to the first message is displayed last.

 

<?php
//Selecting the News From trhe Table news
$query = "SELECT * FROM `news`";
$result = mysql_query($query);

while($row = mysql_fetch_assoc($result)) {
echo '<div class="post">';
   	echo '<h2>', $row['title'], '</h2>';
  	echo '<small>', $row['date'], ' by ', $row['username'], '</small>';
  	echo '<br />';
  	echo '<br />';
echo typography($row['body']);
echo '<br />';
echo '<br />';
echo '</div>';
}
?>

[Philip]

Use ORDER BY in your MySQL query.

[papillonstudios]

thanks i got it working