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 QuestionsWhy does this code not work? Returns this error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND ClaimNo = AND UserName = john' at line 2
First i created the log in page now i want to connect to the database from where username and password table is save.How i create the php codes to give relation between them?
What is difference between mysql_fetch_array and mysql_fetch_object?
How do I limit the number of rows returned?
First of all I'm new to php n' mySql . So I just can't figure out what's the wrong in my code. I'm using WAMP and I've created a db named "Try" and in that there is a table named "test". this is my php code and it dosen't give me a