PHP.net’s online manual <\/a>annotations, though…
\n
\nmars@planet-d.net
\n28-Jan-2002 11:39 <\/p>\nit seems php’s mysql_query does handle multiple queries at the same time,
\nbut only returns a boolean value even if the last request is a select…
\nphpmyadmin which uses mysql_query a lot has this behaviour too.<\/p>\n
so i wrote this function to solve this problem<\/p>\n
function sendquery( $db_host, $db_base, $db_user, $db_pw, $query )
\n{
\n $mess = ‘Connexion with server ‘ . $db_host . ‘ failed’;
\n mysql_connect( $db_host, $db_user, $db_pw ) or die( errorhandle($mess));
\n mysql_select_db( $db_base ) or die( errorhandle($mess));<\/p>\n
$array = explode( ‘;’, $query );
\n foreach( $array as $value )
\n {
\n if( !$result = mysql_query( $value ))
\n break;
\n }
\n return $result;
\n}<\/p>\n
i hope this helps.<\/p>\n","protected":false},"excerpt":{"rendered":"
[Note – this post was written in 2002. Things have changed since then – check your docs] What the hell good is a sql call that is limited to a single query? I find that PHP’s mysql_query() won’t take multiple statements. Makes for some unnecessarily wordy code. I found a good snippet in PHP.net’s online […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"activitypub_content_warning":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-342","post","type-post","status-publish","format-standard","hentry","category-blather"],"_links":{"self":[{"href":"https:\/\/ashleyit.com\/blogs\/brentashley\/wp-json\/wp\/v2\/posts\/342","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ashleyit.com\/blogs\/brentashley\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ashleyit.com\/blogs\/brentashley\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ashleyit.com\/blogs\/brentashley\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/ashleyit.com\/blogs\/brentashley\/wp-json\/wp\/v2\/comments?post=342"}],"version-history":[{"count":0,"href":"https:\/\/ashleyit.com\/blogs\/brentashley\/wp-json\/wp\/v2\/posts\/342\/revisions"}],"wp:attachment":[{"href":"https:\/\/ashleyit.com\/blogs\/brentashley\/wp-json\/wp\/v2\/media?parent=342"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ashleyit.com\/blogs\/brentashley\/wp-json\/wp\/v2\/categories?post=342"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ashleyit.com\/blogs\/brentashley\/wp-json\/wp\/v2\/tags?post=342"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}