print multiple arrays in foreach

Question

How can i get row href to be 'id' string value from database ? In other words, how can i show multiple arrays in one foreach ?

If theres any other logical errors in code you can point that out too.

<?php 

$query = mysql_query("SELECT `id`, `url` FROM `bse` ORDER BY `id` DESC LIMIT 9"); 
while ($row = mysql_fetch_array ($query))

$post_id[] = $row['id'];
$rid[] = $row['url'];

}

$array = array(
    "pid" => $post_id,
    "vid" => $rid,
);

foreach (array_chunk($array["vid"], 3) as $rida) { ?>
    <tr>
    <?php foreach ($rida as $array["vid"])
                {  ?>
<td><div class="a45"><a href="<?php echo $array["pid"]; ?>" title="nim" ><?php 
echo $array["vid"];

?>
</a></div></td>
    <?php } ?>
    </tr>
<?php } ?>
</table>

Just a quick note, you don't need to put `id` `url` `bse` inside backticks, since they are not [SQL reserved words](http://dev.mysql.com/doc/refman/5.5/en/reserved-words.html). — Funk Forty Niner, Oct 02 '13 at 19:58
The MySQL extension is outdated. Please don't use it anymore! MySQLi (with prepared statements) and PDO are good alternatives. — ComFreek, Oct 02 '13 at 19:59
@Fred-ii-, i think the motive of the backticks is for when the names of the columns, tables, etc, have problematic characters. — Rafael Barros, Oct 02 '13 at 20:07
@RafaelBarros You think? You may be right, a lot of things I'm not aware about SQL (learning DB for only a month now) and will keep that in mind, thanks. *"Stranger things are meant to happen."* — Funk Forty Niner, Oct 02 '13 at 20:08
@Fred-ii-, yes, just think, i could search to be certain, but, you know... laziness. One more thing: i think :) the backticks it's used just is MySQL. Others dbs, others characters. — Rafael Barros, Oct 02 '13 at 20:15
@RafaelBarros Well I certainly won't leave it out of the equation. *"I'll just take your word for it"* ;-) — Funk Forty Niner, Oct 02 '13 at 20:17

score 1 · Answer 1 · edited May 23 '17 at 12:03

1

You have two options. One is merging the arrays to just one array, take a read here:

how to join two multidimensional arrays in php

PHP combine two associative arrays into one array

The other (Thanks to Rafael!) is much easier.. Use something like this:

foreach($array as $i=>$v){
    $other_array[$i];
}

You can use the $i and look in the other array. Credits ofcourse to Rafael.

edited May 23 '17 at 12:03

Community

1
1

answered Oct 02 '13 at 20:03

Joran Den Houting

3,149
3
21
51

1

Hello again :). Yes, it's possible (despite a little ugly) with something like this: `foreach($array as $i=>$v){$other_array[$i];}` – Rafael Barros Oct 02 '13 at 20:11
1

Hi again @RafaelBarros! :p You just beat me to it, didn't even thought about using the `$i` on another variable as identifier.. Thanks for correcting me! – Joran Den Houting Oct 02 '13 at 20:15
how can i chop these 3 results to row ? – Tegi Ja Oct 03 '13 at 18:21

score 0 · Answer 2 · answered Oct 02 '13 at 20:15

Is this what you're looking to do?

<?php 
$query = mysql_query("SELECT `id`, `url` FROM `bse` ORDER BY `id` DESC LIMIT 9");

if($query){
    ?>
    <table>
    <?PHP
        while ($row = mysql_fetch_array ($query)){
             ?>
          <tr>
            <td>
                <div class="a45">
                    <a href="<?php echo $row['id']; ?>" title="nim" >
                        <?php echo $row['url']; ?>
                    </a>
                </div>
            </td>
          </tr>
          <?php
        }
    ?>
    </table>
    <?PHP
} else {
    echo "No results";  
}
?>

If not, what is it that you're trying to accomplish?

this is what i want but results in 3x3 table. – Tegi Ja Oct 03 '13 at 14:34 — Tegi Ja, Oct 03 '13 at 14:34

print multiple arrays in foreach

2 Answers2