need help with php5 and mysql 4.0.20

mortal

ok.. please help me

I bought this book to help me build a cms for my web site. its ment for php5 and mysql 5. turns out that the web provider i use only has mysql 4.0.20.

and i have this code that is suposed to connect me to my database but it gives me an error saying: "Fatal error: Class 'mysqli' not found in /db_fns.php5 on line 5"

the code on line 5 and beyond is: "function db_connect()
{
$handle = new mysqli(localhost, 'username, 'password', 'db_name');
if (!$handle)
{
return false;
}
return $handle;
}"

obviously i changed the login info for this post for security reasons. but does anyone have any clue why this wont work? i am a newbee and would appreciate how i can make this work

thank you in advance

devinemke

it sounds like your host does not have the [man]mySQLi[/man] extension enabled. try using the regular [man]mySQL[/man] functions.

mortal

thank you. i am connected to the database ... but now i have a new error ...

its says: "Fatal error: Call to a member function query() on a non-object in /index.php5 on line 8"

line 7:"$pages_sql = 'select * from pages order by code';"
line 8:"$pages_result = $handle->query($pages_sql);"

any clue why its an error?

again ... thanks in advance

devinemke

your code is refering to a function called query() but you have not instantiated the object $handle.

i get the feeling that you are just starting out, and the script you are following uses OOP (Object Oriented Programming) concepts that are not a good starting point for learning PHP. you should really start with the basics.