PHP - Help Using Num Rows

  Can any one tell me whats the best ( actually error free ) which i can use to count the number of rows finally resulting after select command.

I use this ...

Code: [Select]
$sql = mysql_query("select * from usname where name1='$name1' and name2='$name2' and amm='$amm'");
$num=mysql_num_rows($sql);
echo $num;

But it always gives the same error.... and the error is..........

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\money\insert.php on line 20

where line 20 is...

Code: [Select]
$num=mysql_num_rows($sql);


- Pranshu Agrawal
pranshu.a.11@gmail.com

Hi guys,

I want to count the number of rows in a table and want to display them.
However that field stays empty. Everythign else works. What do I do wrong?

Code: [Select]
<?php
//$sql="SELECT * FROM $tbl_name ORDER BY user_id";
$sql="SELECT * from sp_users,sp_schools where sp_users.user_id=sp_schools.school_id";
$result=mysql_query($sql);
$num_rows=mysql_num_rows($result);
?>
<style type="text/css">
<!--
.style2 {font-weight: bold}
.style3 {
font-family: Arial, Helvetica, sans-serif;
color: #000000;
}
.style10 {font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; color: #000000; }
-->
</style>

<title>User overview</title><table width="779" border="0" align="left" cellpadding="0" cellspacing="1" bgcolor="#996600">
<tr>
<td width="777">
 
    <div align="left">
      <table width="779" border="1" cellspacing="0" cellpadding="3">
        <tr>
          <td colspan="6" align="center"><div align="center" class="style1 style3"><strong>SchoolPorta.com Users </strong></div></td>
          </tr>
        <tr>
          <td width="25" align="center"><span class="style2">No.</span></td>
          <td width="62" align="center"><span class="style2">Name</span></td>
          <td width="104" align="center"><span class="style2">Lastname</span></td>
          <td width="130" align="center"><span class="style2">Email</span></td>
          <td width="342" align="center"><span class="style2">school</span></td>
          <td width="64" align="center"><span class="style2">Update</span></td>
        </tr>
        <?php
while($rows=mysql_fetch_array($result)){
?>
        <tr>
          <td><span class="style10"><? echo $rows['num_rows']; ?></span></td>
          <td><span class="style10"><? echo $rows['user_first_name']; ?></span></td>
          <td><span class="style10"><? echo $rows['user_surname']; ?></span></td>
          <td><span class="style10"><a href="mailto:<?php echo $rows['user_login']; ?>"><?php echo $rows['user_login']; ?></a></span></td>
          <td><span class="style10"><? echo $rows['school_name']; ?></span></td>
          <td align="center"><a href="update.php?id=<? echo $rows['user_id']; ?>" class="style10">update</a></td>
        </tr>
        <?php
}
?>

Hi everyone!
I've been looking for a solution, but i just can't find it anywhere...

Ok, so the problem is:
i have a database which looks something like this:

user_id product_id score
14 . 235 . 79
23 . 235 . 32
53 . 665 . 21
14 . 235 . 90
5 . 675 . 45


This is step-by-step of what i need to do:

1. Select user - user_id =343

2. For user_id =343 select all products that he gave score to:
product_id = 43 - score = 99
product_id = 12 - score = 56
product_id = 68 - score = 32
product_id = 124 - score = 67

3. Find all users that voted for the same products e.g.:
for product_id = 43:
user_id = 125 voted 93 points,
user_id = 23 voted 56 points.


4. Calculate the difference between the score of user, so:
for product_id = 43:
user_id = 125 voted 93 points (99 - 93 =6 points of diff.)
user_id = 23 voted 56 points (99 - 56 =43 points of diff.)
return the results....


That's basically what i need to do. I still don't know the number of the users, or product, but it doesn't really matter - i just need to make it work.
Ok, hope someone can help!

Hi ,im face little problem in duplicating rows.

it's not easy task wht i need:

i got this rows right now

id----------position-------------A_Q_ID
1---------------1--------------------5-----
2---------------2--------------------5-----
3---------------3--------------------5-----
4---------------1--------------------6-----
5---------------2--------------------6-----
6---------------3--------------------6-----

what i need is to duplicat all the rows and have them inserted after the rows i allready have  like that:

id------------position-------------A_Q_ID
7-----------------1--------------------7-----
8-----------------2--------------------7-----
9-----------------3--------------------7-----
10---------------1--------------------8-----
11---------------2--------------------8-----
12---------------3--------------------8-----

i tryed few ways without success .
any idea how to do that please? i cannot get the logic on doing it

thanks

Im working on a site and particularly the photo gallery section. I want to display 9 images on 3 rows (3 per row).

And im stuck. Te only way i can get the images to show up not one on top of the other is by using a table. but how can i tell the table to only put 3 <td>'s then to <br>

Heres my code so far...
<?php
$sql_images = mysql_query("SELECT * FROM photos ORDER BY upload_date DESC LIMIT 9");

while($row = mysql_fetch_array($sql_images)){

$photo_id = $row["id"];
$location = $row["location"];

$display_pics .= '
<td width="125px">
<a href="image.php?id='. $album_id .'" class="black"><img src="images/uploads/thumbs/' . $location . '" /></a> 
</td>';
}
?>

Then to display it ...
Code: [Select]
    <table width="top" cellpadding="10" cellspacing="20">
        <tr>
            <?php echo $display_pics; ?>
            </tr>
        </table>

My goal is to do it as simple as possible!

Can anyone help?

If you don't think tables are the way to go im open to any suggestions.

I've thought about <divs> but then the images show up one on top of the other and not beside each other.

By the way all the images are a max of 100px heigh and 100px wide

Thanks for any help or suggestions!

How can I get the next four and previous four rows?

Here is what I have and it isn't working at at all.
$q1 = Mysql::query("SELECT id, file, dir FROM photos WHERE id > $id AND album = '$al' ORDER BY id ASC LIMIT 4");
$q2 = Mysql::query("SELECT id, file, dir FROM photos WHERE id < $id AND album = '$al' ORDER BY id DESC LIMIT 4");

I am trying make my code display different things depending on how many rows are returned

This is my code
Code: [Select]
<?PHP
    include 'db_con.php';
 $month = date("n");
$day = date("j");
$sql = mysql_query("SELECT * FROM table WHERE month = $month AND day = $day ")or die(mysql_error());
while($row = mysql_fetch_array($sql) )

if (mysql_fetch_array($row  = 1 ) ) ///THIS IS AN ERROR BUT IF ONE ROW RETURNED THEN THIS
{
echo "ONE THING";
}
elseif (mysql_fetch_array($row >1 )  )////IF > 1 ROW RETURNED THAN THIS
{
echo"TWO THINGS";
}
else {
echo "SOMETHING ELSE ";
}   


?>

I have tried several variations of the above code but cannot get it to work.

Thanks for any help anyone can give me.

Hi

I have this code to echo th econtents of a table, which contains 100 rows.

I want to be able to display all 100 rows.

The problem is that it displays 99 (it excludes the first).

I've tried to backtrack to reconstruct the code to find out where the error is but no joy.

Any ideas?

Thanks in advance!

Code: [Select]

....

// get all entries from table

$sql = "SELECT * FROM 100words ORDER BY word_id";
$result = mysqli_query($dbc, $sql);
$r = mysqli_fetch_row($result);

//print table entries to screen in columns

echo '<div id="container">';

// results presented in html table 5 columns, 20 rows per page
echo '<div id="outerbox">';
                echo '<div class="innerbox">';
echo '<table class="centerresults" border="0">'  . "\n";
echo '<td>'; 
 
$i = 0;   
$max_columns = 5;   

    while ($list = mysqli_fetch_assoc($result)) { 

      extract($list);

// open row if counter is zero       

if($i == 0)
         
echo '<tr>' . "\n";
         
echo '<td width="150px"><a href="word.php?w=' .

$list['word'] . '">' .

$list['word'] . "</a></td> \n "; 
         

// increment counter - if counter = max columns, reset counter and close row       

if(++$i == $max_columns) {
         
echo '</td>' . "\n";
         
$i=0; 
     
}  // END if(++$i == $max_columns) {

} // END while (!empty($myArray)) {

//} END while ($list = mysql_fetch_array($result)) {


 //END if($i < $max_columns) {     

echo '</tr>' . "\n";

echo '</table>' . "\n";

   echo '</div>';
   
      echo '</div>';

I Have a page that will display the data that was posted into a database, but it displays it like this:

id logoname locationname address city state zip phone website etc...

I want to display the data like this:

id <--- this will repeat records 4 columns across
logoname
locationname
etc...

id <--- this will repeat records 4 columns across
logoname
locationname
etc...

and then repeat similar for the rest of the data.
 Sorry Im a n00b, but trying. Here is the current code:

<?php

include "config.php";
$con = mysql_connect("$dbhost","$dbusr","$dbpass");
if (!$con)
   {
   die('Could not connect:'. mysql_error());
   }
mysql_select_db("$dbname",$con);

$q="select * from venues";
$result=mysql_query($q);

if (!$result) {
    die("Query to show fields from table failed");
}

$fields_num = mysql_num_fields($result);

echo "<table border='0'><tr>";
for($i=0; $i<$fields_num; $i++)
{
    $field = mysql_fetch_field($result);
    echo "<td></td>";
}
echo "</tr>\n";

while($row = mysql_fetch_row($result))
{
    echo "<tr>";

   
    foreach($row as $cell)
        echo "<td>$cell</td>";

    echo "</tr>\n";
}
mysql_free_result($result);
?>

Help would be greatly appreciated and an explanation so that I don't have to keep asking 

Hi guys I have a problem. I limit the displayed rows by 10 (which works) and then a link saying "next" or "previous"
The link itself works, but the site always just displays teh first 10 data entries.
What do I do wrong?
Thank you!

Code: [Select]
<?php
$host="****"; // Host name
$username="****"; // Mysql username
$password="****"; // Mysql password
$db_name="****"; // Database name
$tbl_name="sp_users"; // Table name

// Connect to server and select database.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");

//$sql="SELECT * FROM $tbl_name ORDER BY user_id";
$sql="SELECT * from sp_users,sp_schools where sp_users.user_id=sp_schools.school_id ORDER BY school_name LIMIT 0, 10";
$result=mysql_query($sql);
$num_rows=mysql_num_rows($result);
?>
<?PHP
//check if the starting row variable was passed in the URL or not
if (!isset($_GET['startrow']) or !is_numeric($_GET['startrow'])) {
  //we give the value of the starting row to 0 because nothing was found in URL
  $startrow = 0;
//otherwise we take the value from the URL
} else {
  $startrow = (int)$_GET['startrow'];
}
?>
<?PHP
//this part goes after the checking of the $_GET var
$fetch = mysql_query("SELECT * FROM sp_users,sp_schools where sp_users.user_id=sp_schools.school_id LIMIT $startrow, 10")or
die(mysql_error());
?>
<style type="text/css">
<!--
.style2 {font-weight: bold}
.style3 {
font-family: Arial, Helvetica, sans-serif;
color: #000000;
}
.style10 {font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; color: #000000; }
#Layer1 {
position:absolute;
left:803px;
top:36px;
width:65px;
height:28px;
z-index:1;
}
#Layer2 {
position:absolute;
left:707px;
top:19px;
width:143px;
height:39px;
z-index:1;
}
#Layer3 {
position:absolute;
left:247px;
top:463px;
width:175px;
height:53px;
z-index:2;
}
-->
</style>

