I'm having an issue that I used to not have a problem with. Here's the issue:
I'm parsing a URL and returning an xml array. I'm trying to plugin a piece of this code from a SQL array.. for instance:
$field5=$vbulletin->options['fieldname_name'];
$field9=$vbulletin->options['fieldname_alt'];
$signups = $db->query_read("
SELECT u.username, ea.userid, ea.response, ea.comment, ea.signup_date,
userfield.$field5, userfield.$field9
FROM ".TABLE_PREFIX."wowraid ea
INNER JOIN ".TABLE_PREFIX."user u ON u.userid = ea.userid
LEFT JOIN " . TABLE_PREFIX . "userfield AS userfield ON userfield.userid = u.userid
WHERE eventid = 0".$eventinfo['eventid']."
AND ocdate = '".$signupdate."'
ORDER BY
ea.response, ".$orderby."
");
the array is:
while ($signup = $db->fetch_array($signups)) {
error_reporting(0);
require_once('./global.php');
$name= "TRANS";
$connection['name'] = $signup[$field5];
etc....
The problem is that $connection['name'] = $signup[$field5] returns the following error:
Fatal error: Cannot use string offset as an array
Anything I'm doing wrong here? Or, should be doing differently?
