I have a database with about 4000 items.. How would I view only certain items in certain rows? Say for example... - I just want to view the 3's in B and C and E A - B - C - D - E 1 - 3 -3 - 3 - 3 2- 3 - 3 - 3 - 3 Any help would greatly be appreciated.
Look at the php PDO library for connecting to MySQL within PHP. Some examples here: http://www.phpro.org/tutorials/Introduction-to-PHP-PDO.html#7.2 Then you'll need to compile your SELECT query: SELECT * FROM [table_name] WHERE B=3 AND C=3 AND E=3;
Sorry my english isnt the best.. I want the user to be able to select what should on the table... maybe from a drop down box or something..
ok Say if I wanted to view just All the blue items in table ? Would it be better to put in a drop down box any one have any ideas?
However you determine which rows to get has nothing with how you select them. The PHP file is going to get one or more variables from the html page. Those will be the ones in your SELECT statement (WHERE COLOR = 'blue' or WHERE B = 3). Hoiw you generate the variables - let the user pick them from a dropdown, have them hardcoded, etc., is up to you, but it doesn't affect what happens on the server.