//first query
$query = "SELECT id, cname, csubhead, caddress, chours, ccontact, coverview, curate, cunumrate, cyamrate, cweb, cglat, cglong, cstores, cgzoom FROM shopcenter WHERE id=2";
$result = mysql_query($query) or die ("Error in query: $query. " . mysql_error());


// if records present
if (mysql_num_rows($result) > 0)
{
	// iterate through resultset
	// print article titles
	while($row = mysql_fetch_object($result))
	{
//second query
$query2 = "SELECT id, sname, stype1, scenter1  FROM stores WHERE scenter1 = $row-> cname ORDER BY sname";
$result2 = mysql_query($query2) or die ("Error in query: $query. " . mysql_error());

$query2 = "SELECT id, sname, stype1, scenter1  FROM stores WHERE scenter1 = '" . $row->cname . "' ORDER BY sname";

$query = "SELECT a.id, a.sname, a.stype1, a.scenter1"
	. " FROM stores a"
	. " INNER JOIN shopcenter b ON b.cname=a.scenter1 and b.id=2"
	. " ORDER BY a.sname"
	;