php echo help..

[techker]

Hey guys i have a big problem..lol

 

i know how to do the query's but it's the show results that i have issue's with..i always get confused..

 

 

like i dd this in php my admin

 

SELECT *
FROM Motif a
INNER JOIN Expulsion b
USING(Motif)

 

now it works in my admin ..but now im confused on how to show the results..

 

any tips on this?

[requinix]

Eh?

 

Here's a good place to start.

[techker]

for the query its good.but when it comes to show the results of the query the echo confuses me..

[requinix]

What tutorial are you following?

[techker]

none.thats what im asking..just for the part of the echo results..

[requinix]

Then what's your code?

[techker]

this works now.

 

$query = "SELECT N_Etudiant, Professeur
FROM Expulsion
GROUP BY N_Etudiant, Professeur
HAVING COUNT( * ) >=2
LIMIT 0 , 30";