How do I return the date with mySQL?
For instance when a user registers for the site, you might want to record the date they registered on, and so forth.
To do so, use the CURDATE() function within mysql, like this:
$todayis = mysql_query("SELECT CURDATE() FROM table");
$itis = mysql_result($todayis,0,0);
echo "Today is: $itis";
More mysql PHP QuestionsHOW can i retrieve database elements and make them select options on a form My Test Form Please, choose item to order:
I am extracting data from a MySQL Database of which one of the data stored is seperated by a comma. For example, step1,go here,step 2,go there,step 3,go back etc etc. I want to know how to split the data at the comma and format it in html. Using the split
How do I group the results of a mysql query?
I need to test database time needed to execute scryp (like 10 000 inputs) with what command i can start measuring time, start scrypt, and then to stop time when scrypt is done and get time resault?
Equip table and Vendor table. Each piece of equipment has a matching vendor ID. How to display vendor name instead of ID in PHP output?