Re: db sql issue from var
| From: | Dave Carrera | Date: | Thu, 01 Jan 1970 00:00:00 +0000 |
| Subject: | Re: db sql issue from var | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-19442@lists.php.net to get a copy of this message | ||
Ok craked it... yes me i craked it....:-)
All you need to do is create an array from your sql like this:
1st place your dumped sql statement into a varibale.
2nd create an array from your sql like this
if(isset($your_execution_var))
{
$array = explode( ';', $sqlvar );
foreach( $array as $value )
{
if( !$result = mysql_query( $value ))
break;
}
return $result;
}
Thats it.
If you want it explaining any more them please email me.
Of to finish my project :-)
Dave C
P.S you can add a message var under break to then echo it to inform your
user that its finished.
-------Original Message-------
From: Rasmus Lerdorf
Date: Sunday, May 26, 2002 17:10:53
To: Dave Carrera
Cc: php List
Subject: Re: [PHP-DB] db sql issue from var
> I think it an issue with including multiple sql commands in one var...
Yup, you can't do that. Simply separate them and do them one at a time.
-Rasmus
.