);
If you use "default 0", "0" is an integer. But ENUM only accept strings,
so try to use "default '0'" when you create the table.
Have a nice day,
Thomas Karcher
-
Before posting,
change to settings of my db, but I cannot find
> anything in the manual. (I'm running version 3.23.38 which should be a
> stable one.)
perhaps you have the auto_increment-field set as a "smallint" which can
only store values up to 127? Use med
o configured
> php3.ini with mysql settings but it doesn't work. By the way php3 itself
> works fine.
What is the error message? Is the MySQL server running properly? Are you
able to connect to the server via command line "
Hi,
> I am just curious to know whether you have any GUI for mysql for Windows
> NT/98? If so kindly send me the link where I could download it. I am curios
> to work on MYSQL.
Look at http://www.mysql.com/downloads/index.html - you will find what
you are searching ...
Thoma
ve to check your MySQL access control ... *g*
Read the section "6 The MySQL Access Privilege System" in the MySQL
manual, then you know what to do.
Thomas Karcher
-
Before posting, please check:
http://www.mysql.com/m
Hi,
once again *g*
> > $sql = "insert into sitesats set areview='$areview', apositive='$apositive',
>anegative='$anegative', arate='$arate' where id='$id'";
Does it make sense to "INSERT INTO . WHERE ..." ? *GG*
Thomas
-
Hi,
> SELECT max(fieldname) FROM table;
I think with this you get the CURRENT max value of entries existing in
the table, but not the REALLY maximum value you are able to insert.
> > Does anybody knows how can I check whether the max value in some
> > database's
> > field has
> > been reached?
>
ve', anegative='$anegative', validated='2' where
> id='$id'";
> $query = mysql_query($sql);
> echo(mysql_error());
> if (!$query) {
> echo(mysql_error());
> } else {
> echo("Review stored successfully."
