[PHP-DB] Re: ORDERing two UNION queries

2007-04-14 Thread Neil Smith [MVP, Digital media]
At 03:04 14/04/2007, you wrote: Message-ID: <[EMAIL PROTECTED]> Date: Fri, 13 Apr 2007 17:48:11 +0100 From: ioannes <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] MIME-Version: 1.0 To: [EMAIL PROTECTED] Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bi

[PHP-DB] Re: auto_increment

2007-04-14 Thread David Robley
Ron Piggott wrote: > Does anyone see anything wrong with the $query syntax? Ron > > mysql_connect(localhost,$username,$password); > @mysql_select_db($database) or die( "Unable to select database"); > $query="ALTER TABLE sessions auto_increment = '1'"; > mysql_query($query); > mysql_close(); The