title: Ajax: Get last row from database
body: <p>Is it possible to get the last row from MySql database using Ajax?</p>
  
  <p>So this is my PHP:</p>
  
  <pre><code>&lt;?php 
    include('../../dbconn.php');
    //--------------------------------------------------------------------------
    // Example php script for fetching data from mysql database
    //--------------------------------------------------------------------------
    $databaseName = "test";
    $tableName = "generalTransactions";
  
    //--------------------------------------------------------------------------
    // 1) Connect to mysql database
    //--------------------------------------------------------------------------
  
    $con = mysql_connect($gaSql['server'],$gaSql['user'],$gaSql['password']);
    $dbs = mysql_select_db($databaseName, $con);
    //--------------------------------------------------------------------------
    // 2) Query database for data
    //--------------------------------------------------------------------------
  
    $result = mysql_query("SELECT * FROM $tableName");          //query
    $array = mysql_fetch_row($result);                          //fetch result                          
    //--------------------------------------------------------------------------
    // 3) echo result as json 
    //--------------------------------------------------------------------------
    echo json_encode($array);
  
  ?&gt;
  </code></pre>
  
  <p>This is the Ajax:</p>
  
  <pre><code>$(function () 
    {
      //-----------------------------------------------------------------------
      // 2) Send a http request with AJAX http://api.jquery.com/jQuery.ajax/
      //-----------------------------------------------------------------------
      $.ajax({                                      
        url: 'general/transactions/add-journal.php',                  //the script to call to get data          
        data: '',                        //you can insert url argumnets here to pass to api.php
                                         //for example "id=5&amp;parent=6"
        dataType: 'json',                //data format      
        success: function(data)          //on recieve of reply
        {
          var id = data[0];
          var prefix = data[1];                //get prefix
          var journalNum = data[2];            //get journal number 
          //--------------------------------------------------------------------
          // 3) Update html content
          //--------------------------------------------------------------------
          //recommend reading up on jquery selectors they are awesome 
          // http://api.jquery.com/category/selectors/
          if(!journalNum){
              $('#generalJournalNumber').val('GJ00000001');
          }
          id++;
          $('#generalJournalNumber').val(prefix+'0000000'+id);
        } 
      });
    }); 
  </code></pre>
  
  <p>So basically I want to get the last id and auto increment it, the above only increments the first row in the database.</p>
  
  <p>Any help or suggestions, will be appreciated!</p>