<title>User overview</title>
</html>
<div id="Layer2">
  <form action="<?= $_SERVER['PHP_SELF'] ?>" method="post">
<input type="hidden" name="foo" value="<?= $foo ?>" />
<input type="submit" name="submit" value="Refresh" />
</form></div>
<div id="Layer3"><?PHP
//now this is the link..
echo '<a href="'.$_SERVER['PHP_SELF'].'?startrow='.($startrow+10).'">Next</a>';
?>
<?PHP
$prev = $startrow - 10;

//only print a "Previous" link if a "Next" was clicked
if ($prev >= 0)
    echo '<a href="'.$_SERVER['PHP_SELF'].'?startrow='.$prev.'">Previous</a>';
?></div>
<table width="779" border="0" align="left" cellpadding="0" cellspacing="1" bgcolor="#996600">
<tr>
<td width="777">
 
    <div align="left">
      <table width="779" border="1" cellspacing="0" cellpadding="3">
        <tr>
          <td colspan="6" align="center"><div align="center" class="style1 style3"><strong>SchoolPorta.com Users / Total: <?php echo $num_rows ?></strong></div></td>
          </tr>
        <tr>
          <td width="342" align="center"><span class="style2">school</span></td>
          <td width="62" align="center"><span class="style2">Name</span></td>
          <td width="104" align="center"><span class="style2">Lastname</span></td>
          <td width="130" align="center"><span class="style2">Email</span></td>
      <td width="64" align="center"><span class="style2">Update</span></td>
        </tr>
        <?php
