help with multiple mysql rows?

[joecooper]

Hi,

 

i have a site im building, its like one of those sites that update daily with funny videos / games.

 

i have a mysql database with a game title, description and link.

 

I need the last 2 enterys added (using the ID field) to be seperate at the top (featured), and then the rest to be on a table as a list, 10 on each page.

 

i used to use this before but was a while ago and since lost the code i had.

 

thanks.

[pocobueno1388]

You could do this:

 

<?php

$query = mysql_query("SELECT fields FROM table");

$i = 1;
while ($row = mysql_fetch_assoc($query)){

   if ($i == 1 || $i == 2){
      //this is where you put the code for the two featured posts
   } else {
      //this is where you put the code for all the other posts
   }

$i++;
}

?>

 

[joecooper]

so to return the "title", would it be $row['title']?

[pocobueno1388]

so to return the "title", would it be $row['title']?

 

Yes, as long as you use the code I supplied. Just make sure you change the query to select what you need.

[joecooper]

ok, although the 2 featured need to be the last 2 added, so the highest number ID, not 1 & 2, how can i do this?

[pocobueno1388]

change the query to

$query = mysql_query("SELECT fields FROM table ORDER BY id DESC");

[joecooper]

include("db.php");
     $query = mysql_query("Select * FROM games");

$i = 1;
while ($row = mysql_fetch_assoc($query)){

   if ($i == 1 || $i == 2){
      echo("$row['title']");
   } else {
      //this is where you put the code for all the other posts
   }

$i++;
}

 

that always returns a blank page, no errors or anything. and even the HTML that comes after is cleared.

[pocobueno1388]

Try

 

<?php
include("db.php");

$query = mysql_query("SELECT * FROM games")or die(mysql_error());

$i = 1;
while ($row = mysql_fetch_assoc($query)){

   if ($i == 1 || $i == 2){
      echo $row['title'] .'<br>';
   } else {
      //this is where you put the code for all the other posts
   }

$i++;
}