mattireland

Hi,

I've been looking all over for how to do this but unfortunately haven't been able to find anything... I really hope you can help me please!

I've used navicat to create my database and i've linked two fields: category from table photos and id_cat from table categories - or at least tried to - i think it's worked!

So next, I want to create a drop down menu on my page to display a list of categories (I can do this ) and then I want to make it so that when the user submits the form, they will see a list of things from table photos with that id displayed below (this is the bit i'm having trouble with!)

Thanks very, very much and if you need clarification please do say!

Matt. I

__________________
Matt Ireland
http://www.mattireland.org
matt@mattireland.co.uk

grimpirate

I don't understand much about manipulating databases Matt, but if you can retrieve the photos and their respective ids into some variable in your script all you would need to do is set up a form using the POST method for instance, and then check that the category they submitted exists. If it does go to that category, retrieve your info from the database and output it in whatever format you like. So is it the actual $_POST array you're having trouble with? Or outputting the images/text? Can you retrieve the data you created at all?

__________________
Lo, there do I see my father. 'Lo, there do I see My mother, and my sisters, and my brothers. 'Lo, there do I see The line of my people... Back to the beginning. 'Lo, they do call to me. They bid me take my place among them. In the halls of Valhalla... Where the brave... May live... ...forever.. GrimBB | Mimesis

Syntax_Error

Yeah, please be more specific exactly where your problem is. You should be able to take the post data, run some variable thats connected to the database through a query, and get the results formatted and outputted. Where exactly is the problem?

mattireland

Sorry, I didn't realise it was that simple! I just did that!

Sorry for being such a noob and thank you very much!

__________________
Matt Ireland
http://www.mattireland.org
matt@mattireland.co.uk

kishou

you can use JOIN/UNION
http://www.w3schools.com/sql/sql_join.asp

mattireland

Navicat does that nicely for you but thanks!

It might actually be easier to do it by hand though!

Thanks again!

Matt. I

__________________
Matt Ireland
http://www.mattireland.org
matt@mattireland.co.uk