Tags: query

Sort by: Date / Title /

  1. Get last entry
    3 months ago by nox.freak
    This will get the last entry into a database where COL is equal to something.
    1. SELECT * FROM TABLE WHERE COL=something ORDER BY id DESC LIMIT 0,1
    View source | 0
  2. MySQL Query
    3 months ago by nox.freak
    This is just a basic way to query a MySQL database.
    1. define("DBNAME", "db_name");
    2. define("HOST", "localhost");
    3. define("USER", "foo");
    4. define("PASSWORD", "bar");
    5.  
    6. $dbconnect = mysql_connect(HOST, USER, PASSWORD);
    7. mysql_select_db(DBNAME, $dbconnect);
    8.  
    9. $sql = 'SELECT * FROM table';
    10. $q = mysql_query($sql, $dbconnect) or die("Error: " . mysql_error());
    11. $num = mysql_num_rows($q);
    12. for ($i=0; $i<$num; $i++)
    13. {
    14.         $dbOut = mysql_fetch_assoc($q);
    15.         echo $dbOut['col'];
    16. }
    View source | 0

First / Previous / Next / Last / Page 1 of 1 (2 posteets)