php - $q++; Hvad gør jeg forkert? - Udvikleren.dk - Programmering, webdesign og grafik

Tags: php

Bruger #14181 @ 16.09.08 22:18

Jeg sidder og kæmper med et autoscript, så jeg ikke får en alt for rodet side, men jeg kan simpelthen ikke få det til at gå op.

Dette er error'en når jeg loader siden:

Kode

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\wamp\www\nq\game\index.php on line 72

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\wamp\www\nq\game\index.php on line 72

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\wamp\www\nq\game\index.php on line 72

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\wamp\www\nq\game\index.php on line 72

og dette er min kode:

Kode

$wear_query = "SELECT * FROM wear WHERE ID='$_SESSION[id]'";
	$wear_result = mysql_query($wear_query)or die("MySQL fejl: " . mysql_error());
	$wear = mysql_fetch_array($wear_result);	

$q = 1;
$x = 1;

while($q<="4"){

$query1 = mysql_query("SELECT * FROM items WHERE ID='$wear[Head]'")or die("MySQL fejl: " . mysql_error());
	$query2 = mysql_query("SELECT * FROM items WHERE ID='$wear[Armor]'")or die("MySQL fejl: " . mysql_error());
$query3 = mysql_query("SELECT * FROM items WHERE ID='$wear[Rhand]'")or die("MySQL fejl: " . mysql_error());
	$query4 = mysql_query("SELECT * FROM items WHERE ID='$wear[Lhand]'")or die("MySQL fejl: " . mysql_error());

while($row = mysql_fetch_array($query[$x])){

if (($row[$x]['Prefix']) != "0" and($row['Prefix']) != "") { $prefix[$x] = '<br />'.$row['Prefix'].'<br />'; } else { $prefix[$x] = ""; }
if (($row['Mindam']) != "0" and ($row['Maxdam']) != "0" and ($row['Mindam']) != "" and ($row['Maxdam']) != "") { $dmg[$x] = '<br /><font color=#CC0000>Damage:</font> '.$row['Mindam'].'-'.$row['Maxdam']; } else { $dmg[$x] = ""; }
if (($row['Armor']) != "0" and ($row['Armor']) != "") { $armor[$x] = '<br /><font color=#CC0000>Armor:</font> +'.$row['Armor']; } else { $armor[$x] = ""; }
if (($row['Money']) != "0" and ($row['Money']) != "") { $money[$x] = '<br /><font color=#CC0000>Money:</font> +'.$row['Money'].' <font color=#0033CC>p/½h</font>'; } else { $money[$x] = ""; }
if (($row['Rage']) != "0" and ($row['Rage']) != "") { $rage[$x] = '<br /><font color=#CC0000>Rage:</font> +'.$row['Rage'].' <font color=#0033CC>p/½h</font>'; } else { $rage[$x] = ""; }
if (($row['Chakra']) != "0" and ($row['Chakra']) != "") { $chakra[$x] = '<br /><font color=#CC0000>Chakra:</font> +'.$row['Chakra']; } else { $chakra[$x] = ""; }
if (($row['Strenght']) != "0" and ($row['Strenght']) != "") { $strenght[$x] = '<br /><font color=#CC0000>Strenght:</font> +'.$row['Strenght']; } else { $strenght[$x] = ""; }
if (($row['Agility']) != "0" and ($row['Agility']) != "") { $agility[$x] = '<br /><font color=#CC0000>Agility:</font> +'.$row['Agility']; } else { $agility[$x] = ""; }
if (($row['Charisma']) != "0" and ($row['Charisma']) != "") { $charisma[$x] = '<br /><font color=#CC0000>Charisma:</font> +'.$row['Charisma']; } else { $charisma[$x] = ""; }
if (($row['Skill']) != "0" and ($row['Skill']) != "") { $skill[$x] = '<br /><font color=#CC0000>Bonus:</font> +'.$row['Skill']; } else { $skill[$x] = ""; }

$wornitem[$x] = '<img src="'.$row['Image'].'" 
title="'.$row['Name'].$prefix[$x].$armor[$x].$dmg[$x].$money[$x].$rage[$x].$chakra[$x].$strenght[$x].$agility[$x].$charisma[$x].$skill[$x].'
<br />
<br /><div id=unequip>(Click to unequip)</div>
" />';
}
	$q++;
	$x++;
}

På forhånd tak

Indlæg senest redigeret d. 16.09.2008 22:21 af Bruger #14181

Bruger #11328 @ 16.09.08 22:24

1.323

Det er her den er gal:

PHP kode

 while($row = mysql_fetch_array($query[$x]))

Det er ikke muligt at lave et sådant loop...
Ved faktisk ikke om det virker, men prøv:

PHP kode

 $query = array();
 $query[0] = mysql_query("SELECT * FROM items WHERE ID='$wear[Head]'")or die("MySQL fejl: " . mysql_error());
 $query[1] = mysql_query("SELECT * FROM items WHERE ID='$wear[Armor]'")or die("MySQL fejl: " . mysql_error());
 $query[2] = mysql_query("SELECT * FROM items WHERE ID='$wear[Rhand]'")or die("MySQL fejl: " . mysql_error());
 $query[3] = mysql_query("SELECT * FROM items WHERE ID='$wear[Lhand]'")or die("MySQL fejl: " . mysql_error());

