Need Help!!

[Rsupun]

-----------------------------------------------------------------------
function getBits($pid){
global $conn;

$query="SELECT student_id,project_id,date(bid_date) AS bdate,amount
FROM (SELECT * FROM project_bid WHERE project_id='$pid')

AS pb LEFT JOIN project AS p ON pb.project_id=p.id;";
$result=mysql_query($query,$conn) or die("cannot run the bit query");

return $result;


------------------------------------------------------------------------------
මේ තියන උඩ Code එක Table දෙකකින් data ගන්න විදිහට හදා ගන්නේ කොහොමද මචන්ලා

මෙන්න මේ විදිහට table 2 කේ columns add කර ගන්න ඕනේ

project_bid table = student_id,project_id,date(bid_date)
student table = accepted, name

 

[RSmith]

Student Table ekata anik ekath ekkka connection ekak dapan student_id
eta passe a deken wena wenama ganna puluwan
Bump

 

[Rsupun]

Student Table ekata anik ekath ekkka connection ekak dapan student_id
eta passe a deken wena wenama ganna puluwan
Bump

man echara sql danne ne ban help ekak dipanko machan