ok - so im a beginner and am trying to figure out a couple of things, so PLEASE if you can help on ANY of these questions i would appreciate it.
first off - could anyone point me to anything to do with MULTIPLE FIELD SEARCHES using postgresql and php (or mysql - im assuming its similar). what i am trying to do is conduct a search of my database using 4 drop down menus (select boxes) and am not sure how to go about this (ie. - do i have to construct if/elseif statements for every selection within the select boxes or is there a shorter easier way ?).
Next thing im trying to figure out is when a set from a table is displayed (such as the id and name of a product)- i want the "name" field for instance to be a LINK to that individual product's unique information.
The last thing i would love some help on is - i have constructed an update script that works great - however - i would like to know - how do you create a time stamp that inserts the date when an update is inserted into the system ? im assuming there must be a script for this that doesnt have to do with the database portion.
THANKS AGAIN TO ANYONE THAT MAY HELP.