Multiple listings sort by primary key
I am only getting the first address from the 1000's of customers that my site has. How do I display this map on their "profile" page based on that page's primary key for other profile data from the user.
$query_AddressSet = "SELECT address, address2, city, stateprov, postalcode FROM pbn_contact";
do I need to put WHERE CKEY= "the CKEY already connected to their record"
this is already defined on my page that I want to display the map by member:
$url = INSTALLPATH . "fullpage.php?ckey=" . $ckey;
$AddressSet = mysql_query($query_AddressSet, $mappie) or die(mysql_error());
$row_AddressSet = mysql_fetch_assoc($AddressSet);
$totalRows_AddressSet = mysql_num_rows($AddressSet);
If you know the proper syntax, I would appreciate it.. I can read PHP, but I can't write it.