php join query for multiple tables

Question

Can anyone tell me how i can get the value for project_title, project_id, level_of_want, and selection_id. When i submit this i get No database selected error.

$query_Name = "SELECT u.Student_Surname, u.Student_Forename, p2.Project_Title,     
p2.Project_id, s.level_of_want, s.selection_id
FROM users u
INNER JOIN projects p2 ON u.id = p2.Project_Lecturer
INNER JOIN selection s ON p2.Project_id = s.id_project
INNER JOIN users u2 ON s.student_id = u2.id
WHERE u2.Username = ".$_SESSION['MM_Username']." ORDER BY selection_id ASC" ;
$Name = mysql_query($query_Name, $projectsite) or die(mysql_error());
$row_Name = mysql_fetch_assoc($Name);
$totalRows_Name = mysql_num_rows($Name);

did you open a db connection with mysql_select_db and mysql_connect previously? — Sebas
– Sebas, Commented May 30, 2012 at 12:35

heximal · Accepted Answer · 2012-05-30 12:37:51Z

1

after connecting to mysql server base you should explicitly select database using mysql_select_db function

edited May 30, 2012 at 12:37

answered May 30, 2012 at 12:32

heximal

10.5k5 gold badges49 silver badges73 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Nathan Link Abiola Over a year ago

Sorry i rushed to enter. I meant i cant get the values as when i submit i get the No database selected error.

Leri Over a year ago

@NathanLinkAbiola mysql_select_db('db_name') must be missing in connection.

Nathan Link Abiola Over a year ago

Thanks lads, seemed i had the mysql_select_db in the wrong location

khaled_webdev · Accepted Answer · 2012-05-30 12:38:53Z

1

mysql_select_db($bd);

we need to see how do you connect

answered May 30, 2012 at 12:38

khaled_webdev

1,43015 silver badges20 bronze badges

2 Comments

Nathan Link Abiola Over a year ago

mysql_select_db($database_projectsite, $projectsite);

khaled_webdev Over a year ago

and how do you set the $projectsite

Collectives™ on Stack Overflow

php join query for multiple tables

2 Answers 2

3 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related