Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

PHP programming problem!!

Options
  • 15-01-2006 12:22am
    #1
    caudiefra
    Closed Accounts Posts: 1 ✭


    Hi!

    I am having many problem with a simple PHP program!

    I want to read the most recent (100 most recent) database posts and display them. My code work but it is dirty! Does anyone know an easier way??!

    [PHP]
    echo "<html><body>";

    // connect to database

    $my_db = mysql_connect($dbhost, $dbuser, $dbpass) or die("Could not connect to DB. Error: ".mysql_error());
    mysql_select_db($db) or die("Could not select DB. Error: ".mysql_error());

    // find out how many rows in the table

    $my_db_rows = "select count(keywords) from keywords";
    $my_db_numrows = mysql_query($my_db_rows) or die("Could not get number of rows. Error: ".mysql_error());
    $my_dbs_rows = mysql_fetch_row($my_db_numrows);

    // the last row

    $my_dbs_rows[0]--;

    // the 100th row before the last row

    $my_db_last_100 = ($my_dbs_rows[0] - 99);

    // our query

    $my_db_query = "select keywords from keywords limit ".$my_db_last_100.",".$my_dbs_rows[0]."";
    $the_rows = mysql_query($my_db_query) or die("Could not retrieve most recent 100 rows. Error: ".mysql_error());

    // print our results in HTML

    $counter = 0;
    $newarray = array();
    while($each_keyword = mysql_fetch_array($the_rows))
    {
    $newarray[$counter] = $each_keyword[0];
    $counter++;
    }

    for($i=99;$i>-1;$i--)
    echo "$newarray[$i]<br>";

    mysql_free_result($my_db_numrows);
    mysql_free_result($the_rows);

    mysql_close($my_db);


    echo "</body></html>";
    [/PHP]

    As you can see I am selecting each database item and then putting it into another array, and then reading the new array backwards!

    Is there easier way?


Comments

  • Options
    #2
    clearz
    Registered Users Posts: 877 ✭✭✭clearz


    Look at the SQL
    ORDER BY <field> DESC
    ORDER BY <field> ASC

    http://www.w3schools.com/sql/sql_orderby.asp

    Then the database will handle the order that you reciece the data in.
    That way you can do away with that messy array code and output the text from within the while loop
    [COLOR=#000000][COLOR=#007700]while([/COLOR][COLOR=#0000bb]$each_keyword [/COLOR][COLOR=#007700]= [/COLOR][COLOR=#0000bb]mysql_fetch_array[/COLOR][COLOR=#007700]([/COLOR][COLOR=#0000bb]$the_rows[/COLOR][COLOR=#007700])) 
{ 
    echo  [/COLOR][COLOR=#007700] [/COLOR][COLOR=#0000bb]$each_keyword[/COLOR][COLOR=#007700][[/COLOR][COLOR=#0000bb]0[/COLOR][COLOR=#007700]];[/COLOR][COLOR=#007700]
} [/COLOR][/COLOR]


  • Options
    #3
    JoeB-
    Registered Users Posts: 689 ✭✭✭JoeB-


    Hi
    Could you not use SQL like...

    $query = "SELECT keywords FROM keywords ORDER BY keywordID desc LIMIT 100";

    this should give the most recent 100 entries as ordered by the 'keywordID' column, or whatever colume you use for ordering... if there aren't 100 entries, no problem, all are returned...

    You could use table HTML in the loop to make the output more pretty...
    echo "<td> .$yourValue </td><br>"


    ... the following code displays info from multiple columns and rows in a table format... all you have to do is supply the query...

    $result = mysql_query($query);
    $numFields = mysql_num_fields($result);

    echo "<table>";
    while ($row = mysql_fetch_row($result)) {
    echo "<tr>"; //Start row on table
    $rowNum += 1;
    echo "<td>" . $rowNum . "</td>";

    for ($i=0; $i<=$numFields-1; $i++) {
    echo "<td>" . $row[$i] . "</td>"; //Output all fields in row...
    }

    echo "</tr>"; //This ends this row on table...
    }
    echo '</table>'; // End Table


    I've previewed this and it's hard to follow, all the tabs are removed, it'll make more sense if tabbed correctly to show the loops...

    Cheers
    Joe


  • Options
    #4
    clearz
    Registered Users Posts: 877 ✭✭✭clearz


    JoeBallantine wrote:
    Hi
    Could you not use SQL like...

    $query = "SELECT keywords FROM keywords ORDER BY keywordID desc LIMIT 100";

    this should give the most recent 100 entries as ordered by the 'keywordID' column, or whatever colume you use for ordering... if there aren't 100 entries, no problem, all are returned...

    You could use table HTML in the loop to make the output more pretty...
    echo "<td> .$yourValue </td><br>"


    ... the following code displays info from multiple columns and rows in a table format... all you have to do is supply the query...

    $result = mysql_query($query);
    $numFields = mysql_num_fields($result);

    echo "<table>";
    while ($row = mysql_fetch_row($result)) {
    echo "<tr>"; //Start row on table
    $rowNum += 1;
    echo "<td>" . $rowNum . "</td>";

    for ($i=0; $i<=$numFields-1; $i++) {
    echo "<td>" . $row[$i] . "</td>"; //Output all fields in row...
    }

    echo "</tr>"; //This ends this row on table...
    }
    echo '</table>'; // End Table


    I've previewed this and it's hard to follow, all the tabs are removed, it'll make more sense if tabbed correctly to show the loops...

    Cheers
    Joe


    Diddnt I just say that.


Advertisement