getting 2 item instead of 1 mysql database
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)){
//data here.
}
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 ?
No comments:
Post a Comment