RE: [PHP-DB] CREATE TABLE problem

I have had similar problems before. I have just created your table in MySQL. Seems you can't have an AUTO_INCREMENT column that is UNSIGNED. Doesn't mention this in the manual though. Neil Morgan -Original Message- From: js [mailto:[EMAIL PROTECTED] Sent: 21 January 2004 22:34 To:

[PHP-DB] how can I delete a record from txt file

Hi; I take users from Active Directory with ldap functions and put them in a list menu. I have got two txt files. One of them hold the users which have got internet access and one of them holds the users which have got speedily internet access. Also may be a third file that hold the users which

[PHP-DB] PHP crashes...

Here is the source until something is returned by the first function call (first from top to bottom): ? session_start(); // Template-class require('template.inc.php'); // Some DB-Data [EMAIL PROTECTED] getenv(DOCUMENT_ROOT)./conn.con; if ($dbconn!=1) { sprintf(%s,$dbconn); exit(); } //

Re: [PHP-DB] MSSQL stability problem

Robert Twitty wrote: Maybe you are running out of connections. The max connections settings in both php.ini and SQL Server are set to unlimited. Is there another limit I am not aware of? -- Stuart On Wed, 21 Jan 2004, Stuart wrote: I have a site that makes heavy use of a local SQL Server

Re: [PHP-DB] MSSQL stability problem

Stuart wrote: Robert Twitty wrote: Maybe you are running out of connections. The max connections settings in both php.ini and SQL Server are set to unlimited. Is there another limit I am not aware of? I am now closing the connection to MSSQL at the end of every page and it still does it. I've

RE: [PHP-DB] CREATE TABLE problem

Regarding... -- $query = CREATE TABLE staff ( -- staffid INT(3) NOT NULL AUTO_INCREMENT UNSIGNED, -- name VARCHAR(255) NOT NULL, -- login VARCHAR(10) NOT NULL, -- password VARCHAR(8) NOT NULL, -- picaddy VARCHAR(255) NOT NULL, -- email VARCHAR(255) NOT NULL, -- staffbio TEXT NOT NULL, --

[PHP-DB] Drop down box NOT populated

Can anyone tell me what I am missing here, The Select statement does not populate my drop down window? My drop down box is empty ! [snip] ? include '../db.php'; $how = mysql_query(SELECT count(distinct(account)) from Backlog) or die (Something bad happened: .

Re: [PHP-DB] Drop down box NOT populated

Larry Sandwick wrote: Can anyone tell me what I am missing here, The Select statement does not populate my drop down window? My drop down box is empty ! ? include '../db.php'; $how = mysql_query(SELECT count(distinct(account)) from Backlog) or die (Something bad happened: . mysql_error());

Re: [PHP-DB] Drop down box NOT populated

- Original Message - From: Larry Sandwick To: [EMAIL PROTECTED] Sent: Thursday, January 22, 2004 3:46 PM Subject: [PHP-DB] Drop down box NOT populated Can anyone tell me what I am missing here, The Select statement does not populate my drop down window? My drop

[PHP-DB] editing, deleting records

Here's a part of my code, which is retrieving player records from mysql and displaying them in a table: - if($queryChk3 !== 0){ print(form action='$_SERVER['PHP_SELF']' method='POST' input type='hidden' name='teamID' value='$teamID'

[PHP-DB] Re: editing, deleting records

Kirk Babb wrote: Here's a part of my code, which is retrieving player records from mysql and displaying them in a table: - if($queryChk3 !== 0){ print(form action='$_SERVER['PHP_SELF']' method='POST' input type='hidden' name='teamID'

[PHP-DB] @mysql_connect freezes

Hi, I am trying to find a problem with my sql connection now that I have split my sql server from the apache server. (Chain of Events) 1. Copied working web page with php sql commands to a new web server 2. Added apache server/username to new sql servers database auth. 3. Made sure that server,

Re: [PHP-DB] Database Abstraction Layer?

I like PEAR::DB myself, especially since so many other PEAR packages build upon it. To make your code even more DB independant, you can use a package which builds the SQL for you, such as DB_DataObject. It can also quote table / column names and values correctly per DB. (Although DB hasn't

Re: [PHP-DB] Database Abstraction Layer?

There's also PEAR's DB_DataObject which does build SQL for you. The join syntax isn't set up to be totally DB independant yet, but it can and will be. Paul Miller wrote: PEAR is great from what I hear. The issue you are going to run into with DB independence is not the function calls which

Re: [PHP-DB] CREATE TABLE problem

hmm ... I have unsigned auto_increment fields in all my tables that use unique field IDs... But i use very long counter fields as it's pretty big tables I have (or gonna be once I get them finished)... FWIW Rene Fate would have it, that on Thu, 22 Jan 2004 08:47:01 -, [EMAIL PROTECTED]