Simple(?) question regarding display of data?

fnordboy

Hello, and thanks in advance.

I am having a problem figuring out what I think is a simple thing.

Basically I want to display the last 26 items added to the MySQL database. Sort them descending by ID. I understand how to do that fine, the situation is that I want the first one to display differently from the other 25, like a featured item.

Do I need to do two separate queries, or can it be combined. And if I do need to do 2 separate queries how do I skip the latest ID in the second query (since that would be the featured item)?

Hopefully I explained my dilemma ok. Thanks.

Piranha

Something like this should work. Note that it is not valid coding, just to let you get an idea how you can handle it.

$result = mysql_query("SELECT something FROM table LIMIT 0, 26");
if ($row = mysql_fetch_row($result))
do something with the first row
while ($row = mysql_fetch_row($result))
do something else with the rest of the rows

fnordboy

Thanks, this helps point me in the right direction. I will go do some trial and error and see if I can get this working.

fnordboy

This is in a different section of the site, but it relates:

How would I adapt the following code to ignore the first (the latest added ID) result?

<ul class="sidenavItemUL">
<?
include("dbinfo.inc");
mysql_connect("localhost",$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM reviews WHERE public='Y' ORDER BY id DESC LIMIT 25";
$result=mysql_query($query);

$num=mysql_numrows($result); 
mysql_close();
?>
<?
$i=0;
while ($i < $num) {
$id_rev=mysql_result($result,$i,"id");
$band_rev=mysql_result($result,$i,"band");
$album_rev=mysql_result($result,$i,"album");
$recordco_rev=mysql_result($result,$i,"recordco");
?>
<li class="sidenavItems"><a href="review/<? echo "$id_rev"; ?>.html"><? echo "$band_rev"; ?> - <i><? echo "$album_rev"; ?></i></a> (<? echo "$recordco_rev"; ?>)</li>
<?
++$i;
} 
?>
</ul>

It's a similar situation, but the "featured" item is display elsewhere so I can't work them together.

Piranha

There are two ways I can answer. The first way is to give you a solution. But by doing that you will only solve this problem, and have to ask next time. The second way is to help you help yourself. It is a little harder, both for you and me, but you will learn to find the solutions yourself. In the long run it will save time and effort. Not supprisingly I am after the second way of helping.

So my question to you is what you have done to solve this problem.

fnordboy

Piranha wrote:
So my question to you is what you have done to solve this problem.

Besides google and php tutorial sites, etc?

Oh yeah, I posted my question on a forum that is supposed to be helpful. :rolleyes:

Piranha

As I said in the previous post, I aim to help people help themselfes. In my opinion it is impossible to be more helpful than that. 😉 Next time please be more specific about what you used to search in google etc, otherwise it is not helpful to know that you used google. Don't get me wrong, of course you should post questions when you have problems. But please show what you have done to solve the problems as well.

Anyway, in the manual about [man]mysql_result[/man] it says:

row

The row number from the result that's being retrieved. Row numbers start at [i]0[/i].

Your loop start to count at 0 as well. To omit the first row you should start from position 1.

Roger_Ramjet

If you read the manual you would also see this under mysql_result()
you should consider using one of the functions that fetch an entire row (specified below). As these functions return the contents of multiple cells in one function call, they're MUCH quicker than mysql_result().

And this under mysql_close()
Using mysql_close() isn't usually necessary, as non-persistent open links are automatically closed at the end of the script's execution.

Finally, there is no need to use a count for your loop control. If you don't need the first row then don't select it from the db in the first place.

$query="SELECT * FROM reviews WHERE public='Y' ORDER BY id DESC LIMIT 1, 24"; 
$result=mysql_query($query);

while ($row = mysql_fetch_array($result)) {