"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

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

news@smutchin.co.uk wrote:What function is undefined?
Shouldn't be any PHP problem. If you suspect a MySQL problem try
comp.databases.mysql.
Did you ask them?
Sorry, my crystal ball is in the shop and you didn't give enough
information to even know where to start!
Did you try phpinfo()?

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

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

Jerry Stuckle wrote:"mysqlerror()" [sic]

I hadn't noticed the typo before because the mysql_query it related to
hadn't previously returned a 'false' value... And it turns out the
reason for the 'false' value was because the primary field in the table
was a TINYINT and it was trying to enter a value higher than 127...
doh!

Apologies for wasting your time/bandwidth.
No, didn't occur to me. Thanks for reminding me of that option!

David

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

davek wrote:No problem - been there, done that, got the T-Shirt (multiple, in fact
:-) ).
Always a good thing to remember!


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