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
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
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,
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
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_short
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 me
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
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
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,
