Ok, I have a parts catalog where you can search for a part based on the make of the vehicle. I used a form that passes a query string to a new page that connects to the database, selects the data based upon the value of the querysting (using the WHERE function in the sql select) and displays the results in a table. One of the fields in the databse is the part number. I want to be able to link the part number to a new page that displays all of the details for that particular part. Here is what I have and what is not working....
printf("<tr><td class=\"darkblue\"><A href=\"info.php?partnumber=%s\"%s</A></td>\n", $myrow["PartNo"]);
info.php will be the page that contains all of the details. In info.php in the select statement I will have WHERE partno='$partnumber'. I have the syntax wrong somewhere. When I just link it to info.php the fields shows up as a link in the table but when I try to add the query string it screws up.
How do I do this???
