Returning the 'last' row of each 'group by' in MySQL

Returning the last row of each GROUP BY in MySQL with WHERE clause:

"SELECT *
FROM foo
WHERE id IN (
  SELECT Max(id)
  FROM foo
  WHERE value='XYZ'
  GROUP BY u_id
)
LIMIT 0,30"

Comments

Jquery form validation with ajax request

Include library <script src = "js/jquery.min.js" ></script> <script src = "js/jquery.validate.js" ></script> <?php $_SESSION [ 'code' ]= rand ( 1000 , 2000 ); ?> <form name = "form-signup" id = "form-signup" method = "post" > <table width = "50%" > <tr> <td> Name </td> <td><input type = "text" name = "name" id = "name" class = "change" ></td> </tr> <tr> <td> Email </td> <td><input type = "text" name = "email" id = "email" class = "change" ></td> </tr> <tr> <td> Username </td> <td><input type = "text" name = "username" id = "username" class = "chan...

Select Insert Update Delete With Image In Php MySQL

CRUD with image upload is a very common task in web development ( CRUD stands for Create/Read/Update/Delete ). The main purpose of a CRUD is that enables user’s create/read/update/delete data using PHP & MYSQL. Table of Content Create Database Insert Record with image upload Show Record Edit Record Delete Record

PHP+AJAX+MYSQL: Sort & Save using Drag & Drop (TABLE TR)

" Drag, Drop, Sort, Save " Drag & Drop : Move the draggable element by clicking on it with the mouse and dragging it anywhere within the viewport. Sor t: The sort order can be either alphabetic or numeric, and either ascending or descending. Here we had created demo that allow the user to drag and drop elements and quickly and save them with PHP + MySQL+ AJAX +JQUERY on the server side. Table of content 1) Drag and drop element on every click 2) Sort data on the server side using PHP+MYSQL 3) Great user interface and easy to execute with a few lines of code

Programming Tutorials On PHP,ASP.NET,AJAX,JQUERY,HTML

Search This Blog