Smallest Guns
An index of the smallest guns, primarily current production and useful for self defense.
About |
Submit New Entry |
Forum |
Links
//print("order=$order
\n");
$order = $_GET[order];
$db = mysql_connect("localhost","root","mysqlf00") or die("Could not connect to db.");
if (mysql_select_db("smallestguns",$db))
{
// print("Database opened successfully.
\n");
} else {
printf("Error opening database: %s.
\n", mysql_error());
}
if ($order)
{
$orderby = "ORDER BY $order,pract/size DESC";
} else {
$orderby = "ORDER BY pract/size DESC";
}
//$result = mysql_query("SELECT * FROM gun $orderby",$db);
#$result = mysql_query("SELECT gun.* FROM gun, caliber WHERE gun.caliber = caliber.name ORDER BY caliber.id",$db);
$sql = "SELECT gun.* FROM gun, caliber WHERE gun.caliber = caliber.name $orderby";
//print "$sql
\n";
$result = mysql_query($sql,$db);
if($myrow = mysql_fetch_array($result))
{
print "
Lethality |
Volume |
Lethality / Volume |
Photo |
Manufacturer |
Model |
Caliber |
Capacity |
Type |
Action |
Length |
Height |
Width |
Weight |
\n";
$count=0;
do
{
foreach(array("size","length","height","width","weight") as $key)
{
if ($myrow[$key] == 999999)
{
$myrow[$key] = "";
}
}
if (! $myrow[img] == '') {
$myrow[img] = "
";
}
if (! $myrow[imgurl] == '') {
$myrow[img] = "$myrow[img]";
}
$count++;
$type = $count % 2;
if ($type == 1) {
echo("");
} else {
echo("
");
}
#echo("
$myrow[size] | $myrow[make] | $myrow[model] | $myrow[caliber] | $myrow[capacity] | $myrow[type] | $myrow[action] | $myrow[length]\" | $myrow[height]\" | $myrow[width]\" | $myrow[weight]oz | $type |
\n");
if ($myrow[size]) {
$leathvol = round($myrow[pract]/$myrow[size],2);
} else {
$leathvol = '';
}
echo("$myrow[pract] | $myrow[size] | $leathvol | $myrow[img] | $myrow[make] | $myrow[model] | $myrow[caliber] | $myrow[capacity] | $myrow[type] | $myrow[action] | $myrow[length]\" | $myrow[height]\" | $myrow[width]\" | $myrow[weight]oz | \n");
} while($myrow = mysql_fetch_array($result));
echo("
\n");
} else {
printf("No records found: %s.
\n", mysql_error());
}
print "$count entries.
\n";
?>
Note: The Rohrbaugh R9 and R9s are designed to withstand firing fewer than 150 rounds.
Lethality = log (capacity) * power.
Power =
12ga | 14 |
20ga | 13 |
.44Mag | 12.1 |
.357Mag | 12 |
10mm | 11.7 |
.44 Special | 11.3 |
.45ACP | 11 |
.410 | 10.5 |
.40S&W | 9.9 |
9mm | 9 |
.38 Special | 8 |
.380ACP | 7 |
.32Mag | 6 |
.32ACP | 5 |
.25ACP | 3.5 |
.22Mag | 3 |
.22LR | 2 |
.22 short | 1 |
Gun Recommendations
Chaos Reigns Guns Home
Chaos Reigns Home
Wed Oct 28 06:40:20 EDT 2009