Printing result of mysql query from variable

Question

So I wrote this earlier  in php   but everytime I try echo  test   I just get back resource id 5  Does anyone know how to actually print out the mysql query from the variable    dave  mysql query  SELECT order date  no of items  shipping charge  SUM total order amount  as test FROM  orders  WHERE DATE  order date     DATE NOW    GROUP BY DATE  order date     or die mysql error     print  dave

User · Answer

well you are returning an array of items from the database  so you need something like this       dave  mysql query  SELECT order date  no of items  shipping charge       SUM total order amount  as test FROM  orders       WHERE DATE  order date     DATE NOW    GROUP BY DATE  order date          or  die mysql error       while   row   mysql fetch assoc  dave     echo  row  order date    echo  row  no of items    echo  row  shipping charge    echo  row  test

User · Answer

sql    SELECT   FROM table name ORDER BY ID DESC LIMIT 1    records   mysql query  sql     you can change     LIMIT 1 to    LIMIT any number you want  This will show you the last INSERTED row first

User · Answer

From php docs      For SELECT  SHOW  DESCRIBE  EXPLAIN and other statements returning   resultset  mysql query   returns a resource on success  or FALSE on   error       For other type of SQL statements  INSERT  UPDATE  DELETE  DROP  etc    mysql query   returns TRUE on success or FALSE on error       The returned result resource should be passed to mysql fetch array      and other functions for dealing with result tables  to access the   returned data    http   php net manual en function mysql-query php

User · Answer

This will print out the query    query    SELECT order date  no of items  shipping charge  SUM total order amount  as test FROM  orders  WHERE DATE  order date     DATE NOW    GROUP BY DATE  order date       dave  mysql query  query  or die mysql error     print  query    This will print out the results    query    SELECT order date  no of items  shipping charge  SUM total order amount  as test FROM  orders  WHERE DATE  order date     DATE NOW    GROUP BY DATE  order date       dave  mysql query  query  or die mysql error      while  row   mysql fetch assoc  dave        foreach  row as  cname   gt   cvalue           print   cname   cvalue t             print   r n

[php] Printing result of mysql query from variable

Examples related to php

Examples related to mysql