Page 1 of 1

While array result starting from 1

Posted: Wed Mar 02, 2005 10:12 am
by danf_1979
Hi,
I have this function:

Code: Select all

function obtener_vendedor () {
$query = "SELECT nombre FROM ev_vendedores ORDER by idvendedor ASC";
$result = mysql_query($query) or die ("Error in query: $query. ".mysql_error());
		while ($row = mysql_fetch_row($result))
					{
					$get_vendedorї] = $row;
					}
	return $get_vendedor;
}
How can I make the array $get_vendedor start from one? like in $get_vendedor[1] for the first result, and not $get_vendedor[0]
Maybe this is basic, but I couldnt find any help on google.
Thanks.

Posted: Wed Mar 02, 2005 10:17 am
by smpdawg
Arrays are 0 indexed. Why do you need it to start with 1? It doesn't change the behavior of the array...

Posted: Wed Mar 02, 2005 10:19 am
by n00b Saibot

Code: Select all

function obtener_vendedor () { 
$start = 1;
$query = "SELECT nombre FROM ev_vendedores ORDER by idvendedor ASC"; 
$result = mysql_query($query) or die ("Error in query: $query. ".mysql_error()); 
      while ($row = mysql_fetch_row($result)) 
               { 
               $get_vendedorї$start++] = $row; 
               } 
   return $get_vendedor; 
}

Posted: Wed Mar 02, 2005 10:20 am
by PrObLeM

Code: Select all

function obtener_vendedor () {
$query = "SELECT nombre FROM ev_vendedores ORDER by idvendedor ASC";
$result = mysql_query($query) or die ("Error in query: $query. ".mysql_error());
$get_vendedorї0] = 0;
      while ($row = mysql_fetch_row($result))
               {
                  array_push($get_vendedor, $row);
               }
   return $get_vendedor;
}

that will set the 1st element to 0 and then the results will be what ever you select

Posted: Wed Mar 02, 2005 10:21 am
by feyd
:lol: collision of the posts! aaah! :P

Posted: Wed Mar 02, 2005 10:21 am
by danf_1979
Thank you, both...