kingbureed
New Member
I want to check if some column of specify user is holding a value higher than 0.ProblemWhen doing the query, and then executing it, Im getting this error:\[code\]Fatal error: Cannot use object of type PDOStatement as array in C:\xampp\htdocs\recover\admin\create.php on line 40\[/code\]My code (The query + execute):\[code\]if (isset($_SESSION['user'])) { $admin = $CONNECT_TO_DATABASE->prepare("SELECT * FROM admin WHERE username = :username"); $admin->bindValue(':username', $_SESSION['user']); $admin->execute();\[/code\]Line of error (40):\[code\]if ($settings['create_admins'] > 0 || $admin['super_admin'] > 0 ) {\[/code\]Question:Why am I getting this error? How do I fix it?I tried doing this:\[code\]$admin = $CONNECT_TO_DATABASE->prepare("SELECT * FROM admin WHERE username = :username");$admin = $admin->bindValue(':username', $_SESSION['user']);$admin = $admin->execute();\[/code\]and getting another error:\[code\]Fatal error: Call to a member function execute() on a non-object in C:\xampp\htdocs\recover\admin\create.php on line 38\[/code\]Thanks!EDIT: I need the ->fetch object, but I have just done this, and got rid of the errors.. But it doesn't affect? I mean I am echoing that row, and it gives me a null (nothing). Why?\[code\]$admin = $CONNECT_TO_DATABASE->prepare("SELECT * FROM admin WHERE username = ".$_SESSION['user']."");$admin = $admin->fetch();\[/code\]