showing results of query with right join

[cihpet]

Hallo,
I am beginner,
I want to show on page results of this query: $query="SELECT mr_prehlad.mr_id, mr_kontakt.nazov_mr FROM mr_prehlad RIGHT JOIN mr_kontakt ON mr_kontakt.id_mr=mr_prehlad.mr_id WHERE mr_prehlad.'$co'='1' ORDER BY mr_prehlad.mr_id ";

But this while ( $row = MySQL_Fetch_Field( $result ) ) {
echo "<tr>\n";
foreach( $row as $hodnota ) {
echo "<td>\n";
echo $hodnota;
echo "</td>\n";
}
echo "</tr>\n";
}

is not function.

How to show with php in html pages query with left or right join?

Thanks for answer.

[tolkienarda]

Hallo,
I am beginner,
I want to show on page results of this query: $query="SELECT mr_prehlad.mr_id, mr_kontakt.nazov_mr FROM mr_prehlad RIGHT JOIN mr_kontakt ON mr_kontakt.id_mr=mr_prehlad.mr_id WHERE mr_prehlad.'$co'='1' ORDER BY mr_prehlad.mr_id ";

But this while ( $row = MySQL_Fetch_Field( $result ) ) {
echo "<tr>\n";
foreach( $row as $hodnota ) {
echo "<td>\n";
echo $hodnota;
echo "</td>\n";
}
echo "</tr>\n";
}

is not function.

How to show with php in html pages query with left or right join?

Thanks for answer.

ok first off you never define $result
second i am not sure if the \n shoud be inside your " i think they should be outside or just to be safe replace them with a <br /> tag.

eric

[cihpet]

ok first off you never define $result
second i am not sure if the \n shoud be inside your " i think they should be outside or just to be safe replace them with a <br /> tag.

eric

Of course I have implemented
$result=mysql_query($query);
but I get this answer from mySQL
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in
Warning: mysql_fetch_field(): supplied argument is not a valid MySQL result resource in

So it is nothing with <br /> tag.

[tolkienarda]

if you could post your entire script it would help me follow it and if it wouldn't be a security problem a link to the page where this is active always helps

eric

[ronverdonk]

Take the single quotes out of the statement's WHERE clause

mr_prehlad.'$co'

Ronald :cool: