"call to undefined function" mysql_error when adding new rows to table



Hi all, hope you can help me.

I have recently set up a mysql database of local pubs, with a web form
to add new listings (using PHP to generate an INSERT query).

I've just been doing a bit of data entry, adding a bunch of new pubs,
and all was going swimmingly. But suddenly it has stopped working - now
when I try to add a new pub I get an error message "call to undefined
function". I have not altered the script in any way since the last
successful addition was made.

I ran a SELECT * query on the pubs table to proofread the entries, but
couldn't spot any glaring errors. Then I ran a SELECT COUNT(*) on the
table. The result was 100, ie there were rows numbered 0-99.

I'm wondering if there could be a problem with handling three-figure
row numbers. It sounds highly unlikely (I've checked the documentation
so I know the table [MyISAM] is supposed to be able to handle many more
rows than that).

Maybe it's a restriction imposed by my webhost? (Supanames.co.uk) This
also sounds unlikely.

But in any case, I'm completely baffled. Can anyone suggest any
possibilities?

(Btw, I don't know which version of PHP Supanames has installed.)

cheers,

David

.



Relevant Pages

  • "call to undefined function" mysql_error when adding new rows to table
    ... I have recently set up a mysql database of local pubs, ... to add new listings (using PHP to generate an INSERT query). ... when I try to add a new pub I get an error message "call to undefined ... I don't know which version of PHP Supanames has installed.) ...
    (alt.php)
  • Re: Mysterious problem with INSERT query
    ... Query generated by phpMyAdmin and pasted into my PHP doesn't work ... BLANK (error message would be here) ...
    (comp.lang.php)
  • Re: on input form showing error message for duplicate entry.
    ... If you are not listing even one field in the VALUES portion of the query, you will get a query error. ... adds a product and the id is already in the database, ... Ideally I would like to display an error message, ...
    (alt.php)
  • Re: Error editing story in MS word
    ... John Kramer wrote: ... > edit story in ms word. ... These are simular pubs and I ... PUB2000: Error Message: A Word ...
    (microsoft.public.publisher)
  • Re: Publicans
    ... I have a query on one dating back to ca 1845. ... inn sign and the name of the person standing surety. ... known pubs and licencees back as far as they can. ...
    (soc.genealogy.britain)