without using while can we get array of a field

[qadeer_ahmad]

Hi,

for more explaining my question i give a example i run a query like this

$sql=mysql_query("select taskid,jobno,name from task");

while($row=mysql_fetch_array($sql))
{
    print($row['taskid']);
}

///////////  OR we can make array like  /////////////
$taskid="";
while($row=mysql_fetch_array($sql))
{
    $taskid.=$row['taskid'].",";
}


///////////  but i need here like this /////////////////
$sql=mysql_fetch_array(mysql_query("select taskid,jobno,name from task"));
/////////// can i get here array of taskid drictly?????/////////////////////

[Weedpacket]

Do you mean you want an array containing all of the task_id's? Nothing springs to mind without using a loop of some sort - so why don't you want to use a loop?

[imi_99]

qadeer_ahmad wrote:

Hi,

for more explaining my question i give a example i run a query like this

$sql=mysql_query("select taskid,jobno,name from task");

while($row=mysql_fetch_array($sql))
{
    print($row['taskid']);
}

///////////  OR we can make array like  /////////////
$taskid="";
while($row=mysql_fetch_array($sql))
{
    $taskid.=$row['taskid'].",";
}


///////////  but i need here like this /////////////////
$sql=mysql_fetch_array(mysql_query("select taskid,jobno,name from task"));
/////////// can i get here array of taskid drictly?????/////////////////////

not sure but try look for each function should work,
u can find fucntion here
http://uk.php.net/manual/en/control-structures.foreach.php