All pastes #447291 Raw Edit

Untitled

public php v1 · immutable
·published 2007-04-18 22:51 UTC
rendered paste body
function grabUserTrips($useridinfo){$friendtrip = mysql_query("SELECT userid,tripid,endcityname from userTrips where userid = ".$useridinfo."") or die(mysql_error());  	while($friendtriprow = mysql_fetch_array($friendtrip)) {		echo '<a href="trip.php?userid='.$friendtriprow[0].'&trip='.$friendtriprow[1].'">'.$friendtriprow[2].'</a><br />';	}}echo '<table cellpadding="0" cellspacing="0" border="0">';$pullyou = mysql_query("SELECT friend from infoFriends where userids = ".$_SESSION[SESS_USERID]."") or die(mysql_error());  	while($row = mysql_fetch_assoc($pullyou)) {	$pullingyou = mysql_query("SELECT * FROM userInfo WHERE userid = '$row[friend]' LIMIT 8");	while($extract = mysql_fetch_assoc($pullingyou)) {		echo "<tr><td><table cellpadding=\"2\" cellspacing=\"0\" border=\"0\"><tr><td align=\"left\" valign=\"top\"><a href=\"viewfriend.php?userid=$extract[userid]\">$extract[firstname] $extract[lastname]<br /><img src=\"$extract[profilepic]\" border=\"0\" width=\"75\" height=\"100\"><br /></a></td><td valign=\"top\"> Your friend's trips:<br />".grabUserTrips($extract[userid])."</td></tr></table><br /></td></tr> ";	}		}