1. select continent,country,concat("area: ",area," population: ",population) from countries
2. select left(country,1) as lex,country from countries
3. select continent,left(country,1) as lex,concat(country," (",capital,")") from countries
4. select concat(conti.continent," (",FORMAT(sum_pop,0),")") as cont_pop,country,FORMAT(country.population,0) from (select continent,sum(population) as sum_pop from countries group by continent) as conti left join (select continent,country,population from countries) as country on conti.continent=country.continent
Category:
PHP DataGrid has been created for selecting data, displaying it as a grid, and perform routine operations on it. This tool is defined for PHP applications and its version 1.x operates data only from MySQL.
It allows paging through results, editing, deleting and inserting new data. PHP DataGrid can be very helpfull for you to display any complex data from database and to automatically perform any needed operations of them. By enabling or disabling its features you can turn PHP DataGrid into something very helpfull for you.
Category: