join query not fetching any data
AL-zami
i am trying to write my first join query which will help me to join two different tables,one is for students and other is for subjects.This is my first join query and it seems it is not working,can anyone point out the mistakes.Php didn't show any error or worning
try{
$pdo=new PDO("mysql:host=localhost;dbname=mydb",'root','');
$sql="SELECT * FROM students LEFT JOIN subjects WHERE students.courseid=subjects.courseid";
$conn=$pdo->prepare($sql);
if($conn->execute()){
$results=$conn->fetchAll();
print_r($results);
}
}catch(PDOException $e){
echo $e->getMessage();
}
davejal
Assuming you table name for students is students and you subjects table is subject then I think it should be:
SELECT * FROM students LEFT JOIN subjects on students.courseid=subjects.subjectid
because you have a subjectid in your subjects table and not courseid
Collected from the Internet
Please contact [email protected] to delete if infringement.
edited at
- Prev: Decrementing a value and wrapping back to a max value without using if statement?
- Next: Android: get current device location without asking permission at run time
Related
Related Related
- 1
PHP / MySQL - Query not fetching any data
- 2
OpenJPA join query does not return any data
- 3
Put data in WHERE clause condition without fetching it | And remove duplication in Left Join query
- 4
Grouping the data after fetching the query
- 5
Nested query not fetching data correctly
- 6
Fetching wrong data in query in rails
- 7
sql query error data not fetching data proprerly
- 8
Fetching data only for specified mapping in HQL query
- 9
SQL query for fetching data from multiple tables
- 10
Fetching form data through query string in flask
- 11
Mysql query is not fetching data as i want
- 12
Error in database class in data fetching query
- 13
Fetching data issue using simple like query
- 14
Fetching data only for specified mapping in HQL query
- 15
Fetching data from MySQL, problems with diferent query
- 16
element-attribute-range-query fetching result but element-attribute-value-query is not fetching any result
- 17
Getting unspecified data while fetching data using mongoose find query
- 18
How to calculate Fetching Time while fetching data from any Api in Ajax
- 19
native query join in spring data
- 20
Join multiple rows of data to query
- 21
create mysql query for fetching data in 3 days slotwise
- 22
Parse background job query iterations are returning before fetching data
- 23
Select query is not working while fetching data from database
- 24
Fetching Data from XML along with the Conditions in a single Query
- 25
Fetching data from SharePoint List ithout using CAML query
- 26
if Query doesnt not return any data
- 27
Fetching other rows of table when performing inner join over multiple fields (oracle query)
- 28
Mysqli query fetching no records
- 29
Query in MongoDb for fetching record
Comments