Jazajay
Active Member
Right peeps,
This keeps failing and I'm not sure why.
$query="SELECT id FROM jos_users WHERE username='".$username."'";
$database->setQuery($query);
$rows=$database->loadObjectList();
$row2=$rows[0];
$id=$row2->id;
$query2="SELECT city, country, vm_newsletter FROM jos_vm_user_info WHERE user_id='".$id."'";
$database->setQuery($query2);
$rows=$database->loadObjectList();
$row2=$rows[0]; // failing here
$city=$row2->city;
$country=$row2->country;
$news=$row2->vm_newsletter;
if($news==1){
$sendNews="Yes";
}else{
$sendNews="No";
}
$news=$vm_newsletter;
The output I get is in green below:
Username - james
City -
Country -
Newsletter -
ID - 174
Rows - Array
Rows 0 -
Row2 -
Really confused as to why that fails??????
Any help????
This keeps failing and I'm not sure why.
$query="SELECT id FROM jos_users WHERE username='".$username."'";
$database->setQuery($query);
$rows=$database->loadObjectList();
$row2=$rows[0];
$id=$row2->id;
$query2="SELECT city, country, vm_newsletter FROM jos_vm_user_info WHERE user_id='".$id."'";
$database->setQuery($query2);
$rows=$database->loadObjectList();
$row2=$rows[0]; // failing here
$city=$row2->city;
$country=$row2->country;
$news=$row2->vm_newsletter;
if($news==1){
$sendNews="Yes";
}else{
$sendNews="No";
}
$news=$vm_newsletter;
The output I get is in green below:
Username - james
City -
Country -
Newsletter -
ID - 174
Rows - Array
Rows 0 -
Row2 -
Really confused as to why that fails??????
Any help????