PHP - Different Coloured Rows

Hi ive got this code which echos out all the rows from an SQL table.

while($row = mysql_fetch_array($result))
  {
  echo "<tr>";
  echo "<td>" . $row['subject1'] . "</td>";
  echo "<td>" . $row['subject2'] . "</td>";
  echo "<td>" . $row['subject3'] . "</td>";
  echo "<td>" . $row['subject4'] . "</td>";
  echo "<td>" . $row['email'] . "</td>";
  echo "</tr>";
  }
echo "</table>";


All i want to do is add all the 4 subject together and echo it out. simple but not sure how to do it. any ideas please?

Thanks Matt

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

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

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 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 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 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>

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

Hi all,

I am sure I knew how to do this 

Basically I want to pull the field followers which is an int for each row and add them together
Code: [Select]
$query = "SELECT followers FROM user_profile";
$result = mysql_query($query) or die(mysql_error());
while($row = mysql_fetch_array($result))

$i = 0;
{
$total = $row['followers'];
$a = $i + $total;
}

echo $a;
$a is returning zero though

Cheers

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;
?>

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!

On my site, I currently have a page that lists my team's fixtures: http://www.cfrclunj.co.uk/fixtures.php

As can be seen, in between each separate month there is a row of blank, grey cells.

I am now updating the site so that it takes all information from a database (for easier update). On my test page (at bottom) I have recreated the fixtures table using my db: http://www.cfrclunj.co.uk/db_test.php

What I am wondering is if there is any way to get the grey monthly separater row into my table. Could this be done by inserting a row of data into the db table that uses an if statement to change it's appearance? Or could I somehow use MYSQL/PHP to make it put a row in for each separate month?

I have to admit my PHP and MYSQL skills are still at a very basic level, and so any help would be great!

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 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, im creating a script for a website that will list products, i have the basic construct which lists the products from the database but it lists then vertically, i have set the width of each 'product' to 200px so i could have around 3 colums and many rows.

can anybody advise how i would make them run horizontally aswell as vertically?
my code below:

<?php
include_once("include/globals.php");

?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
<link href="styles/stylesheet.css" rel="stylesheet" type="text/css" />
</head>

<body>
<div id="main">

    <?php 
        
        //Get database Results
        $result = mysql_query("SELECT * FROM Products WHERE is_active = 1") or die(mysql_error());
        
        //keeps getting the next row until no more records
        while($row = mysql_fetch_array($result))    {
        
        //echo results ($result)
        echo '<div id="holder">';
        echo '<div class="title">' . $row['Name'] . '</div>';
        //insert image here
        echo '<div class="image">';
        echo '<a href="product_detail.php?id="><img src="' . $row['image'] . '" width="100" alt="" border="0"></a>';
        echo '</div>';
        
        echo '<div class="tag_line">';
        echo $row['Tag_Line'];
        echo '</div>';
        
        
        echo '<div class="price">Now Only: &pound;';
        echo $row['Website_Price'];
        echo '</div>';
        
        echo '<div class="prod-footer">';
        echo "<a href=\"product_detail.php?id={$row['ID']}\">
            more info
            </a></li>";    
        echo '</div>';
        echo '</div>';
        
        
        
        }
    
    ?>    </div>
    
    </body>
</html>