mysql_query() can execute more than one sentence?

IrYoKu

It is possible? This gives me a sintax error:

$query = "DROP TABLE IF EXISTS users; CREATE TABLE users (userId TINYINT UNSIGNED, name VARCHAR(10)";
mysql_query($query);

So I think that to do a lot of queries I have to use an array and go through it, I am wrong?

Thanks and sorry, I am very new to this ^_

makaio

it might help if you could post the error message you receive

johnnyv

AFAIK is is not possible to send more than one query at a time using mysql_query(). Certainly the php.net documentation doesn't show how to send more than one anyway.

why not do the normal:

$query = "DROP TABLE IF EXISTS users";
mysql_query($query) or die("Couldn't perform query 1: $query");
$query = "CREATE TABLE users (userId TINYINT UNSIGNED, name VARCHAR(10)"; 
mysql_query($query) or die("Couldn't perform query 2: $query");

I assume you set up the database connection correctly as you are not specifying a connection to use in the mysql_query function?

makaio

there has to be a way. phpmyadmin lets you run as many queries as you want. (or at least quite a few up to some pretty high limit).

IrYoKu

Thank for your replies!

I think too that mysql_query can do only one mysql sentence. But it is odd and annoying!!! I use something like this:

 
$listaSql = array();
$listaSql[] = "DROP TABLE IF EXISTS pi_usuarios";
$listaSql[] = "DROP TABLE IF EXISTS pi_noticias";
$listaSql[] = "DROP TABLE IF EXISTS pi_imagenes";
$listaSql[] = "DROP TABLE IF EXISTS pi_videos";
$listaSql[] = "DROP TABLE IF EXISTS pi_enlaces";
$tamannoLista = count($listaSql);
for($i = 0; $i < $tamannoLista; $i++)
{
  if (!mysql_query($listaSql[$i])) {
    die("<H1>E R R O R</H1><BR>" . mysql_error());
  }
}

mystrymaster

how many queries are you looking at executing at one time?

if the number is as limited as the example it almost seems like more work to do it with the array.

IrYoKu

For the moment 12 queries. I think it is easier and more clean to use an array.