essential

Could I use an if statement with say [b]goto location_id if contains "ecen" goto location_id_2 [/b] If this is possible could I also add [b]if location_id_2= ecen goto location_id_3 etc[/b] I have tried tweaking the recordset but it just throws up an error. Recordset below [b]SELECT autonumber, coName, location_id FROM preferredSuppliers WHERE location_id = 'ecen' ORDER BY coName ASC[/b] How easy would it be to alter this to give me what I need Essential

Now working in full thanks for your help, I have listed the final Recoredset below incase it can help others <?php do { ?>   <li> <a href="suppliers.php?autonumber=<?php echo $row_reSuppliers['autonumber']; ?>"> <?php echo $row_reSuppliers['coName']; ?> <?php } while ($row_reSuppliers = mysql_fetch_assoc($reSuppliers)); ?></a></li> &nbsp;  &nbsp;  </ul>       

Hi moberemk Many thanks for your prompt help. Thank you very much I now have it to work, well almost I have redesigned the links so as they are dynamic pulled from the database, have binded them to the id tag, and when click it loads the first page. Fantastic Guess what happens when I click the second link? Nothing well that's not true page one opens up in fact when I click on all links all I get is page one? Almost there?

Hi Guys and Girl’s I need some help, I use Dreamweaver MX 2004, have managed to build a partial site, using PHP /Mysql all talking to each other and can view live data, so that side is fine Here is where I need help I have s series of occupations listed and I want to have a viewer see these occupations and click (standard Hyperlink) which will go to the data base and load up a webpage. The current site is based on 10+ individual web pages now want to streamline it. So here goes with a semi visual explanation of what I am looking for Page 1  (Index page) Occupation (hyperlink) I need to know the URL to put on this link which will go to database collect information and place into a webpage (page 2) occupation.php that is already set up as an occupation template i.e. have placed  <?php echo $row_Recordset1['occupation_1']; ?> in the required places to build the page. Database base name is services and table is called jobSearch I assumed that all I would need to do was the following [b]http://www.mydomain.com/services/jobsearch=id2[/b] (is this correct? what I can not work out is how do you put the data onto webpage (page 2) Sorry if this goes on a bit but wanted to get it all in one go Essential