PHP function

suzie

Dear
I want to write a function that can return a row or a set of rows from a select query

for example I have the table Banners containning the following Rows:

ACM             Left                 10        5       01/01/2008     31/07/2008

ACM             middle             10        5       01/08/2009     31/08/2009

And the function
$advertiser = 'ACM';

function submit($advertiser)
{

$q = "SELECT Advertiser, location, Clicks, Hits, date_start, date_end FROM

         Banners where Advertiser like '$advertiser'";

if($r=odbc_exec($sqlconnect, $q))
while($row=odbc_fetch_row($r))
{

   $Advertiser = odbc_result($r,"Advertiser");
       $location = odbc_result($r,"location");
       $Clicks = odbc_result($r,"Clicks");
       $Hits= odbc_result($r,"Hits");
   $start = odbc_result($r,"date_start"); 
       $end = odbc_result($r,"date_end");


                }

}

So this Query should return 2 Rows.
How to write this function in order to return the 2 Rows identical to the Advertiser name,

I want a function that returns for me all the data for the specific advertiser name

any Help please????

thanks a lot

Weedpacket

Instead of putting each individual piece of each result into a variable, read a full row into an array (oh, wait, you already have - $row - you just never use it). Then store that array as an element of an array that will contain all the returned rows. Then return it.

suzie

do you mean in this way:

if($rs=odbc_exec($sqlconnect, $q))

while (odbc_fetch_row($rs)) {
for ($y = 1; $y <= odbc_num_fields($rs); $y++)
$arr[$x][$y] = odbc_result($rs,$y);
$x++;
}
return $arr;
}

Weedpacket

More or less; see this page about arrays in the manual.

You may also want to look at [man]odbc_fetch_array[/man] or [man]odbc_fetch_into[/man].

tave

Weedpacket;10925544 wrote:
Instead of putting each individual piece of each result into a variable, read a full row into an array (oh, wait, you already have - $row - you just never use it). Then store that array as an element of an array that will contain all the returned rows. Then return it.

the value of $row is either TRUE or FALSE ....

NogDog

odbc_fetch_array() instead of odbc_fetch_row() would probably do the trick:

$results = array();
while($row = odbc_fetch_array($r))
{
   $results[] = $row;
}

Now $results will be a 2-dimension array with all the query results, the first dimension being the result row, the 2nd dimension being the column name. (E.g., the second result row's 'location' value would be $result[1]['location'].)