open two tables at once??
Posted: Tue May 18, 2004 12:56 pm
how can you pull info out of two tables at the same time??
A community of PHP developers offering assistance, advice, discussion, and friendship.
http://forums.devnetwork.net/
Code: Select all
<?
$db_name = "database";
$table_name = "members";
$db_name = "database";
$table2_name = "adverts";
$connection = @mysql_connect("localhost", "user", "password")
or die("Couldn't connect.");
$db = @mysql_select_db($db_name, $connection)
or die("Couldn't select database.");
$sql = "SELECT mem_userid, mem_username, mem_email, adv_picture, adv_username
FROM $table_name, table2_name
WHERE mem_userid > '30001'
ORDER BY mem_userid
";
$result = @mysql_query($sql,$connection)
or die("Couldn't execute query.");Code: Select all
SELECT
os,
hair_colour
FROM
computer_info,
personal_info
WHERE
computer_info.username = 'joe_user' AND
personal_info.username = 'joe_user'Code: Select all
$sql = "SELECT mem_userid, mem_username, mem_email, mem_joindate, mem_sex, mem_country, adv_username, adv_picture
FROM $table_name,
FROM $table2_name
WHERE table_name.mem_userid > '30001' AND
WHERE table2_name.adv_username = 'mem_username'
ORDER BY mem_userid
";Code: Select all
<?php
$sql = "SELECT mem_userid, mem_username, mem_email, mem_joindate, mem_sex, mem_country, adv_username, adv_picture
FROM $table_name,
$table2_name
WHERE table_name.mem_userid > '30001' AND
table2_name.adv_username = 'mem_username'
ORDER BY mem_userid ";
?>Code: Select all
<?php
$sql = "SELECT t1.mem_userid, t1.mem_username, t1.mem_email, t1.mem_joindate, t1.mem_sex, t1.mem_country, t2.adv_username, t2.adv_picture
FROM $table_name t1,
$table2_name t2
WHERE t1.mem_userid > '30001' AND
t2.adv_username = t1.mem_username
ORDER BY t1.mem_userid ";
?>