RE: [PHP] reverse array for mysql data

[Alok K. Dhir]

You're looking in the wrong place.  What you want to do should be
handled at the database level.  I.e. your SQL query should be something
like:

select title,body from junkyard order by item_number desc, limit
7

Since you refer to what you want as the 'top 7' entries, there is
presumably some sort of order that you are attempting to enforce in what
you display.  The way you currently have your query formed, the results
you get back are not guaranteed to have any order.  You must add the
order by clause.  

The next problem you're likely to have, is that you don't have any way
of enforcing order in your database other than the item number, which is
probably not what you want.  In this case, what is it that determines
whether something is in the 'top 7'?  Is it based on time?  Is it
alphabetical?  Whatever it is, you need to sort by the corresponding
field.

My guess is that you're going to want to add a timestamp column to your
database, and order by that, descending (i.e. highest to lowest).

Once you do this, you don't need to change your php code at all which
executes the query and displays the results.

Good luck.

Al

> -Original Message-
> From: 
> [EMAIL PROTECTED] 
> [mailto:[EMAIL PROTECTED].
> net] On Behalf Of ktb
> Sent: Monday, April 30, 2001 2:52 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP] reverse array for mysql data
> 
> 
> I'm new at programing and not getting very far with this.  
> I've looked at "array_revers" and "array_multisort" and can't 
> get anything to work. What I have is a mysql table laid out like:
> 
> item number |  title | body text | subject heading
> 
> What I want to do is pull the top 7 entries off and display 
> them on a web page.  I have written some code that will do 
> this but when it prints to the web page the first item is 
> printed at the top and I would like it on the bottom with 
> later entries successively on top.  How can I do this?  Hear 
> is the code I have so far:
> 
> $result = mysql_query ("SELECT title, body FROM junkyard 
> LIMIT 0, 7"); $i = '0';
> 
> while ($i < 7) {
> if ($row = mysql_fetch_array ($result)) {
> echo "$row[0] $row[1]";
> ++$i;
> }
> }
> 
> Thanks,
> kent
> 
> 
> 
> -- 
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: 
> [EMAIL PROTECTED] To contact the list 
> administrators, e-mail: [EMAIL PROTECTED]
> 
> 


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Re: [PHP] reverse array for mysql data

[Gyozo Papp]

> I'm new at programing and not getting very far with this.  I've looked
> at "array_revers" and "array_multisort" and can't get anything to work.
> What I have is a mysql table laid out like:
> 
> item number |  title | body text | subject heading
> 
> What I want to do is pull the top 7 entries off and display them on a
> web page.  I have written some code that will do this but when it prints
> to the web page the first item is printed at the top and I would like it
> on the bottom with later entries successively on top.  How can I do
> this?  Hear is the code I have so far:
> 
> $result = mysql_query ("SELECT title, body FROM junkyard LIMIT 0, 7");

i) maybe, you add an ORDER BY clause to your query. This cause that returning rows in 
the result set are ordered in that way you 've specified.
ORDER BY works as follows : ORDER BY  ASC for ascending or DESC for 
descending sorting.
(you can give more than one column name.)
 $result = mysql_query ("SELECT title, body FROM junkyard ORDER BY title DESC LIMIT 0, 
7");

or you can gather all the rows you need in an array and print this array as you love.

for ($i = 0 ; $i < 7 && ($result_rows[] = mysql_fetch_array($result)); $i++) ;

> $i = '0';
> 
> while ($i < 7) {
> if ($row = mysql_fetch_array ($result)) {
> echo "$row[0] $row[1]";
> ++$i;
> }
> }
> 



--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]