My service provider is telling me that I am using an undefined call. Isn't this the generic call to retreive data?

I am just learning PHP and am using Dreamweaver MX to generate my code.

Is there something they haven't enabled in mySQL or permissions for my domain.

Dreamweaver and Phpmyadmin see the databse and can create table just fine. (I am getting an undefined error when trying to bring recordsets up in Dreamweaver though).

Please help. I need to be able to explain to them the problem. If it's not my fault.

Ron R.

P.S. Another domain they host for me works just fine. Both the fetch call and recordsets in Dreamweaver come up fine.

    Check your SQL syntax. Undefined call doesn't mean mysql_fetch() isn't there - this is a confusing error. It means that you have an error in your SQL statement.

      Undefined call means exactly that -- you are calling a function that is not defined. Incorrect SQL will produce a completely different sort of error -- a null result set.

      If you will look in the manual, you will see quite a few mysql-related functions ... but there is no mysql_fetch().

      Rewrite the code using one of the documented functions, such as

      mysql_fetch_array()
      mysql_fetch_object()

        Sorry my post doesn't explain. I am using mysql_fetch_array() .

        This "call" works on one of my hosted MySQL domains but not my other.

        So my question is related to administration setup of the database and libraries.

        What did they forget to do to my one domain that won't run the code properly?

        I can actually access both databases from the working domain and make this "call" without a hitch.

        So it has something to do with permissions for the broken domain.

        Thanks

        Ron R

          Write a Reply...