; <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Monday, April 08, 2002 11:11 AM
> Subject: [PHP-DB] Error creating new table
>
>
> > I am trying to create the following table using PHPMyAdmin:
> >
> > CREATE TABLE IF NOT EXISTS ayny(
> >
>You can't have NOT NULL assigned to a text field.
So...should it be
maintext text NULL,
or just
maintext text
???
Russell Griechen
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Q: 3969599
Owner of the 3D-Unlimited Network:
http://www.3d-unlimited.com
Send News:
[EMAIL PROTECTED]
- Original Message -
From: "George Pitcher" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; "Lisi" <[EMAIL PROTECTED]>
Sent: Monday, April 08, 2002 3:13 A
The problem is that he assigned a length to a TEXT field. You cannot do
that.
-Original Message-
From: George Pitcher [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 08, 2002 3:13 AM
To: [EMAIL PROTECTED]; Lisi
Subject: Re: [PHP-DB] Error creating new table
You can't have NOT
You can't have NOT NULL assigned to a text field.
george
- Original Message -
From: "Lisi" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, April 08, 2002 10:11 AM
Subject: [PHP-DB] Error creating new table
> I am trying to create the fo
"PHP-DB" <[EMAIL PROTECTED]>
Sent: Monday, April 08, 2002 11:33 AM
Subject: Re: [PHP-DB] Error creating new table
> Worked like a charm, thanks.
>
> How do I avoid varchar if I the size of the text will vary with each
entry?
>
> It's going to be a pretty s
i" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Sent: Monday, April 08, 2002 11:11 AM
>Subject: [PHP-DB] Error creating new table
>
>
> > I am trying to create the following table using PHPMyAdmin:
> >
> > CREATE TABLE IF NOT EXISTS ayny(
> >
;[EMAIL PROTECTED]>
Sent: Monday, April 08, 2002 11:11 AM
Subject: [PHP-DB] Error creating new table
> I am trying to create the following table using PHPMyAdmin:
>
> CREATE TABLE IF NOT EXISTS ayny(
> organization varchar(50) NOT NULL,
> subtitle varchar(50) NOT
I am trying to create the following table using PHPMyAdmin:
CREATE TABLE IF NOT EXISTS ayny(
organization varchar(50) NOT NULL,
subtitle varchar(50) NOT NULL,
img varchar(20) NOT NULL,
width varchar(5),
height varchar(5),
link varchar(30) NOT