Need Help Plz

bradmasterx

I get the error:
Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, boolean given in

<!-- start rightbar -->
	<div id="rightbar" class="sidebar">
		<ul>
		  <li></li><?php 
		  $execute="SELECT * FROM `news` ORDER BY `date` DESC LIMIT 0,3";
		  $rownews = mysqli_query($cxn, $execute);
		  while($row = mysqli_fetch_assoc($rownews)){
		  ?>
			<li>Title: <?php echo $row['title']; ?></li>
		    <li><a href="#">Date:  <?php echo $row['date']; ?></a></li>
		    <li>Message: <?php echo $row['message']; ?></li>
	      <li></li><?php } ?><center>
		  <li><a href="http://www.freedomain.co.nr/cheap_web_hosting.php" target="_blank"><img src="http://smuasma.ne.com.ru/ch.gif" alt="Best Web Hosting Cheapest Plans" width="88" height="31" border="0" /></a></center></li>
		</ul>
	</div>
	<!-- end rightbar -->
	<div style="clear: both;">&nbsp;</div>
</div>
<!-- end page -->
<hr />
<div id="footer">
	<p><?php echo $footer; ?> <?php $user=$_SESSION['user']; if($user != ""){ echo "You are logged in as $user"; } ?></p>
</div>

Please help me,

chasiv

I believe you have your arguments backwards on this line:

$rownews = mysqli_query($cxn, $execute);

shouldn't it be :

$rownews = mysqli_query($execute, $cxn);

I'm assuming $cxn is your connection name.

bradmasterx

still not workin

laserlight

chasiv does not know the mysqli interface. I don't know it either, but I checked the PHP manual and:

$rownews = mysqli_query($cxn, $execute);

is correct if $cxn is your connection link resource.

The problem is that mysqli_query() returns a result resource if the query succeeded. It returns false if it failed, e.g., because your SQL statement is syntactically incorrect, refers to nonexistent table or column names, etc.

Consequently, $rownews could contain a false value, so you have to check that it does not contain false before using it with mysqli_fetch_assoc().

chasiv

sorry.. I 'assumed' it was the same as mysql_query without looking...