Bruger #14181 @ 16.09.08 22:34

Tak for det hurtige svar. Jeg ved ikke om jeg har misforstået det.
Nu har jeg lavet det sådan:

Config

Kode

$q = 1;
$x = 1;

	$wear_query = "SELECT * FROM wear WHERE ID='$_SESSION[id]'";
	$wear_result = mysql_query($wear_query)or die("MySQL fejl: " . mysql_error());
	$wear = mysql_fetch_array($wear_result);

	$query = array();
	$query[1] = mysql_query("SELECT * FROM items WHERE ID='$wear[Head]'")or die("MySQL fejl: " . mysql_error());
	$query[2] = mysql_query("SELECT * FROM items WHERE ID='$wear[Armor]'")or die("MySQL fejl: " . mysql_error());
	$query[3] = mysql_query("SELECT * FROM items WHERE ID='$wear[Rhand]'")or die("MySQL fejl: " . mysql_error());
	$query[4] = mysql_query("SELECT * FROM items WHERE ID='$wear[Lhand]'")or die("MySQL fejl: " . mysql_error());
	
while($q<="4"){

if (($row[$x]['Præfix']) != "0" and($row['Præfix']) != "") { $prefix[$x] = '<br />'.$row['Præfix'].'<br />'; } else { $prefix[$x] = ""; }
if (($row['Mindam']) != "0" and ($row['Maxdam']) != "0" and ($row['Mindam']) != "" and ($row['Maxdam']) != "") { $dmg[$x] = '<br /><font color=#CC0000>Damage:</font> '.$row['Mindam'].'-'.$row['Maxdam']; } else { $dmg[$x] = ""; }
if (($row['Armor']) != "0" and ($row['Armor']) != "") { $armor[$x] = '<br /><font color=#CC0000>Armor:</font> +'.$row['Armor']; } else { $armor[$x] = ""; }
if (($row['Money']) != "0" and ($row['Money']) != "") { $money[$x] = '<br /><font color=#CC0000>Money:</font> +'.$row['Money'].' <font color=#0033CC>p/½h</font>'; } else { $money[$x] = ""; }
if (($row['Rage']) != "0" and ($row['Rage']) != "") { $rage[$x] = '<br /><font color=#CC0000>Rage:</font> +'.$row['Rage'].' <font color=#0033CC>p/½h</font>'; } else { $rage[$x] = ""; }
if (($row['Chakra']) != "0" and ($row['Chakra']) != "") { $chakra[$x] = '<br /><font color=#CC0000>Chakra:</font> +'.$row['Chakra']; } else { $chakra[$x] = ""; }
if (($row['Strenght']) != "0" and ($row['Strenght']) != "") { $strenght[$x] = '<br /><font color=#CC0000>Strenght:</font> +'.$row['Strenght']; } else { $strenght[$x] = ""; }
if (($row['Agility']) != "0" and ($row['Agility']) != "") { $agility[$x] = '<br /><font color=#CC0000>Agility:</font> +'.$row['Agility']; } else { $agility[$x] = ""; }
if (($row['Charisma']) != "0" and ($row['Charisma']) != "") { $charisma[$x] = '<br /><font color=#CC0000>Charisma:</font> +'.$row['Charisma']; } else { $charisma[$x] = ""; }
if (($row['Skill']) != "0" and ($row['Skill']) != "") { $skill[$x] = '<br /><font color=#CC0000>Bonus:</font> +'.$row['Skill']; } else { $skill[$x] = ""; }

$wornitem[$x] = '<img src="'.$row['Image'].'" 
title="'.$row['Name'].$prefix[$x].$armor[$x].$dmg[$x].$money[$x].$rage[$x].$chakra[$x].$strenght[$x].$agility[$x].$charisma[$x].$skill[$x].'
<br />
<br /><div id=unequip>(Click to unequip)</div>
" />';

	$q++;
	$x++;
}

Output

Kode

    	
        <div class="inv_head"><?php echo $wornitem1; ?></div>
        <div class="inv_rhand"><?php echo $wornitem3; ?></div>
        <div class="inv_armor"><?php echo $wornitem2; ?></div>
        <div class="inv_lhand"><?php echo $wornitem4; ?></div>

og nu er der ingen errors, men den viser ikke nogen billeder.

Indlæg senest redigeret d. 16.09.2008 22:38 af Bruger #14181

Bruger #11328 @ 16.09.08 22:44

1.323

Output skal se sådan ud:

Kode

<div class="inv_head"><?php echo $wornitem[0]; ?></div>
<div class="inv_rhand"><?php echo $wornitem[2]; ?></div>
<div class="inv_armor"><?php echo $wornitem[1]; ?></div>
<div class="inv_lhand"><?php echo $wornitem[3]; ?></div>

Bruger #14181 @ 16.09.08 22:47

~~Det kan jeg simpelthen ikke forstå - der kommer stadig intet.~~

Indlæg senest redigeret d. 16.09.2008 22:59 af Bruger #14181

