mySQL query's

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
psychotomus
Forum Contributor
Posts: 487
Joined: Fri Jul 11, 2003 1:59 am

mySQL query's

Post by psychotomus »

is this 1 query or 5?

Code: Select all

//create arcade cats
mysql_query("INSERT INTO `arcade_cats` (`forum_name`, `name`, `desc1`, `icon`, `last_game`, `last_player`, `total_played`, `last_played`) VALUES 
('$forum_name', 'Action', 'Action Games', 'action.jpg', '', '', 0, 0),
('$forum_name', 'Driving', 'Driving Games', 'driving.gif', '', '', 0, 0),
('$forum_name', 'Puzzles', 'Puzzle Games.', 'puzzles.jpg', '', '', 0, 0),
('$forum_name', 'Shooting', 'Shooting Games.', 'shooting.gif', '', '', 0, 0),
('$forum_name', 'Sports', 'Sports Games.', 'sports.jpg', '', '', 0, 0)") or die(mysql_error());
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

One extended insert.
Post Reply