Database Related Tutorials - LearnPHP.org
Updating existing rows in a table requires to run the UPDATE statement with a WHERE clause to identify the row.
October 10,
2007
Today Views:
2 Total Views:
335
If you want to remove a row from a table, you can use the DELETE statement with a WHERE clause to identify the row.
October 9,
2007
Today Views:
1 Total Views:
312
Text values in SQL statements should be quoted with single quotes ('). If the text value contains a single quote ('), it should be protected by replacing it with two single quotes ('').
October 8,
2007
Today Views:
1 Total Views:
315
Learn how to create your own poll script without a MySql database using PHP and flat files databases.
October 5,
2007
Today Views:
1 Total Views:
733
If you want to provide date and time values in a SQL statement, you should write them in the format of "yyyy-mm-dd hh:mm:ss", and quoted with single quotes (').
October 4,
2007
Today Views:
3 Total Views:
321
In this chapter, you'll learn how to take information stored in a database and display it on a Web page for all to see.
October 3,
2007
Today Views:
1 Total Views:
345
In this chapter, we'll introduce the PHP server-side scripting language. In addition to the basic features we'll explore here, this language has full support for communication with MySQL databases.
October 2,
2007
Today Views:
1 Total Views:
284
You have seen a lots of Websites are displaying past times in days, hours and minutes. If you want to do this yourself, you can use the DATEDIFF() SQL function.
October 2,
2007
Today Views:
1 Total Views:
276
The simplest way to perform key word search is to use the SELECT statement with a LIKE operator in the WHERE clause.
October 1,
2007
Today Views:
1 Total Views:
259
If you want to query information stored in multiple tables, you can use the SELECT statement with a WHERE condition to make an inner join.
September 28,
2007
Today Views:
1 Total Views:
249
