Jump to content

sql yog..help pls

Recommended Posts

okay so my current problem is my table only shows this


photo 1..


this is the code


this is the one need to be changed

$query="SELECT * FROM tbllocation where districtid = '$district'";

while($row=mysql_fetch_array($result)) { 
$code = $row['code'];
$description = $row['description'];
    $districtid = $row['districtid'];    
echo "<tr><td>$code</td>";
echo "<td>$description</td></tr>";
echo "<td>$districtid</td></tr>";




okay based on photo 1..i need to change the districtid with description from another table that is called tbldistrict





okay so i need the DESCRIPTION from tbldistrict to replace DISTRICTID as in photo 1..



how do i do the query..n the codes to display it. please teach me. im new..




Link to post
Share on other sites


This topic is now archived and is closed to further replies.

  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.