Quicker way of doing this...

[Mutley]

I have repetitive code, that selects data from an SQL table, then gives it a variable however it takes about 40 lines to do 5 different fields, here is my code:

 

 

		$result = mysql_query("SELECT `damage` FROM `own` WHERE user_id = '$player1' AND slot = 'car' AND loadout = '1' LIMIT 1");
	while($row = mysql_fetch_array( $result ))
    	{
	$damage1_car = $row['damage'];
	}
	$result = mysql_query("SELECT `damage` FROM `own` WHERE user_id = '$player1' AND slot = '1' AND loadout = '1' LIMIT 1");
	while($row = mysql_fetch_array( $result ))
    	{
	$damage1_1 = $row['damage'];
	}
	$result = mysql_query("SELECT `damage` FROM `own` WHERE user_id = '$player1' AND slot = '2' AND loadout = '1' LIMIT 1");
	while($row = mysql_fetch_array( $result ))
    	{
	$damage1_2 = $row['damage'];
	}
	$result = mysql_query("SELECT `damage` FROM `own` WHERE user_id = '$player1' AND slot = '3' AND loadout = '1' LIMIT 1");
	while($row = mysql_fetch_array( $result ))
    	{
	$damage1_3 = $row['damage'];
	}
	$result = mysql_query("SELECT `damage` FROM `own` WHERE user_id = '$player1' AND slot = '4' AND loadout = '1' LIMIT 1");
	while($row = mysql_fetch_array( $result ))
    	{
	$damage1_4 = $row['damage'];
	}
	$result = mysql_query("SELECT `damage` FROM `own` WHERE user_id = '$player1' AND slot = '5' AND loadout = '1' LIMIT 1");
	while($row = mysql_fetch_array( $result ))
    	{
	$damage1_5 = $row['damage'];
	}

 

 

I'm not sure what to do, I was thinking a function but not sure how to do this, as you can see only the variable and the "slot" changes, so not much.

 

Any help would be appreciated.

[per1os]

<?php
$result = mysql_query("SELECT `damage`, `slot` FROM `own` WHERE user_id = '$player1' AND loadout = '1' ORDER BY `slot`;");
while($row = mysql_fetch_array( $result )) {
   $damage[$row['slot']] = $row;
}
?>

 

Maybe ???

[valtido]

i would of used a loop like

for

or while

 

www.w3schools.com/php

 

should have some info there lool

[Wildbug]

Is the "LIMIT 1" necessary?  Are there multiple values otherwise?

 

If not:

SELECT `damage` FROM `own` WHERE user_id = '$player1' AND slot IN ('car','1','2','3','4','5') AND loadout = '1'

[Mutley]

Is the "LIMIT 1" necessary?  Are there multiple values otherwise?

 

If not:

SELECT `damage` FROM `own` WHERE user_id = '$player1' AND slot IN ('car','1','2','3','4','5') AND loadout = '1'

 

Nope it's not necessary anymore.

 

How would I use that, what does the "IN" statement do?

[Wildbug]

Instead of having lots of OR statments, the expression "slot IN ('car','1','2','3','4','5')" is true if the value in "slot" is any of those in the parenthetical list.  If you need to know which one matched, return it in the SELECT list, too.