[PHP-DB] SQL coloring in BBEdit 6.0?

Hello, I'm using BBEdit 6.0.2 to do some PHP. I love the way it colors the PHP commands differently. I also do mySQL. I usually write up a whole list of SQL statements in a text editor and then feed them into the server. Is there a way to have BBEdit color code the mySQL commands that same wa

[PHP-DB] Looking for a good MySQL db abstraction layer

I'm looking for a good MySQL db abstraction layer. I'm just coming back to PHP/MySQL and rather writing my own I figured I'd try to see if any are already out there. The layer should obviously have the basics, of connect, query, and close, and possibly some error checking and handling. thanks,

Re: [PHP-DB] how to start and bring down mysql.server on OSX

Twas 3/15/02 9:51 AM, when "andy" <[EMAIL PROTECTED]> said: > Hi there, > > I am running mysql 3.23.38 on os x. Till now I did start the server by unix > command safe_mysqld. This worked, but did always freeze the shell and I did > have to open a new one. Bringing down the server worked only by

[PHP-DB] how expensive is mysql_connect in performance

I'm just getting into some stuff where I seem to be making a lot of mysql_connect and mysql_close calls. I wonder, how taxing is this on the server? Is there any performance test of PHP/MySQL out there I could run on my development or deployment machines? ~ Mike -- Mike Zornek | Project Leader

[PHP-DB] Mysql syntax error - phpMyAdmin ??

I was using phpMyAdmin to do an export from one machine to another and on import I got an error: > Error > > SQL-query :  > > CREATE TABLE hospital ( > id smallint(5) unsigned NOT NULL auto_increment, > heath_system_id smallint(5) unsigned default NULL, > name_long tinytext NOT NULL, > name_sh

Re: [PHP-DB] Mysql syntax error - phpMyAdmin ??

Twas 7/10/02 12:55 PM, when "Martin Clifford" <[EMAIL PROTECTED]> said: > DESC is a reserved word in SQL, standing for Descending Order. That is why > you can't use it as a table column name. Ok, that makes sence - thanks! Although I find it a bit curious that building the DB in phpMyAdmin let

[PHP-DB] get row id back on INSERT?

Ok, So I'm creating the usually MySQL backend I have a page that I want to create a new record with some name, then I'd like to capture the new records id (which is an auto-increment int field) so I can pass it to the edit.php?id=$theId URL I could run a reach for the newly inserted row by

[PHP-DB] 's "id" and "name" -- question...

does the id attribute of an input tag override the name attribute when trying to pull these vales on a subsequent php page? Does it make any difference? I ask cause I'm now PHP-ifing a form I designed in Dreamweaver and it added ids attributes all over the place. Wonder if I should edit them, del

[PHP-DB] Cool MySQL -> Excel Shell Script

Here is a simple, yet very useful shell script that will automate MySQL output to open into Excel where you can view it with more control, save it to a spreadsheet for other coworkers, etc. I played with this a bit and it's really cool. Bound to save me a lot of time so I thought I'd share. While

[PHP-DB] MySQL Ques: default for date field be current date

I'm trying to convert an ASP/Access tutorial to PHP/MySQL and have a question regarding MySQL. In Access one can create a date field and set the default to "Date()" to get the current date but according to the mysql manual: http://www.mysql.com/doc/en/CREATE_TABLE.html > Default values must be c