PHP & MySQL Wierd Happening

[lpxxfaintxx]

Hello,

I am making a tutorial CMS, but I'm facing a very wierd problem. I have a 'view category section' where I can view tutorials in the category. But, when I add a tutorial, within the category, the most recent tutorial added is not there. For example, lets say I added tutorial 1. In the category section, tutorial 1 is not there. Then Bob comes, and adds tutorial 2. Now tutorial 1 is showing, but 2 is not.

This is what I have so far:

$subcat = $_GET['sub'];
 $sqls = "SELECT * FROM `tutorials` WHERE `subcatid` = '$subcat' and `catid` = '$idf' ORDER BY `name`";
$results=mysql_query($sqls);
$rowss=mysql_fetch_array($results);
$catids = $rowss['catid'];
$subcatids = $rowss['subcatid'];
  $id = $rowss['id'];
	     $author = $rowss['author'];
	$description = $rowss['description'];
	       $name = $rowss['name'];
	   $imageurl = $rowss['imageurl'];
	        $url = $rowss['url'];
	$totalviewed = $rowss['hits'];
echo '<div id="bluebar">'.$subcatids.' tutorials.</div>
    <br />';

  echo "
    <div class='tutorial'>
      <div class='tutorialtitle'> <span class='style1'><a href='".$url."'>".$name."</a></span><br />
        Author: <a href='#'>".$author."</a> <br> Rating: <span class='style3'>Coming Soon</span></div>
      <img src='".$imageurl."' width='44' height='43' alt='' /><br />".$description."<br />
      <span class='style2'>22nd March 2006 <span class='style3'><a href='#'>Report Tutorial</a></span> <span class='style3'>Total Views: <strong>".$totalviewed."</strong></span> <span class='style3'>Categorgy: <a href='viewcat.php?id=".$catid."'><strong>".$cat3."</strong></a></span></span></div>
 ";

What'd I do wrong?

[thorpe]

You need to loop through your results if you want to display more than one. The general syntax is...

$result = mysql_query($sql);
if ($result) {
  while ($row = mysql_fetch_assoc($result)) {
    echo $row['foo'];
  }
}

As for the order they appear in... your ordering them alphabetically by name so...

[lpxxfaintxx]

Thanks, it works... kinda. The problem is, the most recently put tutorial is not appearing...

At http://informedia.ws/projects/tuts/viewcat.php?act=subcat&id=1&sub=Banana there is 1 tutorial in that section, but it's not showing.

$subcat = $_GET['sub'];
 $sqls = "SELECT * FROM `tutorials` WHERE `subcatid` = '$subcat' and `catid` = '$idf' ORDER BY `name`";
$results=mysql_query($sqls);
$rowss=mysql_fetch_array($results);
$catids = $rowss['catid'];
$subcatids = $rowss['subcatid'];
echo '<div id="bluebar">'.$subcatids.' tutorials.</div>
    <br />';
 $result = mysql_query($sql);
if ($result) {
  while ($rowss = mysql_fetch_assoc($results)) {
	     $author = $rowss['author'];
	$description = $rowss['description'];
	       $name = $rowss['name'];
	   $imageurl = $rowss['imageurl'];
	        $url = $rowss['url'];
	$totalviewed = $rowss['hits'];
  echo "
    <div class='tutorial'>
      <div class='tutorialtitle'> <span class='style1'><a href='".$url."'>".$name."</a></span><br />
        Author: <a href='#'>".$author."</a> <br> Rating: <span class='style3'>Coming Soon</span></div>
      <img src='".$imageurl."' width='44' height='43' alt='' /><br />".$description."<br />
      <span class='style2'>22nd March 2006 <span class='style3'><a href='#'>Report Tutorial</a></span> <span class='style3'>Total Views: <strong>".$totalviewed."</strong></span> <span class='style3'>Categorgy: <a href='viewcat.php?id=".$catid."'><strong>".$cat3."</strong></a></span></span></div>
 ";
   }
} 

[Houdini]

You are querying for just one record through the url either add more key/values or possibly post them. but if you only ask for and query for one record that is what you will get. Or am I missing something here?
Maybe if you changed your query to

$sqls = "SELECT * FROM tutorials";

you might see a few more rows of data.

[rane500]

$subcat = $_GET['sub'];
 $sqls = "SELECT * FROM `tutorials` WHERE `subcatid` = '$subcat' and `catid` = '$idf' ORDER BY `name`";
$results=mysql_query($sqls);
$rowss=mysql_fetch_array($results);

You're fetching the first row before you enter your loop. When you enter the loop, the fetch executes again and the first row is gone before you can print it.

[lpxxfaintxx]

Then how will I prevent from doing that?

[rane500]

Wait, I just realized I misread something. Where is $sql defined? I see $sqls, but no $sql...

[thorpe]

Then how will I prevent from doing that?

Follow the example I posted and DONT call mysql_fetch_array() outside of the loop.