MySQL

Regarding Mysql Query

Please support our MySQL advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Feb 2008

Posts: 1

Reputation: giteshchawla is an unknown quantity at this point

Solved Threads: 0

giteshchawla giteshchawla is offline

Offline

Newbie Poster

Regarding Mysql Query

Feb 19th, 2008

hi all,

i have two tables, table1(id, name, address) and table2(id, phone, email, status). now i want to fetch data from both tables and display in a table. what i want is data must be fetched from table1 and table2 when the status in table2 is 1. if status in table2 is 0 then it do not fetch data from table2 but shows data of table1. can anybody tell me how can i fetch data in this case.

help me please.

Gitesh Chawla

•

Join Date: May 2005

Posts: 514

Reputation: techniner is an unknown quantity at this point

Solved Threads: 19

techniner

Offline

Posting Pro

Re: Regarding Mysql Query

Feb 19th, 2008

You probably want to use PHP for this.

 Help with Code Tags 
 MySQL Syntax (Toggle Plain Text) 
 
$q="select * from table2";
$r=mysql_query($q);
while ($row = mysql_fetch_array($r)){
           $status=$row['status'];
           $id=$row['id'];
           $phone=$row['phone'];
           $email=$row['email'];
 
 
            $q2="select * from table1 where id ='$id'";
            $r2=mysql_query($q2);
            while ($row2 = mysql_fetch_array($r2)){
            $id=$row2['id]';
            $name=$row['name'];
            $address=$row2['address'];
            if ($status == 1){
            echo "$name - $address - $phone - $email";
            } elseif($status == 0){
            echo "$name - $address";
            }
}
$q="select * from table2";
$r=mysql_query($q);
while ($row = mysql_fetch_array($r)){
           $status=$row['status'];
           $id=$row['id'];
           $phone=$row['phone'];
           $email=$row['email'];
           
      
            $q2="select * from table1 where id ='$id'";
            $r2=mysql_query($q2);
            while ($row2 = mysql_fetch_array($r2)){
            $id=$row2['id]';
            $name=$row['name'];
            $address=$row2['address'];
            if ($status == 1){
            echo "$name - $address - $phone - $email";
            } elseif($status == 0){
            echo "$name - $address";
            }
}

I think your logic is flawed. We must look in table2 to find out if status = 1 or not.

In your original request you said you did not want to fetch the data. I think you meant that you did not want to "display" the data.

Anyhow the above code should do what you want.

Did my post help?

Visit Little Jon's Web Portal
Utilize Jon Coiro's Tech Support Remote Services
Need to Increase Your Traffic?