while($rows=mysql_fetch_array($result)){
?>
        <tr>
          <td><span class="style10"><? echo $rows['school_name']; ?></span></td>
  <td><span class="style10"><? echo $rows['user_first_name']; ?></span></td>
          <td><span class="style10"><? echo $rows['user_surname']; ?></span></td>
          <td><span class="style10"><a href="mailto:<?php echo $rows['user_login']; ?>"><?php echo $rows['user_login']; ?></a></span></td>
          <td align="center"><a href="update.php?id=<? echo $rows['user_id']; ?>" class="style10">update</a></td>
        </tr>
        <?php
}
?>
      </table>
    </div></td>
</tr>
</table>

<div align="left">
  <p>&nbsp;   </p>
  <p>&nbsp;</p>
  <p>&nbsp;</p>
  <p>
    <?php
mysql_close();
?>
  </p>
</div>

i have table in my db that has rows of dates, for example...

      id       |                 date                  |                created           |        display     |     group         |
      1        |     2011-05-24 00:00:00     |  2011-05-24 20:00:00    |          Y           |         20          |
      2        |     2011-05-24 00:00:00     |  2011-05-24 22:00:00    |          N           |         20         |
      3        |     2011-05-26 00:00:00     |  2011-05-26 22:00:00    |          N           |         20          |
      4        |     2011-05-27 00:00:00     |  2011-05-26 22:00:00    |          N           |         20          |
      5        |     2011-05-27 00:00:00     |  2011-05-30 22:00:00    |          N           |         20          |

