Making a new field with 2 existing fields

boldorus

I want to create another field into an existing MYSQL database

This new field will be the addition of 2 existing fields
the field id and the field url

in idfield, i have a number = row number ( 1,2,3,4,5,6, ... )
in the url field, I have URL in plain text ( [url]http://.../page.php?id=[/url] )

What I'm trying to do is to create a new field that takes the data from the ID field and ADD IT to the data from the URL field.

So I will found in the NEWFIELD, some plain text like :
example, [url]http://.../page.php?id=1[/url] ( if id=1 )

I need to write the command to:
Create a new field (from the addition of field url + field id )

I use phpmyadmin to edit my database

Can someone help me with that problem?

barand

first add the field "newfield"

ALTER TABLE tablename ADD newfield varchar(100)

or whatever size u need

then

"UPDATE tablename SET newfield = CONCAT(url,id)"

hth

barand

PS - having said that, its a bad idea to hold data twice. If the URL changes, you now have 2 fields to update.

Better to hold just the url and add the "?id=$id" bit programatically when you need to.

boldorus

I have done the first operations with that result:

ALTER TABLE TABLE_tbl ADD url2 VARCHAR( 50 ) NOT NULL ;

Where do I ...

"UPDATE tablename SET newfield = CONCAT(url,id)" ?

I have those options in phpmyadmin:
Structure
Browse
SQL
Select
Insert
Export
Operations
Options

I'm really a newbie in MYSQL

At the present time, i have to update manually the database because the url data is not dynamic. I simply need that the database add the 2 fields to solve a problem. I need to design my web pages in a different way so i can use your suggestion.

barand

I don't have phpmyadmin but maybe SQL? I'm surprised there's no update option if they have select and insert.

boldorus

Error

SQL-query :

"UPDATE flq_tbl SET url2 = CONCAT (perso_url,id)"

MySQL said:

You have an error in your SQL syntax near '"UPDATE flq_tbl SET url2 = CONCAT (perso_url,id)"' at line 1

Notes
flq_tbl is the name of the table
perso_url is the url data already into the DB

barand

Did you enter the quotes in the query? If so, leave them out

boldorus

I have input the following:

UPDATE flq_tbl SET url2 = CONCAT(perso_url,id)

And I receive :

Error

SQL-query :

UPDATE flq_tbl SET url2 = CONCAT( perso_url, id )

MySQL said:

Unknown column 'url2' in 'field list'

kevinsequeira

if this is a follow up of the earlier posts, u dont need to have url2, u are fine with perso_url and id.., infact its a bad idea to have url2

when u display just get the final url through php code like

echo '<a href='.$perso_url.'?id='.$id>link</a>';

reg
kevin

barand

kevinsequeira -

infact its a bad idea to have url2

I've already told boldorus that - perhaps your additional reinforcement might help the case

barand

ALTER TABLE TABLE_tbl ADD url2 VARCHAR( 50 ) NOT NULL ;

That was your 'alter table' query. Now you are updating flq_tbl. Which table name should it be?

boldorus

I know that having an URL2 is a bad idea

But it solve my problem for the moment. I plan to write other pages with your suggestions but in the meantime, it work.

In a couple of days, I will be doing another page linked to my database but I will not use templates. It will be simplier to follow.

Have a nice day