array

[poe]

i have this function at querys a db and returns an array.

function getAll($sql) {
	$data = array();
	$result = $this->query($sql);
	while($row = mysql_fetch_assoc($result)) {
		$data[] = $row;
	}
	return $data;
}

 

now, if i know the result is going to be just 1 row...

 

i there a way to alter it so it returns and i can access by $myarray instead of $myarray[0].

 

ie this:

Array (
   [uid] => 2
   [email] => chris@home.com
   [owner] => chris
)

 

instead of:

Array(
   [0] => Array (
      [uid] => 2
      [email] => chris@home.com
      [owner] => chris
   )
)

[wsantos]

Well in the first place you design it to get all the records as implied by the name...Try this

 

$data=mysql_fetch_row($result);

 

[cooldude832]

because you aren't writing a multi deminsonal array, but a flat array you will need to do something like

<?php
function getAll($sql) {

$result = $this->query($sql);
$count = mysql_num_rows($result);
if(mysql_num_rows($result) >0){
	$data = array();
	$i = 0;
	while($row = mysql_fetch_assoc($result)) {
		foreach($row as $key => $value){
			$data[$i][$key] = $value;
		}
		$i++;
	}
}
else{
	$data = 0;
}
return $data;
}
?>

 

Then you will want to make sure $var = getALL($sql); $var >0 if its not then you got no results

[PHP_PhREEEk]

New function:

 

<?php

$sql = "SELECT `email` FROM `tablename` WHERE some_condition";
$email = getOne($sql);

function getOne($sql) {
   if ( !$result = $this->query($sql) ) {
       die("Query failed:" . mysql_error());
   }
   $row = mysql_fetch_row($result);
   return $row[0];
}

?>

 

PhREEEk    

[rajivgonsalves]

try this

 

function getAll($sql) {
	$data = array();
	$result = $this->query($sql);
	$intRow = mysql_num_rows($result);
	while($row = mysql_fetch_assoc($result)) {
		$data[] = $row;
	}
	return ($intRow==1) ? $data[0] : $data;
}

[teng84]

youre using fetch assoc that should give you the result you're looking !

i believe without that function you made it'll return  the desired output you want