pcw Posted February 20, 2009 Share Posted February 20, 2009 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 Quote Link to comment Share on other sites More sharing options...
rhodesa Posted February 20, 2009 Share Posted February 20, 2009 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; } } Quote Link to comment Share on other sites More sharing options...
btherl Posted February 20, 2009 Share Posted February 20, 2009 That looks good, but the line in the loop might be $favorites[] = $data[0]; Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.