Reply to thread

Message

<blockquote data-quote="Sab" data-source="post: 168590" data-attributes="member: 3878">I get this error in my housekeeping:&nbsp;Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\app\tpl\skins\Custom-Habbo\hk\jobs.html on line 43&nbsp;This is the link 43 in HK:&nbsp;&nbsp;[CODE] $getMySQL = mysql_query(&quot;SELECT * FROM `jobs` &quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $alternate = 1;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; while ($data = mysql_fetch_array($getMySQL)) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if($alternate == 0) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $alternate = 1;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo &quot;&lt;tr style=\&quot;background-color: #4FD9EF;\&quot;&gt;&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo &quot;&lt;td style=\&quot;width: 12.5%;background-color: #4FD9EF;\&quot;&gt;&quot; . $data['username'] . &quot;&lt;/td&gt;&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo &quot;&lt;td style=\&quot;width: 12.5%;background-color: #4FD9EF;\&quot;&gt;&quot; . $data['job'] . &quot;&lt;/td&gt;&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo &quot;&lt;td style=\&quot;width: 37.5%;background-color: #4FD9EF;\&quot;&gt;&quot; . $data['why'] . &quot;&lt;/td&gt;&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo &quot;&lt;td style=\&quot;width: 20%;background-color: #4FD9EF;\&quot;&gt;&quot; . $data['experience'] . &quot;&lt;/td&gt;&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo &quot;&lt;td style=\&quot;width: 30%;background-color: #4FD9EF;\&quot;&gt;&quot; . $data['age'] .&nbsp; &quot;&lt;/td&gt;&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo &quot;&lt;td style=\&quot;width: 30%;background-color: #4FD9EF;\&quot;&gt;&quot; . $data['other'] .&nbsp; &quot;&lt;/td&gt;&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo &quot;&lt;/tr&gt;&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; else if($alternate == 1) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $alternate = 0;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo &quot;&lt;tr style=\&quot;background-color: #2DB8CD;\&quot;&gt;&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo &quot;&lt;td style=\&quot;width: 12.5%;background-color: #4FD9EF;\&quot;&gt;&quot; . $data['username'] . &quot;&lt;/td&gt;&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo &quot;&lt;td style=\&quot;width: 12.5%;background-color: #4FD9EF;\&quot;&gt;&quot; . $data['job'] . &quot;&lt;/td&gt;&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo &quot;&lt;td style=\&quot;width: 37.5%;background-color: #4FD9EF;\&quot;&gt;&quot; . $data['why'] . &quot;&lt;/td&gt;&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo &quot;&lt;td style=\&quot;width: 20%;background-color: #4FD9EF;\&quot;&gt;&quot; . $data['experience'] . &quot;&lt;/td&gt;&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo &quot;&lt;td style=\&quot;width: 30%;background-color: #4FD9EF;\&quot;&gt;&quot; . $data['age'] .&nbsp; &quot;&lt;/td&gt;&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo &quot;&lt;td style=\&quot;width: 30%;background-color: #4FD9EF;\&quot;&gt;&quot; . $data['other'] .&nbsp; &quot;&lt;/td&gt;&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo &quot;&lt;/tr&gt;&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ?&gt; &lt;/table&gt; &lt;/p&gt;&lt;/div&gt; &lt;/div&gt;[/CODE]&nbsp;&nbsp;It's all 1 line, just looks like that on here. (I'm not so good at coding)</blockquote>

[QUOTE="Sab, post: 168590, member: 3878"] I get this error in my housekeeping: [B][COLOR=#000000][FONT=Open Sans][SIZE=16px]Warning[/SIZE][/FONT][/COLOR][/B][SIZE=16px][FONT=Open Sans][COLOR=#000000]: mysql_fetch_array() expects parameter 1 to be resource, boolean given in [/COLOR][/FONT][/SIZE][B][COLOR=#000000][FONT=Open Sans][SIZE=16px]C:\xampp\htdocs\app\tpl\skins\Custom-Habbo\hk\jobs.html[/SIZE][/FONT][/COLOR][/B][SIZE=16px][FONT=Open Sans][COLOR=#000000] on line [/COLOR][/FONT][/SIZE][B][COLOR=#000000][FONT=Open Sans][SIZE=16px]43[/SIZE][/FONT][/COLOR][/B] This is the link 43 in HK: [CODE] $getMySQL = mysql_query("SELECT * FROM `jobs` "); $alternate = 1; while ($data = mysql_fetch_array($getMySQL)) { if($alternate == 0) { $alternate = 1; echo "<tr style=\"background-color: #4FD9EF;\">"; echo "<td style=\"width: 12.5%;background-color: #4FD9EF;\">" . $data['username'] . "</td>"; echo "<td style=\"width: 12.5%;background-color: #4FD9EF;\">" . $data['job'] . "</td>"; echo "<td style=\"width: 37.5%;background-color: #4FD9EF;\">" . $data['why'] . "</td>"; echo "<td style=\"width: 20%;background-color: #4FD9EF;\">" . $data['experience'] . "</td>"; echo "<td style=\"width: 30%;background-color: #4FD9EF;\">" . $data['age'] . "</td>"; echo "<td style=\"width: 30%;background-color: #4FD9EF;\">" . $data['other'] . "</td>"; echo "</tr>"; } else if($alternate == 1) { $alternate = 0; echo "<tr style=\"background-color: #2DB8CD;\">"; echo "<td style=\"width: 12.5%;background-color: #4FD9EF;\">" . $data['username'] . "</td>"; echo "<td style=\"width: 12.5%;background-color: #4FD9EF;\">" . $data['job'] . "</td>"; echo "<td style=\"width: 37.5%;background-color: #4FD9EF;\">" . $data['why'] . "</td>"; echo "<td style=\"width: 20%;background-color: #4FD9EF;\">" . $data['experience'] . "</td>"; echo "<td style=\"width: 30%;background-color: #4FD9EF;\">" . $data['age'] . "</td>"; echo "<td style=\"width: 30%;background-color: #4FD9EF;\">" . $data['other'] . "</td>"; echo "</tr>"; } } ?> </table> </div> </div> [/CODE] It's all 1 line, just looks like that on here. (I'm not so good at coding) [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members