Member Avatar for giteshchawla

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

  • 2 Contributors
  • 1 Reply
  • 67 Views
  • 12 Hours Discussion Span
  • Latest Post Latest Post by techniner
Member Avatar for techniner

You probably want to use PHP for this.

$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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.