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

Codes here !

Moderators: macek, egami, gesf

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

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

Romantik
New php-forum User
New php-forum User
Posts: 67
Joined: Mon Feb 24, 2003 2:55 am
Location: ../Ukraine/Kherson
Contact:

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

Have you any AUTO_INCREMENT in your tables?

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

Yes

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

yes

Romantik
New php-forum User
New php-forum User
Posts: 67
Joined: Mon Feb 24, 2003 2:55 am
Location: ../Ukraine/Kherson
Contact:

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

Hi!
Please, I would like to see your complete structure of this tables


Return to “mySQL & php coding”

Who is online

Users browsing this forum: No registered users and 0 guests

cron