Use Variables to find values!

[Sitehelp]

Not sure if I am on the correct forum here but I am using Dreamweaver MX. Anyway the problem is that I have a list of all the calls opened by users on the screen, all brought up from the DB using the Dynamic Table option. It all works great, I have 3 options at the end of each row: Modify, Delete and View. Modify and delete work fine, View, when clicked, is meant to bring up a page displaying the record you just clicked on in its entirety. This all works fine to an extent, it displays all the fields in the record, but however, I want it to then look at one of the fields its copied accross, clientID, and then look in abother table in the DB to find out which department they are in so it can display it along with the other details, this is a very important feature in my site. I am unsure how to do this as this code doesnt work:

SELECT clientinfo.CDept
FROM clientinfo
WHERE clientinfo.ClientID = '$ClientID'

$ClientID being the text field that displays the clientid. It may be the order I have my code in but I have tried changing it and it makes no difference, all other txt fields appear fine. I am new at all this. Hope this makes sense. Can anyone help??????????? thanks!

 

[lebisol]

request the info from the form...put it in a variable....use tha variable in the SQL statement (variable=clientID)


> need more info?
:: don't click HERE ::