shenagsandnags

ok but with all this will this still allow me to group my results in multiple tables ? see all this has been real confusing to me because i have been using MS Access for some time now. in access all i had to do was create a simple query and then use a report wizard which allowed me to group my results. what i mean is, you see how the script above retrieved the movies but it showed the results in 1 table: Titanic | Drama Avatar | Drama with ms access i had it showing results in multiple tables and each table was a category with a listing of titles related like: -Drama- Avatar Titanic -Comedy- Friday Up in smoke its gone now but i think i used something like : Select Movies.title, Movies.[Category] From Movies Where Movies.[Category]=Drama ??? i also had another table called Categories which it only had ID and Category name. would it be that hard to do this within mysql/php ?

Ok now a much easier question then, i just created a simple html form just as the scipt above (minus showing the results on the same page) but i need a drop menu instead of a text box that will pull all the categories thats listed in the categories table (which just holds ID and Category name)

other then just having the link open in a new window or in a left frame (haven't decided yet) thats pretty much exactly what i was looking for. im actually using 2 tables for my DB and still need to write out a statement but yea, i didnt know how to make my titles links like that

Im working on a movie database and im sure i can figure out how to insert a link into a table but i cannot figure out how to turn the movie titles themselves into the link when creating a statement. Say my table looks as this Title | Category | URL -------------------------------------------------------------------------- Titanic | Drama | Http://www.imdb.com/titanic So when i create my statement i want the actual title itself to be the hyperlink. get what im saying ? In my statement results i want it to look like: Titanic | Drama Avatar | Drama etc. (With Titanic and Avatar being the link) and not like: Titanic | Drama Http://www.imdb.com/titanic Avatar | Drama Http://www.imdb.com/avatar etc.. Im still working on fully understanding all this so if i sound like a idiot just bear with me

Well ive been messing with ms access and through out the tutorials im starting pick up how all of it works. i originally thought that i was just going to be able to write a couple php pages that connected to mysql on a hosted site and work simple. now i see the picture and im just going to use php to retrieve the info from my db to post on my site. im glad i stopped by here though because i imagine i would have spent alot more time getting to where i am now.

Yes, no doubt. thanks alot to you guys really setting all that our for me. i think i pretty much just about got everything figured out to what i need. once i get everything up and running im going to be using a form that im working on to update the tables. one thing i do got to get figured out before i start getting my hands dirty is getting the db and tables created. i already got a site completed for this script to go in, in which i was just going to create a gamelist.php and link it to the left menu on my site and let the list just show up in the right frame. so my last question is do i throw in the "CREATE DATABASE" and "CREATE TABLE" statements in my gamelist.php above all the SELECT statements but below connecting the DB statements or do i need to create a seperate file for that ? it just seems to simple to have all that in 1 file. or should i just create the databases using the mysql shell or something ?

Ok so pretty much both of you are saying that my tables should look like: Games ------ Id - Category_id - Title - URL ---------------------------------------------------- 21 | 1 | Racing Game 1 | http:// 22 | 2 | Shooter Game 2 | http:// 23 | 3 | Fighting Game 3 | http:// Categories ---------- Id - Category_Name ------------------- 1 | Racing 2 | Shooter 3 | Fighting and then if i used : SELECT Games.*,Categories.name FROM Games, Categories ON Categories.id = Games.category_id ORDER BY Games.category_id ASC i would get: Racing ----------- Game 1 Game 2 Game 3 Shooter ---------- Game 4 Game 5 Game 6 etc.. i got all this correct ?

first, thanks for taking the time out and pointing that out to me thats exactly the type of information i was welcoming like i said i knew i wasnt using it to its efficiency im sure i will nail it once i start getting more experience with it. second, so in the games table i will still use 2 columns right, title/link ? assuming im right about that then how exactly do i make the titles become the link in the results ? im not expecting you to type it out to me but maybe at lest point me somewhere ? i dont know if im just not using the right search terms or what but i really cannot find anything specific to the subject. thanks again.

Hey all, new to the forum and php as well! well sorta.. anyways im working on this new script to list my xbox games and have a simple question. The way im designing the database for this is, im going to have 5 game categories; racing,shooter etc. each category is going to be a table in the database so theres 5 tables. each table is going to have 2 columns "Title" and "Link (to game info)". now my goal is once the database is completed i want to create a query it and get this result in mygames.php or whatever i name it: Racing ----------- Game 1 Game 2 Game 3 Shooter ---------- Game 4 Game 5 Game 6 etc.. Now as you see, in the end result you dont see the link to each title beside it in column 2, as it looks in the database. thats because instead of having the link show beside each title i would rather have the title itself be the link so when the user clicks on it, it would popup in a new window. Hopefully i done a decent job in explaining this so its understandable but i would like to know if this is possible ? im suprised google hasnt billed me for as many searches ive used for this but i just cant get an answer. im not even sure im designing the database to my specific needs to its full potential, hey im learning but i also welcome any tips or ideas just as long as i can get the exact result i need, nothing fancy. thanks everyone!