Getting database values using if loop

[Anon]

Dear All,
I am using the floowing code to get data from database.

for($irow=0;$irow<count($aryInput);$irow++)
{
$aryInputLine=explode("\t\t",$aryInput[$irow]);
$cid=$aryInputLine[0];
$phid=$aryInputLine[1];
$paid=$aryInputLine[2];
$btscall=$aryInputLine[6];
$btecall=$aryInputLine[7];
$lddays=$aryInputLine[8];
if($btscall==null)
{
    $stcall1=mysql_query("select Physician_info_default_start_time_to_call from CTMedia_physician_info
    where Physician_info_physician_id = '$phid'");

while($a_row1 = mysql_fetch_row($stcall1))
{
foreach($a_row1 as $time1)
print "StartTime: $time1";
print "<td>";
}
Because I am using while loop, I am getting multiple values from the database table. So can anybody guide me how to use if loop instead of while to get only one value from database at a time? Please help me in this issue.
Indrajit.

[shastry]

try with this:

$query="urQuery";
$query = stripSlashes($query) ;
$result = mysql_query($query);
if($result !=null)
{
$row_array = mysql_fetch_row ($result);
$urValue=$row_array[0];
}
--Shastry