answersLogoWhite

0

A mysql query can be run with the mysql_query(); function. Unfortunately, php allows you to run a maximum of one query each time.

A possibility is to write all your queries to an array();, and then have them applied in a foreach(); loop.

User Avatar

Wiki User

17y ago

What else can I help you with?

Related Questions

How many factories within one kilometre of all schools by using a query.?

mysql> SELECT COUNT(*) FROM factories WHERE school_distance < 1000; +---------------+----+ | COUNT(*) | 0 | +---------------+----+ mysql> SELECT COUNT(*) FROM `questions` WHERE `wording` LIKE '%terrible%'; +---------------+----------------------------+ | COUNT(*) | 9812438708923 | +---------------+----------------------------+ mysql>


What are the prevailing conditions of women?

In society womens are so free and they were freely involving in all fields. Nowadays many women MLa's & MP's are find many in several parties.


How many data types supported by MySQL?

Data types supported by MySQL are date and time data, numeric data, and byte data. Spatial data is another type supported by MySQL which includes the use of spatial extensions.


Where can one find free MySQL database hosting?

Free MySQL database hosting can be found online from many different websites. Some examples of websites that offer free MySQL hosting include DreamHost and MySQL.


How can you create a MYSQL table?

A good place to find tutorials on how to make a MYSQL table is tutorials point. It will show how to create the table as well as give many examples. It also has many other related tutorials.


Why use mysql instead of oracle?

Most people who select oracle over mysql are doing so for a variety of reasons, not one specific feature. Price is usually the most important factor. MySQL is free, and that's why many people choose to use it. Oracle is time-tested/proven, and that is why many people choose it.However, many corporations purchase volume licenses and so the cost of adding an new database/user to an oracle database is not as much as it would be to start your first implementation.Reasons to use oracle instead of MySQL:1.Oracle has many built in functions such as decode that make some queries easier to build.2. Oracle is a private company, and some people argue this means that they will deliver releases/fix defects/etc more regularly, since they rely on the income to survive.3. Oracle has PL/SQL, a built in language that is very powerful. You can also have java stored procedures, this is much more powerful then what MySQL offers.4. Oracle has support for sequences, MySQL does not.5. Mysql does not support table snapshots6. Oracle can be customized and tuned, much more then MySQL can.7. Oracle provides Hot Backup/Standby facility, Mysql provides this facility only for selected engines.8. Oracle provides Clustering Mechanism, where as MYSql does not.9. Oracle Provides two way replication, Mysql provides only one-way replication.10. Oracle provides DB links to connect to a remote oracle server.


How many records and columns to store in MySQL database table and how many tables we can create?

In MySQL, the maximum number of rows and columns a table can have depends on the storage engine, but generally, a MySQL table can have up to 65,535 columns. The maximum number of rows is limited by the storage capacity of the database and the size of the rows. You can create a vast number of tables in a MySQL database, with the practical limit being around 4.3 billion tables per database, though performance may degrade with very high numbers.


What are the different engines of MySQL?

There are many different types of storage engine for MySQL, aswell as many custom versions. The most common ones used are MyISAM and InnoDB.MyISAMFalconMergeMemory (heap)FederatedArchiveCSVBlackholeClusterBerkeley DBEXAMPLEMariaInnoDBsolidDBNitroEDBInfobright (formerly Brighthouse)KickfireXtraDBIBM DB2One thing about MySQL is that it allows you to use a mixture of these engines within the same database, so depending on the table you can use the engine type that suits it best for your needs.


What can you use to create a database for customers in a supermarket?

Any database program like Access, Oracle or MySQL, amongst many others. You could also get one specially designed by programmers using their own systems.Any database program like Access, Oracle or MySQL, amongst many others. You could also get one specially designed by programmers using their own systems.Any database program like Access, Oracle or MySQL, amongst many others. You could also get one specially designed by programmers using their own systems.Any database program like Access, Oracle or MySQL, amongst many others. You could also get one specially designed by programmers using their own systems.Any database program like Access, Oracle or MySQL, amongst many others. You could also get one specially designed by programmers using their own systems.Any database program like Access, Oracle or MySQL, amongst many others. You could also get one specially designed by programmers using their own systems.Any database program like Access, Oracle or MySQL, amongst many others. You could also get one specially designed by programmers using their own systems.Any database program like Access, Oracle or MySQL, amongst many others. You could also get one specially designed by programmers using their own systems.Any database program like Access, Oracle or MySQL, amongst many others. You could also get one specially designed by programmers using their own systems.Any database program like Access, Oracle or MySQL, amongst many others. You could also get one specially designed by programmers using their own systems.Any database program like Access, Oracle or MySQL, amongst many others. You could also get one specially designed by programmers using their own systems.


Are there myths involving hades?

Yes they're many myths involving hades.


How many databases are available?

Oracle Teradata Sql Server Sybase DB2 BigTables Foxpro MySql.........


Name scalar fields and vector fields?

name as many scalar fields and vector fields as u can?