All pastes #564168 Raw Edit

JustGags

public php v1 · immutable
·published 2007-06-13 14:06 UTC
rendered paste body
$sql = "SELECT propid,title,userid,timestamp,avgrank        FROM proposals        WHERE catid='$catID'        ORDER BY timestamp DESC        LIMIT 10";$recentProp = mysql_fetch_array(mysql_query($sql));while ($row = $recentProp) {echo $row["title"];}--------- OR -----------$sql = "SELECT propid,title,userid,timestamp,avgrank        FROM proposals        WHERE catid='$catID'        ORDER BY timestamp DESC        LIMIT 10";$recentProp = mysql_query($sql);while ($row = mysql_fetch_array($recentProp)) {echo $row["title"];}