Another Query Issue

gobbles

Hey All,

Its me again ... Im having problems understanding an issue of mine.

I want to select only the active, id, and venue name from the tbl1 table and the signup date, expiry date, and phone from tbl2 and want only the ones that have tbl1.active set to 1.

But then i want to display each one of the results in a while loop.

Can someone help me with this ... im having so much trouble getting my head around it.

Thanks Muchly

NogDog

What are the columns in tbl1 and tbl2 that establish the relationship between them?

gobbles

Ohhh sorry ... tbl1.id and tbl2.id

gobbles

Anyone?

alimadzi

gobbles wrote:
I want to select only the active, id, and venue name from the tbl1 table and the signup date, expiry date, and phone from tbl2 and want only the ones that have tbl1.active set to 1.

But then i want to display each one of the results in a while loop.

This should work...

<?php

$query = "SELECT tbl1.active, tbl1.id, tbl1.venue, tbl2.signup, tbl2.expiry, tbl2.phone
    FROM tbl1, tbl2 WHERE tbl1.active = 1 and tbl1.id = tbl2.id";
$result = mysql_query( $query );
while ( $row = mysql_fetch_assoc( $result ) ) {
    // do stuff with each row like this...
    echo "<p>$row[id] is $row[venue] and the number is $row[phone].</p>";
}
mysql_free_result( $result );

?>