posted August 04, 2000 07:59 PM            

I have the following problem/challenge...

I have a mysql dbase with PHP, in the dbase I have Items from various locations. What I want to do is to use the SELECT DISTINCT to make a list with all the locations. This isn't the problem, now I want to change the locations into links, so if you click on one of them, you will get a list with all the items from that location.. and here I'm lost:-(

Anybody outthere that can point me into a certain (if possible the right :-) )direction????

Thanks a lot in advance!!!!!

Peace,

posted August 04, 2000 09:47 PM            

$result = mysql_query("SELECT DISTINCT City from listings",$db);

while ($myrow = mysql_fetch_array($result)) {
printf('<a href=/old?u=http%3A%2F%2Fwww.devshed.com%2FTalk%2FForums%2FForum5%2FHTML%2F%25s%3Flocation%3D%25s%26gt%3B%25s%26lt%3B%2Fa%26gt%3B%26lt%3Bbr%26gt%3B%25s&y=1999', "city.php3", rawurlencode($myrow["City"]), $myrow["City"], "\n");
}

posted August 05, 2000 06:07 AM            

Make the above lines easy..

if(mysql_num_rows($result)>0){

while ($myrow = mysql_fetch_array($result)) {
//loop through the cities

echo "<a href=/old?u=http%3A%2F%2Fwww.devshed.com%2FTalk%2FForums%2FForum5%2FHTML%2F%5C&y=1999"city.php3\"?location=".rawurlencode($myrow["City"].">".$myrow["City"]."</a><br>\n";
//print the cities..
}
}else{
//no records are available..
echo "No cities!!!\n";
exit;
}

In city.php3,get the details of that location.

------------------
SR -
webshiju.com

posted August 05, 2000 08:08 AM            

Cube

$query = "SELECT DISTINCT location FROM dbase";

$result = MYSQL_QUERY($query);

/* How many of these locations are there? */
$number = MYSQL_NUMROWS($result);

/* Print these results to the screen*/
$i = 0;

posted August 05, 2000 11:24 PM            

Sometimes variations on a theme can be very helpful, especially to 'beginners'.

I am guilty of sometimes answering questions with code that may not make sense to everbody- even me ! when I look back on them.

And Shiju Rajan has been clearly answering questions for a long time before freddy did php in this forum.

posted August 06, 2000 04:24 PM            

So again thank you both!!!

peace,

posted August 07, 2000 04:06 AM            

Freddy,

I know you are a very good php programmer(reading from your answers).I know i can't reach upto your level.See the above example.your code is perfect.Just i tried to write in my way so i can learn from your script.No question of taking credit. i don't believe in that kind of things. I am here for learning php.So please avoid this kind of comments.

Thank you

------------------
SR -
webshiju.com

"For the LORD gives wisdom: out of his mouth comes knowledge and understanding.."