How to display the data base values order by date using jquery here?

Question

<script type="text/javascript">  
      $(document).ready(function()
               {
                        $("#datetbtn").click(function(){
                     db.transaction(function(tx) {
                     tx.executeSql('SELECT * FROM materials_table ORDER BY time;',[], querySuccess);
                         });    
                                                });
                                                });
     </script> 


function updateMaterialDB(tx) {
                time = new Date();
query = 'INSERT INTO materials_table (id, material_title, type, course_id,last_accessed,) VALUES (' 

                + time + '", "'
                + size + '", "'
                + is_downloaded
                + '")';
                query = query.replace(/\//g,"");
                console.log(query);
                tx.executeSql(query);
            }

Here i want to display the values order by date using jquery ? here the values are not changed in the line using query

tx.executeSql('SELECT * FROM materials_table ORDER BY time;',[], querySuccess);
                         });

What datatype is `time`? Have you tried running this script in SSMS? Does it produce different results? — Curtis, Mar 12 '12 at 11:25
do not write down your sql code into javascript , it can be hacked very easily. do it by ajax call with a backend code.. — Tolga Arican, Mar 12 '12 at 11:29

score 0 · Answer 1 · edited May 23 '17 at 12:11

0

Take the data in json format and in json format you can sorting data.

Reference : Sorting a JavaScript object by property name

edited May 23 '17 at 12:11

Community

1
1

answered Mar 12 '12 at 11:26

Gaurav Agrawal

4,355
10
42
61

How to display the data base values order by date using jquery here?

1 Answers1