I'm having a problem in displaying data from the table.I've a candidate table in the db. i 've got the problem when i try to select the place of the candidate in the main html code. the html has the place selector, frist name, middle name and partystatus of it. when i try to select the place it should retrive from the db table. and displays the names and party status. i wrote the php code to track this
if ($place == "zone")
{
$w=0;
$result=mysql_query("select first name,middlename, party from candidate") or
die (mysql_error());
//$row=mysql_fetch_array($result);
while ($row=mysql_fetch_array($result))
{
echo' $first name:$row["firstname"]
$middlename: $row["midddlename"]
$party: $row["party"]
}
i wrote it like this but it has a problem, i want it to count and find the place and the row.. check it for me...