How to get something out of the database
Database name: XL table: Page field has 5, id-name-title-text-time
After I connect the database, how to construct the SQL statement query ID greater than 0 of the table, the database inside the ID is automatically increased.
Sql= "SELECT * from Xl.page WHERE id>0"; This kind of don't know can.
How do I get the data to the page? I just know a function, but I don't know how to use it.
$res = mysql_query ($sql); Assign the data you've got to a variable
And then what about Mysql_num_rows ($res); So, I've tried this, show no data, if you want to call it separately
The time inside the field should be done. Thank you
------Solution--------------------
Mysql_query get a result set, multi-turn manual
PHP Code
$res = mysql_query ($sql), while ($row = Mysql_fetch_assoc ($res)) { echo $row ["Time"];}