如何在两个select语句中使用mysql_fetch_assoc，这个语句在OR运算符中给出，以选择表格表格

问题描述：

How to mysql_fetch_assoc array for either of select statement if either one is selected and display them ?

$query1= "SELECT name, email_id,mobile_number from tablename where `user_id='$id'"` 
            OR      
        "SELECT guser_name, guser_email from tablename1 where user_id='$id'";

if($q=mysql_query($query1))
{
    $row = mysql_fetch_assoc($q);
    $name = $row['guser_name'];
    $name1 = $row1['name'];
    $mail1 = $row1['email_id'];
    $mail= $row['guser_email'] ;
    $phone = $row1['mobile_number']

如何mysql_fetch_assoc code>数组中的 select code>语句是否选择了一个并显示它们？ p>

  $ query1 =“SELECT name，email_id，mobile_number from tablename where`user_id ='$ id'”`
 OR 
“ 从表名1中选择guser_name，guser_email，其中user_id ='$ id'“; 
 
if（$ q = mysql_query（$ query1））
 {
 $ row = mysql_fetch_assoc（$ q）; 
 $ name = $ row  ['guser_name']; 
 $ name1 = $ row1 ['name']; 
 $ mail1 = $ row1 ['email_id']; 
 $ mail = $ row ['guser_email']; 
 $ phone =  $ row1 ['mobile_number'] 
  code>  pre> 
  div>

答

You can try something like below. This way, all rows whether coming from table1 or table2 can be accessed using same key in array obtained from mysql_fetch_assoc.

select name1 as name,email1 as email, mobile1 as mobile FROM table1 WHERE id=1
UNION ALL 
select name2 as name,email2 as email, '' as mobile FROM table2 WHERE id=1

Demo http://sqlfiddle.com/#!2/9d81c/1

如何在两个select语句中使用mysql_fetch_assoc，这个语句在OR运算符中给出，以选择表格表格

相关推荐