php/sql error

[pcw]

Hi, just translating some perl script to php, and got stuck again.

 

This section of script is a function. The database is connected to elsewhere, but I am stuck on this bit:

 

_{function get_users()}

_{

_{$login = $input{'login'};}

_{$favorites = array("");}

_{$query = "SELECT user FROM users WHERE login='$login'";}

_{$sth = $dbh->prepare($query);}

_{$sth->execute();}

 

_{while(@data = $sth->fetchrow_array()) {}

_{push(@favorites, $data[0]);}

_}

_}

 

Any help is very much appreciated 

[rhodesa]

add this as the first line of the function:

global $dbh;

 

edit: actually...you need to change a couple things. try this:

function get_users()
{
   $global $dbh,$input;
   $login = $input['login'];
   $favorites = array();
   $query = "SELECT user FROM users WHERE login='$login'";
   $sth = $dbh->prepare($query);
   $sth->execute();

   while($data = $sth->fetchrow_array()) {
      $favorites[] = $data;
   }
}

[btherl]

That looks good, but the line in the loop might be

 

$favorites[] = $data[0];