Bruger #14181 @ 16.09.08 22:57

Nu forstår jeg det

jeg manglede jo stadig at få result ^^

Kode

$q = 0;
$x = 0;

	$wear_query = "SELECT * FROM wear WHERE ID='$_SESSION[id]'";
	$wear_result = mysql_query($wear_query)or die("MySQL fejl: " . mysql_error());
	$wear = mysql_fetch_array($wear_result);
	
	$query = array();
	$query[0] = mysql_query("SELECT * FROM items WHERE ID='$wear[Head]'")or die("MySQL fejl: " . mysql_error());
	$query[1] = mysql_query("SELECT * FROM items WHERE ID='$wear[Armor]'")or die("MySQL fejl: " . mysql_error());
	$query[2] = mysql_query("SELECT * FROM items WHERE ID='$wear[Rhand]'")or die("MySQL fejl: " . mysql_error());
	$query[3] = mysql_query("SELECT * FROM items WHERE ID='$wear[Lhand]'")or die("MySQL fejl: " . mysql_error());
	
while($q<="3"){

	$row = mysql_fetch_array($query[$q]);

if (($row['Præfix']) != "0" and($row['Præfix']) != "") { $prefix[$x] = '<br />'.$row['Præfix'].'<br />'; } else { $prefix[$x] = ""; }
if (($row['Mindam']) != "0" and ($row['Maxdam']) != "0" and ($row['Mindam']) != "" and ($row['Maxdam']) != "") { $dmg[$x] = '<br /><font color=#CC0000>Damage:</font> '.$row['Mindam'].'-'.$row['Maxdam']; } else { $dmg[$x] = ""; }
if (($row['Armor']) != "0" and ($row['Armor']) != "") { $armor[$x] = '<br /><font color=#CC0000>Armor:</font> +'.$row['Armor']; } else { $armor[$x] = ""; }
if (($row['Money']) != "0" and ($row['Money']) != "") { $money[$x] = '<br /><font color=#CC0000>Money:</font> +'.$row['Money'].' <font color=#0033CC>p/½h</font>'; } else { $money[$x] = ""; }
if (($row['Rage']) != "0" and ($row['Rage']) != "") { $rage[$x] = '<br /><font color=#CC0000>Rage:</font> +'.$row['Rage'].' <font color=#0033CC>p/½h</font>'; } else { $rage[$x] = ""; }
if (($row['Chakra']) != "0" and ($row['Chakra']) != "") { $chakra[$x] = '<br /><font color=#CC0000>Chakra:</font> +'.$row['Chakra']; } else { $chakra[$x] = ""; }
if (($row['Strenght']) != "0" and ($row['Strenght']) != "") { $strenght[$x] = '<br /><font color=#CC0000>Strenght:</font> +'.$row['Strenght']; } else { $strenght[$x] = ""; }
if (($row['Agility']) != "0" and ($row['Agility']) != "") { $agility[$x] = '<br /><font color=#CC0000>Agility:</font> +'.$row['Agility']; } else { $agility[$x] = ""; }
if (($row['Charisma']) != "0" and ($row['Charisma']) != "") { $charisma[$x] = '<br /><font color=#CC0000>Charisma:</font> +'.$row['Charisma']; } else { $charisma[$x] = ""; }
if (($row['Skill']) != "0" and ($row['Skill']) != "") { $skill[$x] = '<br /><font color=#CC0000>Bonus:</font> +'.$row['Skill']; } else { $skill[$x] = ""; }

$wornitem[$x] = '<img src="'.$row['Image'].'" 
title="'.$row['Name'].$prefix[$x].$armor[$x].$dmg[$x].$money[$x].$rage[$x].$chakra[$x].$strenght[$x].$agility[$x].$charisma[$x].$skill[$x].'
<br />
<br /><div id=unequip>(Click to unequip)</div>
" />';

	$q++;
	$x++;
}

Tusind tak for hjælpen

Jeg havde aldrig selv tænkt på at det skulle være array, hehe.

Sov rigtig godt.

Indlæg senest redigeret d. 16.09.2008 22:58 af Bruger #14181

Bruger #14181 @ 16.09.08 22:58

Og hvis jeg er smart behøver jeg jo kun at bruge enten q eller x. heh

Bruger #11328 @ 16.09.08 23:11

1.323

Det var så lidt..

Bruger #10216 @ 16.09.08 23:30

4.283

hvis du er endnu mere smart kan du jo skrive dine queries om til noget a la...

Kode

$list = array($wear['Head'],$wear['Armor'],$wear['Rhand'],$wear['Lhand']);
$query = mysql_query('SELECT * FROM table WHERE ID IN ('.implode(',',$list).')');
while($row = mysql_fetch_array($query)) {
...sir Do'alot...
}

Du laver allerede en masse tests på om det passer de rigtige steder, så hvorfor ikke gøre det lidt mere simpelt?!

Bruger #14181 @ 17.09.08 11:27

Mange tak Gnu og Jakob

I har været til stor hjælp.

$q++; Hvad gør jeg forkert?

Karma barometer (30 dage)

Modtaget

Givet

Favorit hos
Forum tråde
Artikler