PHP - Mysql Select Last 3 Rows, Order By Id Asc?

Hello, my name is Casper.

Hello, i am wandering how to gather certain rows in mysql database as Orders.

The method i thought of was to sort them using TIMESTAMP or something.
A simply php code that generates a random number in a column, and that number is same in all the rows that has the same TIMESTAMP ?

Thanks

i have this query and i'm trying to order all of the results by `created` ascending. I've tried putting the later query before the first but the single row from the first query(the way it is right now) gets stuck as the last row in the results. How can i order the results of both queries?

Code: [Select]
(
SELECT *
FROM Account_activity
WHERE DATE( created ) <  '2011-08-01'
AND username =  '40'
ORDER BY created DESC
LIMIT 1
)
UNION (
SELECT *
FROM Account_activity
WHERE MONTH( created ) =  '08'
AND YEAR( created ) =  '2011'
AND username =  '40'
ORDER BY created ASC
)

what Im basically trying to do is just like a phpmyadmin function... you select rows you want to update with a checkbox and then it takes you to a page where the rows that are clicked are shown in forms so that you can view and edit info in them... and then have 1 submit button to update them all at once.

I teach 6 different class groups, named "A" to "F", respectively.

Hi ho, I am trying to assemble a table so that it shows article in order by id descending. The current one i am using is working but not displaying as i hoped, i need them aligned on the left and right, so id=1 align left, id=2 align right etc. Here's my current code

Code: [Select]
<table style='table-layout:fixed' align="center" cellpadding="2" cellspacing="0" colspan="" class="Main"><br>

