PHP - Problem With Rows

For some reason my php script only echo's out one data, I can't seem to find the problem.

<?


$show = mysql_query("SELECT * FROM video_comments WHERE pageid='$vidid'");

$numrows = mysql_num_rows($show);

if ($numrows > 0){

while($row = mysql_fetch_array($show)){
    $userid = $row["userid"];
    $username = $row["username"];
   $comment = $row["comment"];
   $date = $row["date"];
    $date = strftime("%b %d, %Y", strtotime($date));
}

echo"

<table style='background-color:#FFF; border:#999 1px solid; border-top:none;' cellpadding='5' width='100%'>
<tr>
<td width='90%' valign='top' style='line-height:1.5em;'><span class='greenColor textsize10'>$date<a href='profile.php?id=$userid'> $username </a> said:</span><br />
$comment</td>
</tr>
</tr></table>


";


}
else
  echo"<center><font face='arial' size='2'><p>This video has no comments.</font></center>";

?>

I got this code at the top:
Code: [Select]
<?php
require_once("configuration.php");
$uid = $_GET['uid']; ?>

And another main one:
Code: [Select]
<?php
if(isset($_GET['uid']))
{ 

$d = "";
$query = mysql_query("SELECT `username`,`level`,`email,`,`alevel`,`tester` FROM `users` WHERE `id`='$uid'");
if(!mysql_num_rows($query))
echo "No user.";
while($d = mysql_fetch_assoc($query))
{
?>
&nbsp <b>Username:</b> <?php echo $d['username']; ?> <br />
&nbsp <b>Level:</b> <?php echo $d['level']; ?> <br />
&nbsp <b>Email:</b> <?php echo $d['email']; ?> <br />
&nbsp <b>Admin level:</b> <?php echo $d['alevel']; ?> <br />
&nbsp <b>Tester:</b> <?php echo $d['tester']; ?>
<?php } } ?>
</font>
</div>
</center>


Now I get this error:
Code: [Select]
Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\learning\viewuser.php on line 20
No user.
Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\learning\viewuser.php on line 22
How can I fix it?

Hi,

I've created an admin page that lists all piano sheet music that has been uploaded to my server. It displays the ID (autoincrement), Userid (user that uploaded sheet), Artist (name of the band) and Title (name of the song).
On this page, I can either delete the row completely, or click on "Uploaded", which just sets it's uploaded column to 'yes'.
Now I'm working on a button called "Uploaded All". This will set the uploaded column on all of the rows on the page to 'yes'. This way I don't have to click Uploaded for every single row. (view attached image if you are unsure what I am talking about)

I'm not getting any errors when clicking "Uploaded All". When clicking it, it doesn't update the table rows in the database as it should. Take a look at my code:

Tip: The area of the code that I'm currently having troubles with is here

  $usersids[$i] = $row['id'];
  $i++;
  }

  echo "
  <tr>
    <td align='center' width='10' colspan='6'><a href='uploadedsheets.php?confirm=all'>Uploaded All</a></td>
  </tr>";
 
  if ($confirm=="all")
{
    $i = 0;
    while($row = mysql_fetch_array($result))
  {
    mysql_query('UPDATE `upload` SET `uploaded`="yes" WHERE id = ' . $usersids[$i]);
    $i++;
  }
    echo "<SCRIPT language='JavaScript'><!--
  window.location='uploadedsheets.php';//-->
</SCRIPT>";
}

Inside the above code after the if statement, I tried echoing out $usersids, and it showed correctly. So the problem must be in the update query or the array.


Full Code:

<?php
session_start();

include_once('../inc/connect.php');
include_once('../inc/admin.php');

if(!isset($_SESSION['sort_counter']))
{$_SESSION['sort_counter'] = 1;}

if(($_SESSION['sort_counter']%2) == 0){ //test even value
  $sortcount = "DESC";
}else{ //odd value
  $sortcount = "";
}

$result = mysql_query("SELECT * FROM upload WHERE uploaded='no' ORDER BY id");

$unconfirmedquery = mysql_query("SELECT uploaded FROM upload WHERE uploaded='no'");
$unconfirmedcount = mysql_num_rows($unconfirmedquery);

$confirmedquery = mysql_query("SELECT uploaded FROM upload WHERE uploaded='yes'");
$confirmedcount = mysql_num_rows($confirmedquery);

$sort = $_GET['sort'];
$delete = $_GET['delete'];
$confirm = $_GET['confirm'];

/////////////////////////////////

