Thread: Handling a large number of inserts on a mysql table
View Single Post
Old 07-16-2009, 02:25 PM   #5 (permalink)
JaoudeStudios
The Acquainted
 
JaoudeStudios's Avatar
 
Join Date: Jul 2009
Location: Surrey
Posts: 105
Thanks: 1
JaoudeStudios is on a distinguished road
Default
Quote:
Originally Posted by Village Idiot View Post
...but PHP does not allow more than one command per mysql_query. I consider this one of PHPs weak points since as you get more advanced with SQL...
You should not be using the MySQL library in PHP anymore, but the MySQLi which has been out for a while. PHP.net has deprecated MySQL api and insists on using the newer version MySQLi (stands for MySQL improved) - it has great benefits in speed, security etc...

MySQLi also allows multiple queries and much more. However note there is a downside to multiple queries, it is more vulnerable! So make sure you protect your queries well!
JaoudeStudios is offline   		Reply With Quote