The MySQL SUM function takes the fields or rows you input and adds their values together, then returns the total. Save your query in a PHP variable. You can use the function as many times as you ...

Also, is the table1.column1 a string or numeric field? Your SQL query treats it like a string but your PHP sql is treating it like a number.<BR><BR>--The Dan ...

4. The MySQL server receives the database query, processes it, and sends the results—a list of books—back to the PHP engine. 5. The PHP engine finishes running the script.

The date for the events is stored in MySQL date format. What I want to display on my PHP page is a list of upcoming events in the next 60 days, and have it divided up by month.

Also the latest version of PHP (version 5 and above) supports calling of stored procedures in MySQL 5. In this article, we will see the glimpse of stored procedures in MySQL and calling them ...