if ($sort=='id'){

    // $result = mysql_query("SELECT * FROM users ORDER BY id"); 
$result = mysql_query("SELECT * FROM upload WHERE uploaded='no' ORDER BY id $sortcount");
$_SESSION['sort_counter'] = $_SESSION['sort_counter'] + 1; //increment after every run
 
}
if ($sort=='userid'){

    // $result = mysql_query("SELECT * FROM users ORDER BY username");
$result = mysql_query("SELECT * FROM upload WHERE uploaded='no' ORDER BY userid $sortcount");
$_SESSION['sort_counter'] = $_SESSION['sort_counter'] + 1; //increment after every run
}
if ($sort=='artist'){

    // $result = mysql_query("SELECT * FROM users ORDER BY email");
$result = mysql_query("SELECT * FROM upload WHERE uploaded='no' ORDER BY artist $sortcount");
$_SESSION['sort_counter'] = $_SESSION['sort_counter'] + 1; //increment after every run
}
if ($sort=='title'){

    // $result = mysql_query("SELECT * FROM users ORDER BY email");
$result = mysql_query("SELECT * FROM upload WHERE uploaded='no' ORDER BY title $sortcount");
$_SESSION['sort_counter'] = $_SESSION['sort_counter'] + 1; //increment after every run
}
if ($sort=='file'){

    // $result = mysql_query("SELECT * FROM users ORDER BY email");
$result = mysql_query("SELECT * FROM upload WHERE uploaded='no' ORDER BY file $sortcount");
$_SESSION['sort_counter'] = $_SESSION['sort_counter'] + 1; //increment after every run
}

/// FIX THIS AREA
if ($confirm=="true" && isset($_GET['id']))
{
    mysql_query('UPDATE `upload` SET `uploaded`="yes" WHERE id = ' . (int)$_GET['id']);
    echo "<SCRIPT language='JavaScript'><!--
  window.location='uploadedsheets.php';//-->
</SCRIPT>";
} 
if ($delete=="true" && isset($_GET['id']))
{
    mysql_query('DELETE FROM `upload` WHERE id = ' . (int)$_GET['id']);   
    echo "<SCRIPT language='JavaScript'><!--
  window.location='uploadedsheets.php';//-->
</SCRIPT>";
} 
if ($delete=="false" && isset($_GET['id']))
{
    echo "<SCRIPT language='JavaScript'><!--
  window.location='uploadedsheets.php';//-->
</SCRIPT>";
} 

/////////////////////////////////

echo "
<html>
<head>
<title>Uploaded Sheets</title>
<style>
a:link{
text-decoration: none;
color: #519904;
}
a:visited{
text-decoration: none;
color: #519904;
}
a:hover{
text-decoration: none;
color: #4296ce;
}
#headcont{
width: 900px;
height: 20px;
margin-left: auto;
margin-right: auto;
}
#unconfirmed{
    width: 450px;
    text-align: center;
    float: left;
    background-color: #cccccc;
}
#confirmed{
    width: 450px;
    text-align: center;
    float: left;
    background-color: #72A4D2;
}
</style>
</head>
<body>
";

include_once('../inc/navadmin.php');

echo "<div style='font-size: 28px; text-align: center;'>Uploaded Sheets</div>
<div id='headcont'>
<div id='unconfirmed'>Not Uploaded Sheets: ".$unconfirmedcount."</div>
<div id='confirmed'>Uploaded Sheets: ".$confirmedcount."</div>
</div><br />
<table border='1' align='center'>
<tr>
<th bgcolor='#cccccc'><a href='uploadedsheets.php?sort=id'>ID</a></th>
<th bgcolor='#cccccc'><a href='uploadedsheets.php?sort=userid'>UserID</a></th>
<th bgcolor='#cccccc'><a href='uploadedsheets.php?sort=artist'>Artist</a></th>
<th bgcolor='#cccccc'><a href='uploadedsheets.php?sort=title'>Title</a></th>
<th bgcolor='#cccccc'><a href='uploadedsheets.php'>Uploaded</a></th>
<th bgcolor='#cccccc'><a href='uploadedsheets.php'>Delete</a></th>
</tr>";
echo "<script type='text/javascript'>
function show_delete()
{
var r=confirm('Delete?');
if (r==true)
{
// Delete
return true;
}
else
{
// Don't Delete
return false;
}
}
";

echo "
function show_undelete()
{
var r=confirm('Undelete?');
if (r==true)
{
// Undelete
return true;
}
else
{
// Don't Undelete
return false;
}
}
</script>";

$usersids = "";
$i = 0;

