Code: Select all
$sql="
SELECT mytable.capacity AS 'capacity', yourtable.name AS 'name'
FROM mytable, yourtable
WHERE mytable.id=$myId AND yourtable.id=$yourId";
$result=mysql_query($sql, $conn);Moderator: General Moderators
Code: Select all
$sql="
SELECT mytable.capacity AS 'capacity', yourtable.name AS 'name'
FROM mytable, yourtable
WHERE mytable.id=$myId AND yourtable.id=$yourId";
$result=mysql_query($sql, $conn);Code: Select all
$sql="
SELECT mytable.capacity AS 'capacity', yourtable.name AS 'name'
FROM mytable, yourtable
WHERE mytable.id=$myId AND yourtable.id=$yourId";
while ( $a_row = mysql_fetch_object( $sql ) )
{
print $a_row->capacity." - ".$a_row->name;
}