Mysql query in an Array

[dreamwest]

How can i get a mysql query into an array? I cooked up this but it doesnt work

 

$result  = mysql_query ("SELECT * from mains where scan=0 order by main_id asc limit 10  ") or die("Fail");

while($row = mysql_fetch_assoc( $result )){
$links .= "http://".$row['main']."' ,'";
}
$links = substr($links, 0, -4);
$links = "'{$links}'";

echo $links;

$nodes = array($links);

 

 

[trq]

A query is a string, nothing more. Do you mean you want mysql results in an array?

 

while($row = mysql_fetch_assoc( $result )){
  $links[] = "http://".$row['main'];
}

 

Links is now aan array containing your results.

[PravinS]

Use below given function, it will give you 2 dimension array

 

function select_row($sql)
{
$rs = mysql_query($sql);
if (!$rs)	
	return false;
else
{
	while($row = mysql_fetch_array($rs,MYSQL_ASSOC))
	{
		$res[] = $row;
	}
	return $res;
}
}

[dreamwest]

Yes. Something like this.

 

$result  = mysql_query ("SELECT * from mains where scan=0 order by main_id asc limit 10 ") or die(mysql_error());

$row = mysql_fetch_array( $result );

$nodes = array($row[1]);

 

But for all the results and not just one

[dreamwest]

Use below given function, it will give you 2 dimension array

 

function select_row($sql)
{
$rs = mysql_query($sql);
if (!$rs)	
	return false;
else
{
	while($row = mysql_fetch_array($rs,MYSQL_ASSOC))
	{
		$res[] = $row;
	}
	return $res;
}
}

 

I tried it but it didnt work, heres what i did:

 

function select_row($sql)
{
   $rs = mysql_query($sql);
   if (!$rs)   
      return false;
   else
   {
      while($row = mysql_fetch_array($rs,MYSQL_ASSOC))
      {
         $res[] = $row;
      }
      return $res;
   }
}

select_row("SELECT * from mains  order by main_id asc limit 10 ");


$nodes = array($res);

[PravinS]

Use like this

$res = select_row("SELECT * from mains  order by main_id asc limit 10 ");

echo "<pre>";
print_r($res);
echo "</pre>";

[dreamwest]

Use like this

$res = select_row("SELECT * from mains  order by main_id asc limit 10 ");

echo "<pre>";
print_r($res);
echo "</pre>";

 

Yes that printed it out onto the screen, but how can i now use it as an array

 

$res = select_row("SELECT * from mains  order by main_id asc limit 10 ");
$nodes = array($res);

$node_count = count($nodes);

[PFMaBiSmAd]

Function calls that return something must either assign what is returned to a variable or use the function call directly in another function as a parameter.

[PravinS]

Use for loop like this, replace fieldnam1, fieldname2 .... with your table fieldnames

 

for($i=0;$i<count($res);$i++)
{
	echo $res[$i]['fielname1']."   ".$res[$i]['fielname1'];
}

[trq]

Why do you insist on passing what is already an array ($res) to the array function? eg;

 

$nodes = array($res);

 

This simply makes your one dimensional array into a two dimensional array.

[PravinS]

I have not insisted to use array($res) in the code.

[trq]

I have not insisted to use array($res) in the code.

 

Obviously I wasn't talking to you.

[PravinS]

Oh I am really sorry

[dreamwest]

Use for loop like this, replace fieldnam1, fieldname2 .... with your table fieldnames

 

for($i=0;$i<count($res);$i++)
{
	echo $res[$i]['fielname1']."   ".$res[$i]['fielname1'];
}

 

Yes. Thats worked, i was missing the ['fielname1'] field name from $res[$i]

 

Thanks!