Unknown column 'admin' in 'where clause'

[lucas20042004]

Hi, can anyone help me fix this as im quite inexpierenced.

 

Getting error on a contact form.

 

MSQL returned error:

 

Unknown column 'admin' in 'where clause'

 

Query:

 

SELECT * FROM sf_users WHERE admin ='1'

 

Code:

 

<?php
require("./global.php");

if(isset($_POST['submit']) && !empty($_POST['c_mail']) && !empty($_POST['c_subject']) && !empty($_POST['c_text']) ){
    $result = $db->query("SELECT * FROM ".$pfx."_users WHERE admin ='1'");
    while($admins = $db->fetch($result)){
                $header = "From: $globalsettings[sendermail]";
                mail($admins['mail'], "Contact Mail: $_POST[c_subject]",
"This is a Mail from the Contact Form.
Reply to: $_POST[c_mail]
IP Adress of the User: $_SERVER[REMOTE_ADDR]
                
Message:
$_POST[c_text]", $header);
    }
    eval ("dooutput(\"".gettemplate($tplfolder . "header")."\");");
    eval ("dooutput(\"".gettemplate($tplfolder . "contact_success")."\");");
    eval ("dooutput(\"".gettemplate($tplfolder . "footer")."\");");
    exit();
}

eval ("dooutput(\"".gettemplate($tplfolder . "header")."\");");
eval ("dooutput(\"".gettemplate($tplfolder . "contact")."\");");
eval ("dooutput(\"".gettemplate($tplfolder . "footer")."\");");
$db->close($sqlconn);
?>

[mdnghtblue]

What does your table structure look like? It sounds like the admin column doesn't exist in that table...

[Adam]

does sf_users have the "admin" field in it ?

[discomatt]

This may seem stupidly obvious, but is there a column called admin on the table sf_users?

 

Perhaps try

 

SELECT * FROM `sf_users` WHERE `admin` ='1'