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



news@xxxxxxxxxxxxxx wrote:
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.


What function is undefined?

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).


Shouldn't be any PHP problem. If you suspect a MySQL problem try comp.databases.mysql.

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


Did you ask them?

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


Sorry, my crystal ball is in the shop and you didn't give enough information to even know where to start!

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


Did you try phpinfo()?

cheers,

David



--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@xxxxxxxxxxxxx
==================
.



Relevant Pages

  • Problem with connecting to MySQL from PHP script
    ... I'm writing PHP ... script and wish to connect to MySQL database from PHP script but I can't, ... I tried to use mysql_connectbut result is the same error message. ...
    (alt.php)
  • Re: breaking into J2EE: steep curve or wrong approach?
    ... > a MySQL database. ... > I'd like to recode the PHP functionality as either servlets or JSPs. ... You need to understand servlets. ...
    (comp.lang.java.programmer)
  • Re: Executing PHP files on remote web server
    ... Is it possible to move a few of the PHP pages -- the ... from the session variables on our web server, but I'm a C and Java ... You should have the same security concern for your own MySQL database. ... users with IP addresses on our network, ...
    (comp.lang.php)
  • Mysql Search
    ... I am not sure if this is a PHP or MySql problem, ... I have a MySql database which has a field containing a list of words (comma ... The user inputs a search word to an HTML form which then ...
    (alt.php)
  • phpmailer - need help for bulk mailing
    ... I am new to php and mysql. ... I have set up the mailing list in mysql database and used phpmailer to ... The program code is similar to ... Due to the limit of the php program or SMTP server, the browser ...
    (comp.lang.php)