while($row = mysql_fetch_array($result))
  {
 
  //
  $active = $row['active'];
  $color = "#ffffff";
  $deleted = "Delete";
  if ($active=='no'){
  $color = "#f43636";
  $deleted = "Undelete";
  $active = "false";
  $alert = "show_undelete";
  }
  else{
  $active = "true";
  $alert = "show_delete";
  }
  //
 
  echo "<tr>";
  echo "<td align='center' width='40' bgcolor='$color'>" .$row['id']. "</td>";
  echo "<td align='center' width='40'>" .$row['userid']. "</td>";
  echo "<td align='center' width='230'>".ucwords($row['artist'])."</td>";
  echo "<td align='center' width='230'>".ucwords($row['title'])."</td>";
  echo "<td align='center' width='10'><a href='uploadedsheets.php?confirm=true&id=" .$row['id'] . "'>Uploaded</a></td>";
  echo "<td align='center' width='10'><a href='uploadedsheets.php?delete=$active&id=" .$row['id']. "' onclick='return $alert()'>$deleted</a></td>";
  echo "</tr>";
  $usersids[$i] = $row['id'];
  $i++;
  }

  echo "
    $usersids[0]
  <tr>
    <td align='center' width='10' colspan='6'><a href='uploadedsheets.php?confirm=all'>Uploaded All</a></td>
  </tr>";
 
  if ($confirm=="all")
{
    $i = 0;
    while($row = mysql_fetch_array($result))
  {
    mysql_query('UPDATE `upload` SET `uploaded`="yes" WHERE id = ' . $usersids[$i]);
    $i++;
  }
    echo "<SCRIPT language='JavaScript'><!--
  window.location='uploadedsheets.php';//-->
</SCRIPT>";
} 
 
echo "</table>";



// Footer
echo "
</body>
</html>
";

?>

i have created my own code of custom shopping cart   i have viewcart.php working great, now when i want to insert the orders from viewcart.php with list of like 5 items, how can i insert 5 names of products into my database 1 row   example   names are 1. jean 2. mond 3. richard 4. gwen   list above is the results of my while loop, now i want to insert those names to my database column[order_productname] so that i can identity what products are paid by my clients.   i tried fetch_array but if i assign variable to fetch array result, it only shows 1 which is "jean"   i wish this is possible   dforth  

hello all,
i want to display each row from mysql table in a different page using this code:
Code: [Select]
<?
require_once('config.php');
//Connect to mysql server
$link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);
if(!$link) {
die("can't connect: " . mysql_error());
}

$db = mysql_select_db(DB_DATABASE);
if(!$db) {
die("can't select database");
}
mysql_query("SET NAMES 'hebrew'");
//mysql_set_charset('utf8',$link);

if (isset($_GET["page"])) { $page  = $_GET["page"]; } else { $page=1; };
  $start_from = $page-1;

$qry='SELECT * FROM ordering limit 0, 1';
$result = mysql_query($qry);
while($row = mysql_fetch_array($result)){

echo     "<div dir='rtl' charset='utf8'><h2>"," hover cam: ",$row['hover_camera'],
"<br> stills: ",$row['stills'],
"<br> video_photographers: ",$row['video_photographers'],
"<br> increase: ",$row['increase'],
"<br> video_edit: ",$row['video_edit'],
"<br> digital_album: ",$row['digital_album'],
"<br> photo_album: ",$row['photo_album'],
"<br> small_digital_album: ",$row['small_digital_album'],
"<br> video_clip: ",$row['video_clip'],
"<br> magnets: ",$row['magnets'],
"<br> comments: ",$row['comments'],
"<br> date: ",$row['date'],
"<br><br></h2></div>";

}
$sql = "SELECT COUNT(userid) FROM ordering";
$result = mysql_query($sql,$link);
$row2 = mysql_fetch_row($result);
$total_records = $row2[0];
$total_pages = $total_records ;
 
for ($i=1; $i<=$total_pages; $i++) {
            echo "<a href='table.php?page=".$i."'>".$i."</a> ";
};

?>
this is the table:
Code: [Select]
CREATE TABLE IF NOT EXISTS `ordering` (
`userid` int(11) unsigned NOT NULL AUTO_INCREMENT,
`hover_camera` varchar(10) DEFAULT NULL,
`stills` int(5) NOT NULL,
`video_photographers` int(5) NOT NULL,
`increase` int(5) NOT NULL,
`video_edit` varchar(10) NOT NULL,
`digital_album` varchar(10) DEFAULT NULL,
`photo_album` varchar(10) DEFAULT NULL,
`small_digital_album` varchar(20) DEFAULT NULL,
`video_clip` varchar(10) DEFAULT NULL,
`magnets` int(10) NOT NULL,
`comments` text NOT NULL,
`date` date NOT NULL,
PRIMARY KEY (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;
the problem is that only the first row is displayed no matter which page i choose
and i want each page to display the row assigned to it (page 15 = row 15 etc...)
any suggestions?