Displaying records on a page

v00d00

Hi,
I have a page with a map on, I want to be able to run a query when someone clicks on a country on the map that will show all users in that country. The link would be..

http://www.domain.com/map/index.php?country_code=uk

And the search would be like

$sql="SELECT * FROM table WHERE country_code='$country'";

This should return all users with the country code UK in there record(haven't tested it yet).
However, my problem is...How do I display those records in table format on my page. I need to have a table with
username | 1st name | last name | description....etc.
In some countries thre might be 1 user, in others hundreds. How do I format a page, to take this in to account?
Many thanks
/v00d00

P.S. Also after I have fingured this out, I need to be able to click on the username as a link, which will then show a more detailed page of information, just for that user. I don't know if this would affect this 1st piece of code, but I thought I should let you know. Once I get the 1st bit done, the 2nd should be too hard to figure out.

alcapone

heyya,
so as far as I understood you're having a problem with actual transforimg info from sql to php, correct?
unfortunately I can help you with mySQL/php only, so if you use any other db...sorry 🙂

<body>
<table border=0>
<?php
$link=mysql_connect('localhost','','');
mysql_select_db('yourbase',$link);
$query="SELECT * FROM table WHERE country_code='$country'";
$sql_reply=mysql_query($query, $link)
while ($row=mysql_fetch_row($sql_reply)){
list ($username, $fname, $lname, $description, $etc)=$row;
$pagewithdescription="$username.dat";
print <<<EOF
<tr>
<td><a href="$pagewithdescription">$username</a></td>
<td>$fname</td>
<td>$lname</td>
<td>$description</td>
<td>$etc</td>
</tr>
EOF;
}

well I guess that would do it, but I haved tested it because I am away from my computer 🙁 if it doesn't work please tell me
cheers,
AlCapone

bjblackmore

Hi,
I have managed to get this code, which seems to work,
mysql_select_db("db");
$sql="SELECT * FROM users WHERE country='$country'";
$result=db_query($sql);
if (!$result || db_numrows($result) < 1) {
echo 'Sorry Users In That Country';
return false;
} else {
while($rs=mysql_fetch_array($result)){
echo "<tr>
<td>$rs[2]</td>
<td>$rs[7]</td>
<td>$rs[8]</td>
<td>$rs[9]</td>
<td>$rs[10]</td>
</tr>\n";
}
}
cheers anyway, i'll keep your code on file, in case i need it in the future.
Maybe you could help with a problem i'm having with this. The..
if (!$result || db_numrows($result) < 1) {
echo 'Sorry Users In That Country';
return false;
Section doesn't seem to work properly, when you look at it in a browser, it literly just stops at 'Sorry Users In That Country' I have a footer.php included at the end of my file, and it doesn't print that! Do you know why?
Cheers
Ben