Jump to content

ersaurabh101

New Members
  • Content Count

    7
  • Joined

  • Last visited

Everything posted by ersaurabh101

  1. My command is $stmt2 = "select rowsno , comid , sno , tag_from FROM tasktag where COMID='$COMID' and TAG_FROM = '$TAGFROM'"; I want to fetch 1 more value in it but from a different table using the sno from the above select command If wish to fetch LATEST_ACTIVITY_NO from admtask where sno = sno I want this inside stmt2 command only because its returning an array like this - [ { "ROWSNO": "2224", "COMID": "54578", "SNO": "31598", "TAG_FROM": "SAURABH" } ] and i wish to include LATEST_ACTIVITY_NO in it
  2. I have only 1 record ( this is - username,password saved in my table) I need to select the username and count the no. of rows but both of the things not working, copying my code below SELECT STATEMENT: returning me [object][object] var selectStatement = "select username FROM loggedinuser"; var result; function getusername() { db.transaction(function (tx) { tx.executeSql(selectStatement,[],querySuccess); }); function querySuccess(tx, results) { for(var i=0; i<results.rows.length; i++) { var row = results.rows.item; result =
  3. Hii, For local sqlite storage i am following this tutorial - https://tejasrpatel.wordpress.com/2011/12/29/create-sqlite-off-line-database-and-insertupdatedeletedrop-operations-in-sqlite-using-jquery-html5-inputs/ I am using these commands to create a table in my login.html page - var createStatement = "CREATE TABLE IF NOT EXISTS userdetails (username TEXT, password TEXT, company TEXT)"; var db = openDatabase("QuickTask", "1.0", "Quick Task", 200000); // Open SQLite Database function initDatabase() // Function Call When
  4. ohh, it should be ORDER BY RAND() , thanks worked , how to switch on php error reporting ?
  5. Hey, How you been, I was trying to work with json data in php and mysql using ajax Something strange is happening, when i comment the below line - // $row=mysqli_fetch_array($result,MYSQLI_ASSOC); <?php session_start(); $message=array(); include('database.php'); $sql="SELECT * from ratings ORDER BYRAND() LIMIT 1"; $result = mysqli_query($conn,$sql); $row=mysqli_fetch_array($result,MYSQLI_ASSOC); //$message["image"]=$row['image']; $message["message"]='hello'; //$message["message2"]='hello2'; header('content-type: application/json'); echo json_encode($message); I get the me
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.