Mysql to PDO convert

[cobusbo]

Hi I'm trying to change my script from mysql to PDO but im struggling

 

Here is my old Mysql code

$queryadmin = "SELECT mxitid FROM Users2 WHERE rank = 1"; 
	 
$resultadmin = mysql_query($queryadmin) or die(mysql_error());

$admin = array();
while($row = mysql_fetch_array($resultadmin)){
	if ($row['mxitid'] != '')
$admin[] = $row['mxitid'];
	}

And here is my attempt to make it PDO

$mod = "SELECT mxitid FROM Room_users WHERE Rank = 2";
 
    $qmod = $conn->prepare($mod);
    $qmod->execute();
    $qmod->setFetchMode(PDO::FETCH_ASSOC);
    
    $mod = array();
    while ($rmod = $qmod->fetch()) {
       if ($rmod['mxitid'] != '')
$mod[] = $rmod['mxitid'];
    }
      

But it doesnt seem to work

[Barand]

"It doesn't work" tells us sweet FA about the problem. We cannot see your screen.

 

What is happening?

What isn't happening?

[cobusbo]

"It doesn't work" tells us sweet FA about the problem. We cannot see your screen.

 

What is happening?

What isn't happening?

Ah sorry I found my problem I had $mod conflicting with another $mod