Thanks to al that repsonded and helped out. i dicovered that the form itself was not quite right and not posting the variables doh anmy way that is now fixed all but some cosmetics :)
so the problem now returns to the query in companies.php if someone can have a little look and I am sure this will be running in no time at all :) its the submit query button that returns the values the other links are dead :( http://www.punterspower.co.uk/index.php here is the query code... thank you All so much <? echo "<P>City $CityID Trade $Category. <P>\n\n"; ?> <? mysql_connect("$DBHost", "$DBUser", "$DBPass") or die("could not connect"); mysql_select_db("$DBName"); $result=mysql_query('select distinct items.* from items,city,category where items.CityID=city.CityID and items.Category=category.CategoryID'); if (!$result) echo mysql_error(); else { } while ($row=mysql_fetch_row($result)) { $IS=$row['0']; $IN=$row['1']; $ID=$row['2']; $IC=$row['3']; $Ca=$row['4']; $City=$row['5']; $SC=$row['6']; $II=$row['7']; Andrew --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
