Thursday, May 21, 2009
MySQL SubQuery
//mysql_subquery
//copyright 1999 avi bryant, all rights reserved
//feel free to use this and modify it as you see fit
function sub($result)
{
if($result == 0)
return "()";
else
{
$row = mysql_fetch_row($result);
$strResult = "( $row[0]";
while($row = mysql_fetch_row($result))
$strResult = "$strResult , $row[0]";
$strResult = "$strResult )";
return $strResult;
}
}
function mysql_subquery($query)
{
$substart = strpos($query, "(");
if($substart != false)
{
$subend = strrpos($query, ")");
$before = substr($query, 0, $substart);
$after = substr($query, $subend+1, -1);
$subquery = substr($query, $substart+1, $subend-$substart-1);
$subresult = mysql_subquery($subquery);
$subtext = sub($subresult);
return mysql_query($before . $subtext . $after);
}
else return mysql_query($query);
}
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment