note 10201 deleted from function.mysql-query by jimw
| From: | jimw@php.net | Date: | Sat, 08 Dec 2001 22:15:24 +0000 |
| Subject: | note 10201 deleted from function.mysql-query by jimw | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-22286@lists.php.net to get a copy of this message | ||
Hello,
If you have more than one semicolon sepparated queries you may split your query something like
this:
$Str_BigSQLQuery= trim($Str_BigSQLQuery);
$Arr_Query = split(";", $Str_BigSQLQuery);
reset ($Arr_Query);
while ( list($k,$v) = each ( $Arr_Query ) )
{
if ($v && $v !=" ") $con->ExecQuery($v);
}
unset ($Str_BigSQLQuery);
where $con is the mysql object, ExecQuery mysql_query method.
Regards,
Uioreanu Calin