help with foreach

[hoponhiggo]

Hi Guys

 

This is my first time writing a 'foreach array' so go easy on me!

 

I am trying to echo all rows from a database in a new <div> for each record down my page. I have got the following code, but it aint working!

 

<?php
//get results from db

$sql = "SELECT * FROM Games";
$res = mysql_query($sql) or die(mysql_error());
if(mysql_num_rows($res) == 0) die("No records found");

foreach($res as $data)
{
$title=$data['gametitle'];
?>

<div id="gametitle">
<?php echo $title ?>
</div>

<?php
}
?>

 

Can somebody please help?

[wildteen88]

First, mysql_query does not return an array of results but a result resource. You'll need to use a while loop with mysql_fetch_assoc to loop through the results your query returns.

 

$sql = "SELECT * FROM Games";
$res = mysql_query($sql) or die(mysql_error());
if(mysql_num_rows($res) == 0) die("No records found");

// loop through the results returned by your query
while($data = mysql_fetch_assoc($res))
{
    $title=$data['gametitle'];
?>

<div id="gametitle">
<?php echo $title ?>
</div>

<?php
}
?>

[hoponhiggo]

Ah i see,

 

Thats quality.

 

So now i have a list of all the game titles down my page. I just need to figure how i can now turn these into links which will open more info about the game in a new page.

 

Can anybody point me in the right direction?

[wildteen88]

Just wrap <?php echo $title ?> in an anchor tag, example code

<a href="yourpage.php?id=<?php echo $id ?>"><?php echo $title ?></a>