<?
$select_paper=mysql_query("SELECT * FROM paper ORDER BY id DESC");
while($the=mysql_fetch_object($select_paper)){
?>
     <tr>
        <td class="subtableheader" width="25%"><?php echo "$the->title"; ?></td>
      </tr>

     <tr>
        <td class="profilerow"  width="100%"><?php echo "$the->news"; ?></td>
        </tr>
     <tr>
        <td class="subtableheader"  width="25%"><?php echo "Article By $the->by - $the->date"; ?></td>
        </tr>

I have 2 tables I have settup called Users_Messages and Users_Message_Replies inside each of these tables I have a row called DateSent, I'm trying to select from both of these tables and only display the latest Sent item by ID and order them all by date. I can get it to display the items correctly using the below code, but I can't get them to order correctly by the latest date in both of the Tables.
Code: [Select]
$page_query = mysql_query("
                         SELECT  MessageID, DateSent
                         FROM Users_Messages
                         WHERE ToID = '$user_ID'
                           
                           UNION
                         
                         SELECT  MessageID, DateSent
                         FROM Users_Messages
                         WHERE FromID = '$user_ID'

                         
                         ORDER BY DateSent DESC
                         ");
 
                      while ($replycheck = mysql_fetch_assoc($page_query)){

                          $message_idmainnew = $replycheck['MessageID'];
                          $date = $replycheck['DateSent'];

                          $sql2 = "SELECT  MainMessageID FROM Users_Message_Replies WHERE MainMessageID = '$message_idmainnew '";
                          $sql_result2 = mysql_query($sql2);
                          $replycheck2 = mysql_fetch_assoc($sql_result2);
                          $newreplyID = $replycheck2['MainMessageID'];
           
                          $sql4 = "SELECT MessageID FROM Users_Messages WHERE MessageID= '$message_idmainnew'";
                          $sql_result4 = mysql_query($sql4);
                          $messagecheck2 = mysql_fetch_assoc($sql_result4);
                          $newmessageID = $messagecheck2['MessageID'];

                          if ($newreplyID == NULL){
                          $sql2 = "SELECT * FROM Users_Messages WHERE MessageID= '$newmessageID' ORDER BY DateSent ASC";
                          $sql_result2 = mysql_query($sql2);
                          $message_row = mysql_fetch_assoc($sql_result2);
                         
                                $message_01 = $reply_row['Message'];
                      $date = $reply_row['DateSent'];
                      $date1 = strtotime($date);
                      $datemain = date('F j, Y, g:i a', $date1);
                     
                          }else{

                          $sql2 = "SELECT * FROM Users_Message_Replies WHERE MessageID= ' $newreplyID ' ORDER BY DateSent DESC";
                          $sql_result2 = mysql_query($sql2);
                          $reply_row = mysql_fetch_assoc($sql_result2);
 
                      $message_01 = $reply_row['Message'];

                           
                      $date = $reply_row['DateSent'];
                      $date1 = strtotime($date);
                      $datemain = date('F j, Y, g:i a', $date1);
                           }

                      {
Is there an easier way to do this? And how would I get the dates to line up, with a Join? Thanks.

hello, im only getting the second half of my results showing in my dropdown box.  here is my code.

Code: [Select]
if(isset($_GET['id']))
{
$uid = $_GET['id'];
}

$forward = mysql_query("SELECT * FROM players WHERE status = '1' AND position = 'forward' ORDER BY name");
$forward1="";
while($row1 = mysql_fetch_array($forward))
  {
$forwardid=$row1["id"];
$forwardname=$row1["name"];
$forwardteam=$row1["team"];
$forward1.="<OPTION TITLE=\"$forwardteam\" VALUE=\"$forwardid\">".$forwardname.'</option>';
  }

$result = mysql_query("SELECT * FROM picks WHERE uid = '$uid' AND pickid = 'forward1'");
while($row = mysql_fetch_array($result))
{
  $playerid=$row['playerid'];
}

if(isset($forwardpick1)) {
$result1 = mysql_query("SELECT * FROM players WHERE id = '$playerid'");
while($row1 = mysql_fetch_array($result1))
{
  $forwardpick1=$row1['name'];   
}
$forwardpick1="<br /><br /><font color ='#000000' size = '5'><b>$forwardpick1";
} else {
$forwardpick1="
<form method='POST' action='draftpick.php' name='forward1'>
<p><font color='#000000'><select size='1' name='player'>
<?php echo '$forward1'; ?>
</select><br><br><input type='submit' value='Submit' name='submit'></font></p>
</form>
";
}
any direction is appreciated.

Hey guys, I am having trouble figuring this out. I currently have a database that automatically sorts itself by the id of the data. But, I am wanting the user to be able to change the sort order via a select box. I already have the select box programmed with the options, but I am not sure how to go about coding the options to change the sort order of the displayed data. What would the best way to go about programming this be?

Thank you very much ahead of time!!

Hello, i am trying to get my form to list usernames ascending as an option, but the select field just returns blank.

Here is my code:

Code: [Select]
/**
 * editUserForm - Displays the users database table in
 * a nicely formatted field table.
 */

function editUserForm(){
   $q = "SELECT * "
       ."FROM ".TBL_USERS." ORDER BY username ASC";
   $result = $database->query($q);

while ($row = mysql_fetch_assoc($result))
{
echo '<option value="'.$row["username"].'">'.$row["username"].'</option>';
}
}

Code: [Select]
              <form action="/" method="post">

                <div class="column">
                  <p>
                    <select name="user" id="user" placeholder="Select A User To Edit" class="{validate:{required:true}}">
                      <option>Select A User To Edit</option>
                      <? editUserForm(); ?>
                    </select>
                  </p>

                <div class="action_bar">
                  <input type="submit" class="button blue" value="Submit Post" />
                  <a href="#modal" class="modal button">Cancel</a>
                </div>

              </form>

All help is appreciated

Hi,

I have the project where i want to get the structure like tree.

My table structu

Section_Id Section_Parent   Section_Name
1                0                        America
2                0                        China
3                1                       New york
4                1                       Washington
5                2                       Buffalo

How to retrieve the records..

I need a structure like this in a select button:

America
  New york
    Buffalo


Thanks,

 $result = mysql_query("SELECT *  FROM `friend_system` WHERE `friend_system_accepter` = '$myusername' ");
echo mysql_num_rows($result);

This displays the total rows in the table.

$result = mysql_query("SELECT COUNT(friend_system_accepter)  FROM `friend_system` WHERE `friend_system_accepter` = '$myusername' ");
echo mysql_num_rows($result);

This displays '1', which is incorrect.   I want to echo out the number of rows where 'friend_system_accepter' = $myusername   Thanks

Hello folks,   In trying to improve the user experience for my first WebApp I have decided to create two new tables - one a master file to contain a list of all stores, and the second a master file to contain a list of all products that are normally purchased - and I would like to use the values from these two tables as lookup values in dropdown listboxes, to which the user can also add new entries.   As it turns out, I'm stuck on the very first objective i.e. to lookup/pull-in the distinct values from the master tables.   The problem I'm having is that the query seems to return no rows at all...in spite of the fact that there a records in the table, and the exact same query (when run within the MySQL environment) returns all the rows correctly.   Is there something wrong with my code, or how can I debug to see whether or not the query is being executed?   Objective # 2, which is to allow new values to be entered into the dropdown listbox, and then inserted into the respective table is certainly waaay beyond my beginner skills, and I'll most certainly need to some help with that as well..so if I can get some code/directions in that regard it will be most appreciated.   Thank you.

<?php
   $sql = "SELECT DISTINCT store_name FROM store_master ORDER BY store_name ASC";

   $statement = $conn->prepare($sql);
   $statement->execute();

   $count = $statement->rowCount();                                    
   echo $count;

   // fetch ALL results pertaining to the query
   $result = $statement->fetchAll();

   echo "<select name=\"store_name\">";
   echo '<option value="">Please select...</option>';
   foreach($result as $row)
       {
          echo "<option value='" . $row['store_name'] . "'></option>";
       }
       echo "</select>";
?>

I'm currently trying to grab data from my database for my chatbox, which when displayed, displays in an ascending order, when I call it to descend, it shows the messages ONCE in descending order, then just repeats but in random order..

Code: [Select]
$sql = "SELECT * FROM `message` WHERE `chat_id` = 1 AND `message_id` > $last ORDER BY `message_id` DESC";
Database:
message_id | name
1                   RSX
2                   RSX
3                   RSX
4                   RSX

Code: [Select]
RSX: 4
RSX: 3
RSX: 2
RSX: 1
RSX: 4
RSX: 3
RSX: 2
RSX: 4
RSX: 3
RSX: 4

It is ordering it correctly, just repeats, I'm using Ajax, could that be the problem, or is it within the PHP code?

Edit:
I read it wrong, it displays as shown under "output".

Lets say I have this query:

$sql = mysql_query("SELECT * FROM Member ORDER BY posts DESC LIMIT 10");
while ($get = mysql_fetch_array($sql)){

$row .= $get['id'];
$posts .= $get['posts'];

echo "$row - $posts<br />";

}

Lets say I have two of rows, with posts fields of 84 and 803. When it displays it, it grabs the 84 row first, when I want the bigger number 803 first. Is there a way to fix this?