Now i'm trying to make sure that each group has no duplicate dates. If they do delete all but the newest. So in this case, after the code ran, it would have deleted row 2 and row 5 because they both have duplicate dates and they're the oldest of those particular duplicates. I posted in the PHP board and not the MySQL board because it's the logic i can't figure out. I believe array_unique() would come in handy but i can't wrap my head around how to use it to do what i want.

...I'm Australian, hence the 'u' in coloured, in case you're wondering! 

Basically I'd like to create a table of results for a running race that has rows shaded pink if the participant is female.

I think my problem is something to do with not declaring 'sex' as a variable, but I'm not really sure how to do this. My code is below. Any advice would be much appreciated.

Code: [Select]
<?php
$dbcnx = @mysql_connect('localhost', 'MYUSERNAME', 'MYPASSWORD);
if (!$dbcnx) {
  exit('<p>Unable to connect to the ' .
      'database server at this time.</p>');
}

if (!@mysql_select_db('coast2ko_test')) {
  exit('<p>Unable to locate the results ' .
      'database at this time.</p>');
}

$sql = mysql_query("SELECT * FROM result_single ORDER BY place ASC");

echo "<table border='1' CELLPADDING=5 STYLE='font-size:13px'>";
echo "<tr> <td><H3>First name</h3></td> <td><H3>Lastname</H3></td>  <td><H3>Sex</H3></td>  <td><H3>Time</H3></td><td><H3>Place</H3></td></tr>";
// keeps getting the next row until there are no more to get
while ($row = mysql_fetch_array($sql)) {



// Print out the contents of each row into a table



  if ($sex=="F")
echo "<tr bgcolor='#FF99FF'>";
  else
echo "<tr>";

echo "<tr bgcolor='#FF99FF'>";
echo "<td>";
echo $row['firstname'];
echo "</td><td>";
echo $row['lastname'];
echo "</td><td>";
echo $row['sex'];
echo "</td><td>";
echo $row['time'];
echo "</td><td>";
echo $row['place'];
echo "</td></tr>";


}
echo "</table>";



?>

Hi,

having stopped php for a while, i'm a little rusty, can someone help me - instead of the results returning in a row by row format, can i have it so it returns column by column?
so, rather than result 1 being first, then 2 underneath then 3 etc etc, can i have result 2 next to result 1?

heres my code

$result = mysql_query("SELECT * FROM members ORDER BY member_id DESC")   
or die(mysql_error());  

echo "<table border='2'>";
echo "<tr> <th></th> <th></th> <th></th> </tr>";
// keeps getting the next row until there are no more to get
while($row = mysql_fetch_array( $result )) {
// Print out the contents of each row into a table
echo "<tr><td>"; 
echo $row[printf('<img src="%s" height="96" width="128" style="border: 0" />', $row['profile_pic_short'])];
echo "</td><td>"; 
echo "<a href=\"PHP-Login/advert_pages/view_profile_specific.php?seller_name=$row[login]\">". $row['login'] . "</a>";
echo "</td></tr>"; 

} 

echo "</table>";
?>


all help appreciated

thanks

can someone please give me some guidance on how to do this please
I am wanting to create a status updating type application on my site
and i have this idea in my head

i want it to retrive and print the last 3 posts (max ids) made by the user
if someone could give me some example code please and i can hopefully work from that.
Thanks
James

Hey everyone,

I just started using php a couple days ago and I've run into an issue. This is also my first time coding anything, so even basic things are a bit difficult for me.

What I have posted below is an html form with 5 fields. After typing values (into as many or as little fields as you want) and hitting "submit", the form will echo how many values you've entered (integers, strings, whatever, it'll add one to the counter as long as the value isn't negative). The values will also remain in the form after being submitted (this is intentional, and actually what I'm after). This is working just fine. What I'm trying to add is an option to switch between a maximum of either 5 fields (rows), or 10 fields. The code below manages to do this, and actually return the correct result after hitting "submit". Unfortunately, it won't "hold onto" any of the values I enter past the original 5 fields. So for example if I switch to 10 fields, and enter "1, 2, 3, 4, 5, 6, and 7" into the fields, it will display "7 items", however, only the "1, 2, 3, 4, and 5" will remain in their respective fields, while the "6, and 7" will disappear.

