Select Mutiple Columns as one – Union


$sql="SELECT item1 FROM user_uploads WHERE item1 LIKE '%$my_data%'
UNION
SELECT item2 FROM user_uploads WHERE item2 LIKE '%$my_data%'";
//they are all item1 now
$result = mysqli_query($mysqli,$sql) or die(mysqli_error());
if($result)
{
while($row=mysqli_fetch_array($result))
{
echo $row['item1']."\n";
// echo $row['item2']."\n";
}
}