- $result_pay = SQL_QUERY("SELECT pay_name, pay_rate, pay_min_count, pay_currency FROM "._MYSQL_PREFIX."_sponsor_paytypes ORDER BY pay_name", __FILE__, __LINE__);
- if (SQL_NUMROWS($result_pay) > 0)
- {
+ $result_pay = SQL_QUERY('SELECT pay_name, pay_rate, pay_min_count, pay_currency FROM `{?_MYSQL_PREFIX?}_sponsor_paytypes` ORDER BY pay_name', __FILE__, __LINE__);
+ if (SQL_NUMROWS($result_pay) > 0) {
// Load all pay types
// Load all pay types
- $OUT_PAY = ""; $SW = 2;
- while (list($name, $rate, $min, $curr) = SQL_FETCHROW($result_pay))
- {
+ $OUT_PAY = ''; $SW = 2;
+ while ($content = SQL_FETCHARRAY($result_pay)) {