column dependent on row value
Posted: Sat Nov 14, 2009 1:25 am
I m writing a code in mysql using php. I have a database based on world.
I have a code which have particular regions but then I want it to also display number of places based on region. I have written a query which is working but I want it to display region and number of places in that region. How do I do this with my code?
Please help me.
Thanks
Code: Select all
CREATE TABLE world (
place VARCHAR(50) NOT NULL,
region VARCHAR(15) NOT NULL,
distance VARCHAR(20),
);Code: Select all
foreach ($regions as $r)
{
echo '<option value="',$r,'">',$r,"</option>";
echo '</select></p>';
}Thanks