whenever I go onto my page utilzing the sql class i get this error message:

Fatal error: Cannot redeclare class sql in /includes/sql.php on line 8

this is what i have in my sql.php class

PHP Code:

    class sql
    {
        function Connect()
        {
            require("aihsfijnud.php");//renamed for security
            @mysql_connect($host, $username, $password);
            @mysql_select_db($db);
        }
        function Close()
        {
            @mysql_close();
        }
        function Query($sql)
        {
            $this->Connect();
            $query = @mysql_query($sql) or die("sorry no results matched your criteria");
            $row = @mysql_fetch_array($query);
            $this->Close();
            return $row;
        }
        function Login()
        {
            if(!isset($_SESSION['author']))
            {
            $this->Connect();
            $username = md9($_POST['username']);
            $password = md9($_POST['password']);
            $this->Query("select * from profiles where username='$username'");
            if( $row['password'] == $password )
            {
                session_start();
                $_SESSION['author'] = $row['name'];
                header("location:".$_SERVER['HTTP_REFERER']);
            }
            else
            {
                echo("sorry your login details is incorrect");
            }
            $this->Close();
            }
            else
            {
                echo("Your Are Logged In. Logout If You Wish");
            }
        }
        function Logout()
        {
            session_destroy();
            unset($_SESSION['author']);
        }
            
    } 


I'm at my wits end with this one if you want to see the error for yourself its at http://ap-gfx.com/?show=profile

1) Is this a custom class that you've written? Have you tried taking a look at mysqli? It's an class based implementation of PHP's mySQL API. It's actually pretty well done.

2) Are you including this class from more than one place? Have you tried changing to include_once() instead of just include() ?

3) Is sql a reserved name? I'm not sure, but I wouldn't be surprised if this is an invalid name used already by PHP

well i did try renaming the class but the same result came up.

Originally Posted by andyp

well i did try renaming the class but the same result came up.

That means that you are redeclaring the class. Try changing all of your requires and includes to require_once and include_once

Yes, yu must to include the class one time. If you use a sentence like this:

include('sql.class.php');
or
require('sql.class.php');

You must to test this:

include_once('sql.class.php');
or
require_once('sql.class.php');