jamesxg1 Posted June 23, 2009 Share Posted June 23, 2009 <?php session_start(); error_reporting(E_ALL); ini_set('display_errors', 1); include 'includes/Functions.php'; include 'includes/Connection.php'; CheckLogin(); $username = Clean($_SESSION['username']); $artistss = ceil(mysql_num_rows(mysql_query("SELECT `artist` FROM `music` WHERE username = '$username'"))); $albumss = ceil(mysql_num_rows(mysql_query("SELECT `album` FROM `music` WHERE username = '$username'"))); while(list($artists) = mysql_fetch_array($artistss)) { ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html> <head> <meta http-equiv="content-type" content="text/html; charset=iso-8859-1" /> <title>Curiously Green by Free CSS Templates</title> <meta name="keywords" content="" /> <meta name="description" content="" /> <link rel="stylesheet" type="text/css" href="includes/CSS/Account.css" /> </head> <body> <div id="header"> <div id="header_inner"> <h1><span>curiously.</span>green</h1> <div id="slogan">Gravida tortor lectus pellentesque.</div> </div> </div> <div id="main"> <div id="lcol"> <div id="menu"> <ul> <li><a href="#">Site Homepage<span></span></a></li> <li><a href="#">My Blog<span></span></a></li> <li><a href="#">Portfolio<span></span></a></li> <li><a href="#">About Me<span></span></a></li> <li><a href="#">Contact Me<span></span></a></li> </ul> </div> <div id="menu_end"></div> <div id="lcontent"> <h3 class="first">Artists<span> (<?php $artists['artist']; ?>)</span></h3> <ul class="divided"> <li class="first"><a href="#">Tincidunt aliquam</a></li> <li><a href="#">Cursus lorem nulla</a></li> <li><a href="#">Nunc ante elit</a></li> <li><a href="#">Tincidunt aliquam</a></li> <li><a href="#">Cursus sed tempus</a></li> </ul> <h3>Albums<span> (<?php print "$albums"; ?>)</span></h3> <p><a href="#">Sollicitudin sed</a> arcu et vivamus viverra. Nullam turpis. Vestibulum Nullam turpis vestibulum.</p> <div class="divider"></div> <p><a href="#">Vestibulum veroeros</a> sed arcu et vivamus viverra lorem ipsum dolor sit amet dolore nulla facilisi.</p> </div> </div> <div id="rcol"> <div id="rcontent"> <h1>Curiously<span>.Green</span></h1> <span id="slogan2">a plain and simple free design</span> <div class="box"> <div class="box_inner"> <div class="captioned_image"> <img src="images/pic.jpg" alt="Figure 1" /> <div>Fig 1. Obscure?</div> </div> <h2>Some obscure headline</h2> <p>Sollicitudin et, arcu. Vivamus viverra. Nullam turpis. Vestibulum sed etiam. Lorem ipsum sit amet dolore. Nulla facilisi. Sed tortor. Nullam turpis. Vestibulum sed etiam. Lorem ipsum sit amet dolore. Nulla facilisi. Sed tortor.</p> </div> </div> <h3>Obscure.<span>Explanations</span></h3> <p><strong>Curiously Green</strong>, a free, fully standards-compliant CSS template designed by <a href="http://www.nodethirtythree.com/">NodeThirtyThree</a> for <a href="http://www.freecsstemplates.org/">Free CSS Templates</a>, released for free under the <a href="http://creativecommons.org/licenses/by/2.5/">Creative Commons Attribution 2.5</a> license. The photos in this design are from <a href="http://www.pdphoto.org/">PDPhoto.org</a>. You're free to use this template for anything as long as you link back to <a href="http://www.freecsstemplates.org/">my site</a>. Enjoy </p> <p>Be sure to check out some of my commercial work over at <a href="http://www.4templates.com/?aff=n33">4Templates</a>.</p> <div class="divider"></div> <div class="summary">Lorem ipsum dolor sit amet nullam dignissim</div> <h3>Tincidunt.Sed.<span>Vestibulum</span></h3> <p> Quisque suscipit, quam vel aliquet tincidunt, eros nisi ultrices urna, a interdum est purus vitae leo. Pellentesque a lectus et tortor tincidunt <a href="#">dignissim etiam</a>. Aliquam erat volutpat. Quisque risus nunc, eleifend gravida, ullamcorper non, gravida ut, nulla. </p> </div> </div> </div> <div id="footer"> © 2006 My.Website. All rights reserved. Design by <a href="http://www.nodethirtythree.com/">NodeThirtyThree</a> + <a href="http://www.freecsstemplates.org/">Free CSS Templates</a>. </div> </body> </html> <?php } ?> Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\xampp\htdocs\Login\Account.php on line 19 Thats all im getting :S Link to comment https://forums.phpfreaks.com/topic/163382-solved-warning-mysql_fetch_array/ Share on other sites More sharing options...
flyhoney Posted June 23, 2009 Share Posted June 23, 2009 This returns an integer: $artistss = ceil(mysql_num_rows(mysql_query("SELECT `artist` FROM `music` WHERE username = '$username'"))); The first argument to mysql_fetch_array needs to be a resource. Link to comment https://forums.phpfreaks.com/topic/163382-solved-warning-mysql_fetch_array/#findComment-862059 Share on other sites More sharing options...
flyhoney Posted June 23, 2009 Share Posted June 23, 2009 <?php error_reporting(E_ALL); ini_set('display_errors', 1); session_start(); include 'includes/Functions.php'; include 'includes/Connection.php'; CheckLogin(); $username = Clean($_SESSION['username']); $query = "SELECT `artist` FROM `music` WHERE username = '$username'"; $result = mysql_query($query); $artists = array(); while ($row = mysql_fetch_array($result)) { $artists[] = $row['artist']; } $query = "SELECT `album` FROM `music` WHERE username = '$username'"; $result = mysql_query($query); $albums = array(); while ($row = mysql_fetch_array($result)) { $albums[] = $row['album']; } ?> Also note that you are printing an entire HTML document for each artist. Maybe you want to re approach that? Link to comment https://forums.phpfreaks.com/topic/163382-solved-warning-mysql_fetch_array/#findComment-862060 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.