🚀 go-pugleaf

I added a db connect and query at the top of the script to pull out the IDs and email address from the db. Keep getting a parsing error.

Here is the script I added to the top of the page inside the php open tag.

require_once("../config/include/db_fns.php")

$conn = db_connect();
if (!$conn)
return 'Could not connect to database server - please try later.';

mysql_select_db('tqeg');
$query = "select personnel_ID, personnel_email from personnell";
$result = mysql_query ($query);
$num_results = mysql_num_rows($result);

I then placed this inside the recipient line

for ($i=0; $i <$num_results; $i++) {

$row = mysql_fetch_array($result);
$thisID =
$recipients[htmlspecialchars(stripslashes($row['personnel_ID']))] = stripslashes($row['personnel_email']);
}
can someone look at this and tell me if its wrong? Would this even work in the ProcessForm script at all?

Here is the db_fns.php file from the require

< ?php function db_connect() { $db = mysql_pconnect('localhost', 'username', 'password'); if (!$db) return false; } ? >

I get a parse error on line 5 in the process form script.

This is the line 5
$conn = db_connect();

I got rid of the this code block which is:

$conn = db_connect();
if (!$conn)
return 'Could not connect to database server - please try later.';

and I still get a parse error.

Whooo hoooo I got it to work.