[PHP] Mysql error

[Ronaldino]

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in D:\xampp\htdocs\aac\guilds.php on line 804

It showing when someone is invited to the guild.

Here is around 804 line in guilds.php;

						echo '</table></center>';
						echo '<br /><br />';
						$query = mysql_query('SELECT `id` FROM `guild_invites` WHERE `guild_id` = '. $guild['id'] .'');
						if(mysql_num_rows($query) != 0) {
							echo '
							<center>
							<h2>Invited Players:</h2>
							<table style="text-align: left; width: 15%;" border="1" cellpadding="0" cellspacing="2">
							<tbody>
							<tr>
							<td style="width: 10%;">Name</td>
							</tr>
							</tbody>';
							while($row = mysql_fetch_array($query)){
								echo '
								<tr>
								<td><center><a href="info.php?act=players&char='. userFromID($row['player_id']) .'">'. userFromID($row['player_id']) .'</a></center></td>
								</tr>
								';
							}
							echo '</table><center><a href="guilds.php?act=join">Join</a></center>';
						}
					}
				}

804 line is:

if(mysql_num_rows($query) != 0) {

hjalp

 

[kinglewey]

i duno if this will help Im not that great with SQL but try getting a newer version of XAMPP if you have an old 1 :S

 

[Ronaldino]

i duno if this will help Im not that great with SQL but try getting a newer version of XAMPP if you have an old 1 :S

No, there was problem with MySQL query, any way thank you.


##
Fixed atm, close thread.

 

[Snel pUppie]

Thread closed.