RE: Select and = MAX()

Hi, You are using an aggregate function (MAX) in a condition which requires you to use the HAVING statement instead of the WHERE statement. Your query should look something like: SELECT price FROM shop HAVING price=MAX(price); Regards, Jorge For technical support contracts, visit

Re: databases disappear...

On Wed, 27 Jun 2001 12:34, Marco Bleeker wrote: For the first time developing a PHP-MySQL system, I am experiencing strange things. Perhaps it is the off-line mode (Localhost) I am running Apache in, or my Wintel 98SE Pentium3. So I create and populate 3 small tables in a database with a

Update or delete a record using PHP and HTML forms

Could someone post some sample code to get me started on loading records into an HTML form using PHP and SQL so that I can update or delete a record. Regards, Steve - Before posting, please check:

Re: Tables exceeding 2gb

Yee Chuan Loh [EMAIL PROTECTED] writes: The document at http://www.mysql.com/doc/T/a/Table_size.html seems to suggest that the reason why there's a limit to the table size is because of the number of bytes used by the file system to store offsets, so its more or less file system dependant

RE: Update or delete a record using PHP and HTML forms

Her you go, this one Reads the Database table, Change the DB parts to yours and have fun. Here is a good start as well http://www.devshed.com/Server_Side/PHP/DB_Basics/ html head /head body ?php // set up some variables // server name $server = localhost; // username $user =

Beginners Query

hi I am new user to mysql I want to create a new database on my machine where mysql is installed at linux platform I am using CREATE DATABASE name but it is giving me error 1044: Access denied for user: '@localhost' to database 'name' How should I create a new user in it and from the new

Re[2]: Select and = MAX()

For best performance i prefer this way (it's faster): SELECT MAX(price) FROM shop; rather than SELECT price FROM shop ORDER BY price DESC LIMIT 1; -- In second case MySQL must select all records from table, sort it and then apply LIMIT (it's must be logicaly slower than first one) Michal

Fwd: Re: Beginners Query

Probably you run mysql without user: mysql try: mysql -u user_have_access_to_mysql -p or check perms(guest logins, user logins) for creating new databases and RTFM. Almost root (superuser) have access to table mysql, where are permissions stored. Michal Dvoracek

DBI-connect

how can I test DBI-connect ? I'm geting this error: Software error: Execution of /var/www/cgi-bin/mySQL.pl aborted due to compilation errors. Yann carlier +351-21-4527104/5 www.inteliware.net [EMAIL PROTECTED]

Re: DBI-connect

Looks like a perl script, so you can use 'or' (||) to evaluate your 'connect' string, i.e. To stop the script if connect fails use $dbh = DBI-connect(dbi:mysql:database:localhost,'user','password') || die No connection to database; To issue a warning only $dbh =

X interface to mySQL

were can I download X interface to mySQL? Yann carlier +351-21-4527104/5 www.inteliware.net [EMAIL PROTECTED]

<    1   2