No output is being displayed. But for some other query the code runs and not for this query. Also, this query runs fine on terminal. Please guide!!
<?php
$con=mysql_connect('servername','uname','passwd');
mysql_select_db('dbname');
$sql="select jobid from jobs where userid='xyz'";
$result=mysql_query($sql);
while($col=mysql_fetch_assoc($result)){
echo 'jobid:' . $col['jobid'] . '</br>';
}
?>