So, two questions. First, how do I fix that? And second, what's actually the best way for me to do what I'm trying to do? Because I'm guessing I've come up with a pretty bad newbie hacked-together way of doing it

(Note: This is all part of a larger function that has proper data sanitation and etc, I just cut it down for this example.)

Thanks!

Edit: I'd also like to add I ideally want this entirely in php (no javascript) for compatibility reasons.


<?php // rows.php

$a[1] = $a[2] = $a[3] = $a[4] = $a[5] = $a[6] = $a[7] = $a[8] = $a[9] = $a[10] = $rows = $r10 = '';
$r5 = 'checked';

  if ($r5 == 'checked')
  {
  $start_r_cnt = 1;
  $end_r_cnt = 5;
  }

  if (isset($_POST['rows']))
  {
    $check_radio = $_POST['rows'];
    if ($check_radio == 'r10')

{

  $r10 = 'checked';

  $start_r_cnt = 1;

  $end_r_cnt = 10;

  

    for ($i=6;$i<=$end_r_cnt;$i++)

    {

      $value = "$a[$i]";

      $rows = $rows.'<tr><td><input type="text" name="a'.$i.'" size="10" value="'.$value.'"/></td></tr>';
             $value = $a[$i];

    }

}
  }
  
  $count_a = 0;
  $value_error = '';

  for($i=1;$i<=$end_r_cnt;$i++)
  {
    if(isset($_POST['a'.$i]))
    {
      $a[$i] = $_POST['a'.$i]; 

  if($a[$i] == '') {
        $a[$i] == '';
      }

  elseif($a[$i] >= 0) {
        $count_a++;
      }

  elseif ($a[$i] < 0) {

$value_error = 'One of the entered values is negative. Please fix this before continuing.';

  }
    }
  }

echo <<<_END

<html>
<form method="post" action="rows.php">
<table cellpadding="5">
<b>Number of Rows:</b><br>
<input type="submit" name="rows" value="Change" style="width: 70px" /> [5]<input type='radio' name='rows' value='r5' $r5/>[10]<input type='radio' name='rows' value='r10' $r10/>
<tr><td><center>Data A</center></td></tr>
<tr><td><input type="text" name="a1" size="10" value='$a[1]'/></td></tr>
<tr><td><input type="text" name="a2" size="10" value='$a[2]'/></td></tr>
<tr><td><input type="text" name="a3" size="10" value='$a[3]'/></td></tr>
<tr><td><input type="text" name="a4" size="10" value='$a[4]'/></td></tr>
<tr><td><input type="text" name="a5" size="10" value='$a[5]'/></td></tr>
$rows
<tr><td><center><input type="submit" value="Submit" style="width: 80px" /></center></td></tr>
</table>
<b>$count_a</b> items are present.
<b>$value_error</b>
</html>
_END;
?>