Hi I have two table and i need to list all my branches in one dropdown i have created a union which works fine on my localhost but one i upload it on my web server it does not show the details of the other table
I have also created a view a as well which does not work on my we server
here is my view
create view BranchInfo as SELECT from Branch_Information UNION select from Branch_Main;
what mite be the problem because on the localhost it show all my branches
<tr>
<td><b>Branch:</b></td><td><select name='branch'>
<?php
include('conn.php');
$Qxo="SELECT * from Branch_Information UNION select * from Branch_Main";
print "<option>Select Branch</option>";
$cat=mysql_query($Qxo) or die ("cannot select from Branch Information");
while ($list=mysql_fetch_array($cat))
{
print "<option value='$list[Branch_Name]'>$list[Branch_Name]</option>";
}
?>
</select>
</td>
</tr>
mysql> select Branch_Name from Branch_Information;
+------------------+
| Branch_Name |
+------------------+
| Bloemfontein |
| Cape Town |
| Durban |
| East London |
| George |
| Johannesburg |
| Kimberley |
| Nelspruit |
| Pietermaritzburg |
| Polokwane |
| Port Elizabeth |
| Pretoria |
| Rustenburg |
| Vaal |
| Witbank |
mysql> select Branch_Name from Branch_Main;
+---------------+
| Branch_Name |
+---------------+
| JHB Main |
+---------------+
