]=>
]=> mysql> insert into nads values('Florida',
]=> 'http://www.florida.gov');
]=> Query OK, 1 row affected (0.00 sec)
]=
]=I'm a little confused here. I'm slightly more familiar
]=with manipulating PHP than MySQL. It looks like your
]=suggestion is a permanent fix. It just occurred to me
]=that
David Blomstrom wrote:
--- David Rodman <[EMAIL PROTECTED]> wrote:
You mean something like this?
mysql> create table nads(
-> state varchar(50),
-> url varchar(100));
Query OK, 0 rows affected (0.03 sec)
OK, you're creating a table named "nads," with fields
named "state" and "url," right?
Ye
--- David Rodman <[EMAIL PROTECTED]> wrote:
> You mean something like this?
>
> mysql> create table nads(
> -> state varchar(50),
> -> url varchar(100));
> Query OK, 0 rows affected (0.03 sec)
OK, you're creating a table named "nads," with fields
named "state" and "url," right?
> mysql>
Don't forgot the quotes around the URL:
SELECT CONCAT('', state, '') AS link FROM nads;
Michael
David Rodman wrote:
You mean something like this?
mysql> create table nads(
-> state varchar(50),
-> url varchar(100));
Query OK, 0 rows affected (0.03 sec)
mysql> insert into nads values('Califo
You mean something like this?
mysql> create table nads(
-> state varchar(50),
-> url varchar(100));
Query OK, 0 rows affected (0.03 sec)
mysql> insert into nads values('California', 'http://www.california.gov');
Query OK, 1 row affected (0.00 sec)
mysql> insert into nads values('Florida'