得到2个项而不是1个mysql数据库[关闭]

Question

i have problem i am using below script for merge tables and get data from mysql

    $myboxexi=mysql_query('select box.id,box.page_name,box.title,box.connect,box.type,box.uid,box.description,box.image,box.url,box.status,box.date,box.time
    from boxes as box left join page_boxes as pages on box.uid=pages.uid and pages.uid="'.$session_id.'"');
    while($my_boxi=mysql_fetch_array($myboxexi)){
    $title=$my_boxi['title'];
    $bid=$my_boxi['id'];
    $ptitle=$my_boxi['page_name'];
    $connect=$my_boxi['connect'];
    $type=$my_boxi['type'];
    $iuid=$my_boxi['uid'];
    $description=$my_boxi['description'];
    $image=$my_boxi['image'];
    $url=$my_boxi['url'];
    $appr=$my_boxi['status'];
    $date=$my_boxi['date'];
    $time=$my_boxi['time'];
    $myinfo=mysql_query('select * from users where id="'.$iuid.'"');
    $my_boxi_info=mysql_fetch_array($myinfo);
    $user_id=$my_boxi_info['id'];
    $user_name=$my_boxi_info['user_name'];
    $thmb=$my_boxi_info['thumb'];
    if(strpos($thmb,'https://') !== false) {
    $thmbs=$thmb;
    }else
    {
    $thmbs='images/thumbs/'.$thmb;
    }

}

its working fine but problem is i am getting double item like if i have 1 item then i get 2 item how can i solve this issue ?

Answer 1

I think you get 2 values because you have for example,element [0] and same element with key=name of column , so use only associatif result :

Change this :

while($my_boxi=mysql_fetch_array($myboxexi)){
//data here.
}

To this :

while($my_boxi=mysql_fetch_array($myboxexi, MYSQL_ASSOC)){
//data here.
}

Or to this

while($my_boxi=mysql_fetch_assoc($myboxexi)){
//data here.
}