passing id...

[Anon]

Hi, i am displaying a list of entrys from my database based on a categories field. When the user selects which entry they want to edit, the id is passed onto another page where the text inputs are filled with the existing data for edit.

What i am having a problem with is that as soon as i changed the code from (SELECT FROM general WHERE id=$id) to (SELECT FROM general WHERE (category='jewellery') it no longer displays the existing data on the next page for editing....do i need to reinclude the id in that statement? it still seems to have passed the id because it shows in the url of the browser.....confused

thanks for any help in advance

[Anon]

OK this one is a little easy but not simple. Select statements: 1. DO NOT INCLUDE () anywhere. I don't like them. 2. after you put Select from general where id='$id'; its better to that the '' in there so it knows something. I think it will work if it looks like this. Select from general where category='jewellery' and id='1'; That will return everything in jewellery and where id=1. So just cut out the () lata!
Zig's