Jump to content


Photo

Insert multiple values and then search one

mysql database

  • Please log in to reply
1 reply to this topic

#1 N0name

N0name

    Newbie

  • New Members
  • Pip
  • 1 posts

Posted 31 May 2014 - 10:36 PM

I have 3 tables.

1)state(s_id, details);

 

2)univer(u_id,details,s_id);

 

3)sub(su-id,daetails,u_id, s_id)

 

Now there is a problem, for ever selection of state and univer there is multiple choice of sub and they can be common in different selections. And how to store these values in databse and can call in a selection menu. so how can i solve it?


Edited by N0name, 31 May 2014 - 10:38 PM.


#2 Psycho

Psycho

    Advanced Member

  • Gurus
  • 10,725 posts
  • LocationCanada

Posted 31 May 2014 - 11:33 PM

I don't understand your question. Perhaps you can give some examples of data.


The quality of the responses received is directly proportional to the quality of the question asked.

I do not always test the code I provide, so there may be some syntax errors. In 99% of all cases I found the solution to your problem here: http://www.php.net




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

Cheap Linux VPS from $5
SSD Storage, 30 day Guarantee
1 TB of BW, 100% Network Uptime

AlphaBit.com