Tuesday, 10 September 2013

SQL comment with array element PHP

SQL comment with array element PHP

This is my first question in this site hope that some one will help me
over here.
I have a investor table with some fields and a project table with some files
Project table
---------------------
project_investor_id 1,26,29,30,39,48
data stored as , separated values So in my investor admin area i want show
perticular project to show for logedin investor I am using this function.
public function list_all_projects_by_userid ($uid){
$rs = mysql_query("select * from project_table WHERE
project_investor_id LIKE '$uid' ORDER BY project_id DESC");
$i = 0;
while ($row = mysql_fetch_assoc($rs)) {
$result[$i]['project_id'] = $row['project_id'];
$result[$i]['project_investor_id'] = $row['project_investor_id'];
$result[$i]['project_name'] = $row['project_name'];
$result[$i]['project_location'] = $row['project_location'];
$result[$i]['project_location'] = $row['project_location'];
$result[$i]['project_phase'] = $row['project_phase'];
$result[$i]['project_capital'] = $row['project_capital'];
$result[$i]['project_notes'] = $row['project_notes'];
$result[$i]['project_file'] = $row['project_file'];
$i++;
}
return $result;
}
But its not working with project have multiple investors. Please let me
know how recode this?
Thank You

No comments:

Post a Comment