Echo result of two tables

Question

table course[name,departament,year,id,examinar] for example:

music,music Science,first,1,pr.Elias

table grade[studentname,stlastname,departament,,course,yearOfcourse,grade,examinar] for example:

roland,doda,music Science,music,first,10,pr.Elias

Now i have the below code

$query = "SELECT * FROM course where  year ='first' ";
$result = mysql_query($query);
while ($row = mysql_fetch_array($result) ){
    echo "<tr>
        <td>".$row['name']."</td>
        <td>".$row['departament']."</td>
        <td>".$row['examinar']."</td> 
        </tr>";
}

This works fine but that i want is into <tr> tags of while loop to echo out the grade from table grade?

First redesign your database. That is as _flakey_ as _the Signing Detective_ in its current form — RiggsFolly, Jun 07 '16 at 16:21
Why it does not exist any solution?i cant redesign my DB i have a big project — dorina, Jun 07 '16 at 16:24
thank you but i must doing that without start learning PDO i dont have time — dorina, Jun 07 '16 at 16:33

score 0 · Answer 1 · edited May 23 '17 at 12:22

0

This might do what you want, but I have had so make a few assumptions in the columns required to make a correct join.

I also added some error checking so that if I made an incorrect assumption you will be told about it.

$query = "SELECT c.*,g.grade 
          FROM course c 
              JOIN grade g ON (     g.departament = c.departament
                                AND g.year = c.year
                                AND g.course = c.name                        
                            )
          WHERE c.year ='first' ";

$result = mysql_query($query);
if ( $result === false ) {
    echo mysql_error();
    exit
}

while ($row = mysql_fetch_array($result) ){
    echo "<tr>
        <td>{$row['name']}</td>
        <td>{$row['departament']}</td>
        <td>{$row['examinar']}</td> 
        <td>{$row['grade']}</td> 
        </tr>";
}

Please dont use the mysql_ database extension, it is deprecated (gone for ever in PHP7) Specially if you are just learning PHP, spend your energies learning the PDO database extensions. Start here its really pretty easy

edited May 23 '17 at 12:22

Community

1
1

answered Jun 07 '16 at 16:32

RiggsFolly

93,638
21
103
149

Thank you but i get this error : Unknown column 'g.grade' in 'field list' – dorina Jun 07 '16 at 16:55
Or on "JOIN grade ON" maybe be "JOIN grade g ON" right? – dorina Jun 07 '16 at 17:08
Yup well spotted, my typo sorry FIXED It – RiggsFolly Jun 07 '16 at 17:14
_May i add column grade on table course?_ No it makes no sence in that table. – RiggsFolly Jun 07 '16 at 17:19
Ok i had fixed it thanks but this code return me an empty result! I check that doing if (!$row = mysql_fetch_array($result)){echo "wrong"} – dorina Jun 07 '16 at 17:21
Would be useful to have a [sqlfiddle](http://sqlfiddle.com/) to play with that has a few test columns in both tables – RiggsFolly Jun 07 '16 at 17:24

Echo result of two tables

1 Answers1