Board index   FAQ   Search  
Register  Login
Board index php forum :: Database mySQL & php coding

oh now how can i update data simultaneously in 2 tables!!!!!

Codes here !

Moderators: macek, egami, gesf

oh now how can i update data simultaneously in 2 tables!!!!!

Postby sarjanajava » Fri Feb 21, 2003 4:18 pm

i have 2 tables :

student : studentID tinyint(4) PRIMARY KEY
name varchar (50)
and

subject : studentID tinyint(4) PRIMARY KEY
subject varchar (255)

----------------------------------
what should i do. when i insert a value via FORM , studentID can be updated simultaneously is both tables. TQ
User avatar
sarjanajava
New php-forum User
New php-forum User
 
Posts: 41
Joined: Wed Nov 27, 2002 10:59 pm

Postby Romantik » Mon Feb 24, 2003 4:48 am

Have you any AUTO_INCREMENT in your tables?
Romantik
New php-forum User
New php-forum User
 
Posts: 67
Joined: Mon Feb 24, 2003 2:55 am
Location: ../Ukraine/Kherson

Yes

Postby sarjanajava » Thu Feb 27, 2003 7:07 am

yes
User avatar
sarjanajava
New php-forum User
New php-forum User
 
Posts: 41
Joined: Wed Nov 27, 2002 10:59 pm

Postby Romantik » Fri Feb 28, 2003 12:23 am

Hi!
Please, I would like to see your complete structure of this tables
Romantik
New php-forum User
New php-forum User
 
Posts: 67
Joined: Mon Feb 24, 2003 2:55 am
Location: ../Ukraine/Kherson


Return to mySQL & php coding

Who is online

Users browsing this forum: Google [Bot], Yahoo [Bot] and 1 guest

Sponsored by Sitebuilder Web hosting and Traduzioni Italiano Rumeno and antispam for cPanel.

cron