[g.sobhani]

Hi i'm new to php. I've 3 MySQL table and each have same column. i want to display selected data from 3 tables.every table have 50 column. i want to display only selected column.

Have anyone any Idea about it?

[MrWheezy]

Try to read this, it helped me alot understanding MySQL:

SQL Tutorial - First Program in PHP and MySQL

PHP Code:

$command="SELECT * FROM houses WHERE apartment = 2";

$result = mysql_query($command, $connection); 

[g.sobhani]

Originally Posted by MrWheezy

Try to read this, it helped me alot understanding MySQL:

SQL Tutorial - First Program in PHP and MySQL

PHP Code:

$command="SELECT * FROM houses WHERE apartment = 2";

$result = mysql_query($command, $connection); 

thanks for your reply but i don't want to select all the columns. I want to SELECT(mysql query) selected column only. user select apartment, name,town then only these field will SELECT in sql query.

[MrWheezy]

Originally Posted by g.sobhani

thanks for your reply but i don't want to select all the columns. I want to SELECT(mysql query) selected column only. user select apartment, name,town then only these field will SELECT in sql query.

ok:

PHP Code:

$command="SELECT * FROM houses";

$result = mysql_query($command, $connection); 

PHP Code:

// Loop through the results

while($row = mysql_fetch_array( $result )) {

echo "<p>;

echo $row['town'];

echo "</p>

} 

[job0107]

If you only want the three columns, then put them in your query.

PHP Code:

$command="SELECT apartment,name,town FROM houses WHERE apartment = 2";
$results = mysql_query($command);
while($row = mysql_fetch_assoc($results))
{
 echo $row["apartment"]." ".$row["name"]." ".$row["town"]."<br />";
 } 

But if you want the whole record and then display the three columns only, then do something like this:

PHP Code:

$command="SELECT * FROM houses WHERE apartment = 2";
$results = mysql_query($command);
while($row = mysql_fetch_assoc($results))
{
 echo $row["apartment"]." ".$row["name"]." ".$row["town"]."<br />";
 }