PHP - Help Display One Result For Each Keywords_keyword

Hi, I would like to ask, how to display the while loop result 3 per row with the following code below:
  $startDate = strtotime($datefrom);  

Okay so, I'm adding a reply feature to my text-board, and I'm wondering how I can select a single result from the DB
I've tried this
$board = mysql_real_escape_string($_GET['board']);
$thread = mysql_real_escape_string($_GET['thread']);

$result = mysql_query("SELECT subject, name, id, timestamp, body FROM $board LIMIT $thread,$thread");
while ($row = mysql_fetch_array($result, MYSQL_NUM)) {
    printf("<div id='html1' style='background-color:#F0E0D6;border:solid 1px #800000;font-family:arial; font-size: 12px; padding:2px; margin:2px;'><font color='#CC1105'>%s </font><font color='#117743'>%s</font> <font color='#800000'>Post # %s - %s<br />%s<br /></div>", $row[0], $row[1], $row[2], $row[3], $row[4], $row[5], $row[6]);
mysql_free_result($result);
}
?>
Kinda works but if I pu
?thread=56
then it would show thread 57, which in this example does not exist.

Hi there (I'm new at PHP/mysql)

I am busy with a project - I maneged to load info into the mysql database and display the results BUT - now I need some Help

I can display the result - now I want to have the ability to click on the result and it must open a new page with only the selected result information?

 

I have a database that contains results of fantasy football games.  I have a query that returns the results of the games team X played against the other teams in the league.  The query works perfect in the database.

Results are
Quote

Opponent Name:    America Enforcers
Wins    Losses    Draws
1                1                0
Last Game:    Week 2 of 2011: 416.6 - 369.8



the query and the php code cycle thru each team that team X has played and brings up team X's record and the results of the last game played.

My problem is that the code stops one team short.  So Team X played teams A, B, C, D, E
but the code only returns teams A, B, C, D
E is left off. 

I can't for the life of me figure out what silly mistake I made.

Code: [Select]
<?php 
include_once('../other/functions.php');
$con = mysql_connect($hostname, $username, $password) 
OR DIE ('Unable to connect to database! Please try again later.');
$db = mysql_select_db($dbname, $con);
$thing = $_GET['thing'];
$query = "select selected.teamname AS selected_team, selected_score.score AS selected_score, week.week, year, home_id, ". 
"target_score.score as target_score, target.teamname as targetname, week.ID ".
"from owners as selected ".
"JOIN game_scores AS selected_score ON selected.owner_id = selected_score.team_id ".
"JOIN game_setup ON game_setup.game_id = selected_score.game_id ".
"JOIN game_scores AS target_score ON target_score.game_id = game_setup.game_id AND target_score.team_id != selected_score.team_id ".
"JOIN owners AS target ON target.owner_id = target_score.team_id ".
"JOIN week ON week.week = game_setup.week ".
"WHERE selected.owner_id = $thing ".
"and target.active = 1 ".
"GROUP BY target.teamname, year, week.ID ";
$result = mysql_query($query);
$row = mysql_fetch_array($result);
$result1 = mysql_query($query);
$row1 = mysql_fetch_array($result1);
if (!$result) {
    die('Invalid query: ' . mysql_error());
}
$wins=0;
$losses=0;
$draws=0;
$last_target = false;
echo '<h2>' . $row1['selected_team'] . ' vs. Active Teams</h2>';
while ($row = mysql_fetch_assoc($result))
{
    if ($last_target['targetname'] != $row['targetname'])
    {
        if ($last_target)
        {
            printf('
<table border="1" width="600">
<tr>
<th>Opponent Name:</th>
<th colspan="2">%s</th>
</tr>
<tr>
<th>Wins</th>
<th>Losses</th>
<th>Draws</th>
</tr>
<tr>
<td align="center">%d</td>
<td align="center">%d</td>
<td align="center">%d</td>
</tr>
<tr>
<th>Last Game:</th>
<td colspan="2">%s of %s: %.1f - %.1f</td>
</tr>
</table><br/>',
$last_target['targetname'],
                $wins,
                $losses,
                $draws,
                $last_target['week'],
                $last_target['year'],
                $last_target['selected_score'],
                $last_target['target_score']
);    
        }
        $wins = $losses = $draws = 0;
    }
    if ($row['selected_score'] < $row['target_score'])
        ++$losses;
    elseif ($row['selected_score'] == $row['target_score'])
        ++$draws;
    else
        ++$wins;
    
    $last_target = $row;
}

?>



Any ideas on how to make the magic elvish be good???
Thank you for your time.

I am seeking to learn more about the noted subject, how to use PHP to allow a user to enter search terms and search a database.  I have experimented with this with little results save for errors.  Please see code listed below:

search.php
<?
//// filename = search.php
<form method="post" action="result.php3">
<select name="metode" size="1">
<option value="row_name1">metode1</option>
<option value="row_name2">metode2</option>
</select>
<input type="text" name="search" size="25">
<input type="submit" value="Begin Searching!!">
</form>
?> 

results.php
//// filename = result.php3
<?
$hostname = "mysql7.000webhost.com"; // Usually localhost.
$username = "a4542527_root"; // If you have no username, leave this space empty.
$password = "*******"; // The same applies here.
$usertable = "people"; // This is the table you made.
$dbName = "a4542527_test1"; // This is the main database you connect to.
MYSQL_CONNECT($hostname, $username, $password) OR DIE("Unable to connect to database");
@mysql_select_db( "$dbName") or die( "Unable to select database");
?>
<?
//error message (not found message)
$XX = "No Record Found";
$query = mysql_query("SELECT * FROM $usertable WHERE $metode LIKE '%$search%' LIMIT 0, 30 ");
while ($row = mysql_fetch_array($query))
{
$variable1=$row["row_name1"];
$variable2=$row["row_name2"];
$variable3=$row["row_name3"];
print ("this is for $variable1, and this print the variable2 end so on...");
}

//below this is the function for no record!!
if (!$variable1)
{
print ("$XX");
}
//end
?>

Upon viewing search.php I receive the error message:
Parse error: syntax error, unexpected '<' in /home/a4542527/public_html/search.php on line 3

I believe I may be missing something and am a bit lost.
Thank-you in in advance for any help or suggestions.
~Matty

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=342917.0

Hello,

First time posting here, my MYSQL version is 5.1.52 and I have a created a search function to find a user record and if the name is typed correctly the name and details are displayed on the search page, but if the name is typed incorrectly nothing is appearing. Basically I would like to be able to say if no record found and redirect back to the previous page.

Code:
Code: [Select]
<?php
add = $_POST['add'];
        
// Database details
$host=""; // Host name
$username=""; // Mysql username
$password=""; // Mysql password
$db_name=""; // Database name
$tbl_name="Rewards"; // Table name

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

//Add query
$sql = mysql_query("UPDATE Rewards SET Rewards = (Rewards + 10) WHERE Name '%$add%'");



// Database details
$host=""; // Host name
$username=""; // Mysql username
$password=""; // Mysql password
$db_name=""; // Database name
$tbl_name="UserList"; // Table name

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


//Update Total Points query
$sql = mysql_query("UPDATE UserList SET TotalPoints = (TotalPoints + 10) WHERE Name '%$add%'");



// Database details
$host=""; // Host name
$username=""; // Mysql username
$password=""; // Mysql password
$db_name=""; // Database name
$tbl_name="UserList"; // Table name

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



//Search Query
$sql = mysql_query("SELECT * FROM UserList WHERE Name '%$add%'");  

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

echo '<br/><img src="images/line1.jpg" alt="" width="200" height="2" />';

echo '<br/> Username: '.$row['Username']; 

echo '<br/>';  

echo '<br/><img src="images/line2.jpg" alt="" width="200" height="2" />';

echo '<br/> Name: '.$row['Name'];   

echo '<br/> Year Group: '.$row['YearGroup'];

echo '<br/> Form Class: '.$row['FormClass'];

echo '<br/>';

echo '<br/><img src="images/line3.jpg" alt="" width="200" height="2" />';

}  


// Database details
$host=""; // Host name
$username=""; // Mysql username
$password=""; // Mysql password
$db_name=""; // Database name
$tbl_name="Rewards"; // Table name

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

$sql = mysql_query("SELECT * FROM Rewards WHERE Name '%$add%'");  

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

echo '<br/> Rewards: '.$row['Rewards'];

}  



// Database details
$host=""; // Host name
$username=""; // Mysql username
$password=""; // Mysql password
$db_name=""; // Database name
$tbl_name="Sanctions"; // Table name

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

$sql = mysql_query("SELECT * FROM Sanctions WHERE Name '%$add%'");  

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

echo '<br/> Sanctions: '.$row['Sanctions'];

}  


// Database details
$host=""; // Host name
$username=""; // Mysql username
$password=""; // Mysql password
$db_name=""; // Database name
$tbl_name="UserList"; // Table name

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


$sql = mysql_query("SELECT * FROM UserList WHERE Name '%$add%'");  

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

echo '<br/> Total Points: '.$row['TotalPoints'];

echo '<br/>';

echo '<br/><img src="images/line4.jpg" alt="" width="200" height="2" />';   

}  
Any help would be greatly appreciated.

Many Thanks

P Quinn

MOD EDIT: [code] . . . [/code] tags added.

Hi,

I'm using a form which contains many select boxes.
The select boxes looks like this:

            <select name="locatie" id="locatie">
                <option value="" selected>-----</option>
                <?php
                    require_once ('config.php');
                    $query = "select ID, locatie from locatie";
                    $result = mysql_query ($query);
                    while($row = mysql_fetch_array($result)){
                        extract($row);
                        echo '<option value="'.$ID.'">'.$locatie.'</option>';
                    }
                ?>
            </select>

            <select name="prijsVan" id="prijsVan">
                <option value="" selected>-----</option>
                <?php
                    $query = "select ID, prijs from prijs";
                    $result = mysql_query ($query);
                    while($row = mysql_fetch_array($result)){
                        extract($row);
                        echo '<option value="'.$ID.'">&euro; '.$prijs.'</option>';
                    }
                ?>
            </select>

           <select name="prijsTot" id="prijsTot">
             <option value="" selected>-----</option>
         <?php
                            $query = "select ID, prijs from prijs";
                            $result = mysql_query ($query);
             while($row = mysql_fetch_array($result)){
              extract($row);
              echo '<option value="'.$ID.'">&euro; '.$prijs.'</option>';
              }
                         ?>
        </select>

           <select name="ligging" id="ligging">
                <option value="" selected>-----</option>
      <?php
         $query = "select ID, ligging from ligging";
                        $result = mysql_query ($query);
                        while($row = mysql_fetch_array($result)){
              extract($row);
                             echo '<option value="'.$ID.'">'.$ligging.'</option>';
                        }
       ?>
       </select>

           <select name="oppervlakte" id="oppervlakte">
                <option value="" selected>-----</option>
      <?php
         $query = "select ID, oppervlakte from oppervlakte";
                        $result = mysql_query ($query);
                        while($row = mysql_fetch_array($result)){
              extract($row);
                             echo '<option value="'.$ID.'">'.$oppervlakte.' m&#178;</option>';
                         }
       ?>
      </select>

           <select name="kamers" id="kamers">
                <option value="" selected>-----</option>
                <?php
                    $query = "select ID, kamers from kamers";
                    $result = mysql_query ($query);
                    while($row = mysql_fetch_array($result)){
                        extract($row);
                        echo '<option value="'.$ID.'">'.$kamers.'</option>';
                    }
                 ?>
      </select>

           <select name="woning" id="woning">
                <option value="" selected>-----</option>
                <?php
                    $query = "select ID, type from woning";
                    $result = mysql_query ($query);
                    while($row = mysql_fetch_array($result)){
                        extract($row);
                        echo '<option value="'.$ID.'">'.$type.'</option>';
                    }
                ?>
      </select>

<input type="submit" name="submit" value="Zoeken">

To display the result i'm using a PHP processing page which contains the flowing code:


<?php
......
.....

$locatie = $_POST['locatie'];
$prijsVan = $_POST['prijsVan'];
$prijsTot = $_POST['prijsTot'];
$ligging = $_POST['ligging'];
$oppervlakte = $_POST['oppervlakte'];
$kamers = $_POST['kamers'];
$woning = $_POST['woning'];
$eigenschappen = $_POST['eigenschappen'];

// SHOW LOCATIE
if($locatie !='' && $prijsVan =='' && $prijsTot =='' && $ligging =='' && $oppervlakte =='' && $kamers =='' && $woning =='' && $eigenschappen =='') {
   $query .= " AND locatie.ID = '" . $locatie. "' ORDER BY prijs.ID";   
}

// SHOW LOCATIE_PRIJSVAN
if($prijsVan !='' && $locatie !='' && $prijsTot =='' && $woning =='' && $ligging =='' && $oppervlakte =='' && $kamers =='' && $eigenschappen =='') {
   $query .= " AND locatie.ID = '" . $locatie . "' AND prijs.ID >= '" . $prijsVan . "' ORDER BY prijs.ID";
}

// SHOW LOCATIE_PRIJSTOT
if($prijsTot !='' && $locatie !='' && $prijsVan =='' && $woning =='' && $ligging =='' && $oppervlakte =='' && $kamers =='' && $eigenschappen =='') {
   $query .= " AND locatie.ID = '" . $locatie . "' AND prijs.ID <= '" . $prijsTot . "' ORDER BY prijs.ID";
}

// SHOW PRIJS VAN
if($prijsVan !='' && $locatie =='' && $prijsTot =='' && $ligging =='' && $oppervlakte =='' && $kamers =='' && $woning =='' && $eigenschappen =='') {
   $query .= " AND prijs.ID >= '" . $prijsVan . "' ORDER BY prijs.ID";
}

// SHOW PRIJS TOT
if($prijsTot !='' && $locatie =='' && $prijsVan =='' && $ligging =='' && $oppervlakte =='' && $kamers =='' && $woning =='' && $eigenschappen =='') {
   $query .= " AND prijs.ID <= '" . $prijsTot . "' ORDER BY prijs.ID";
}

// SHOW PRIJS_VAN_PRIJS_TOT
if($prijsVan !='' && $prijsTot !='' && $locatie =='' && $woning =='' && $ligging =='' && $oppervlakte =='' && $kamers =='' && $eigenschappen =='') {
   $query .= " AND prijs.ID BETWEEN '" . $prijsVan . "' AND '" . $prijsTot . "' ORDER BY prijs.ID";
}
 
// SHOW LIGGING
if($ligging !='' && $prijsVan =='' && $prijsTot =='' && $locatie =='' && $oppervlakte =='' && $kamers =='' && $woning =='' && $eigenschappen =='') {
   $query .= " AND ligging.ID = '" . $ligging. "' ORDER BY prijs.ID";   
}

...................... and so on.........


// Error: indien geen keuze gemaakt show deze error
if($prijsVan =='' && $prijsTot =='' && $locatie =='' && $woning =='' && $ligging =='' && $oppervlakte =='' && $kamers =='' && $eigenschappen =='') {
   ?> <center><font color="#666"> <?php postError(); ?></font></center><?php
}
else{
//Execute query
   $result = mysql_query($query) or die(mysql_error());
         
         while($row = mysql_fetch_array($result)){
           
         echo  $row['image_id'] ;
         echo  $row['locatie'] ;
         echo  $row['prijs'];
         echo  $row['type'];
         echo  $row['kamers'];
         echo  $row['oppervlakte'] . ' m&#178;';
         echo  $row['ligging'];
         echo  $row['eigenschappen'];
      }
}

mysql_close($con);

?>


As you see i have to use many IF condition to display the result of every select combinations.

Is there any way to do it in better way and using less coding?

Thanks.

Hello, I have been developing a website that needs to display products online, I was originally going to hand-write the PHP code but I thought it would be more beneficial to make it database orientated as new products can easily be added and a search function becomes possible.

I have it working so far so good, but the last part I can't seem to get working. I have it so all the products that have the desired category are displayed, but I want a more detailed analysis of the product to appear when the image is clicked, which at the moment, displays a blank page.

http://www.webwib.co...?p=floorpuzzles - this is the hand coded version that demonstrates how I want it to work. http://www.webwib.co...hp?floorpuzzles - this is the db version so far, it works how it is intended to apart from the last stage, which returns as a blank page rather than a dedicated page for the selected product.

Here is my code, the third segment beginning with "if(isset($_GET['$ID'])){", is my attempt at the final stage.

<?php
	$db=mysql_connect  ("localhost", "webwibco_charlie",  "Hello123") or die ('I cannot connect to the database  because: ' . mysql_error()); 
	$mydb=mysql_select_db("webwibco_products"); 

	include("header.php");

	if(isset($_GET['floorpuzzles'])){ 
		     echo "<h1>Our Floor Puzzles</h1>";
		$sql="SELECT  ID, Name, Tags, Description, Category FROM products WHERE Category LIKE '%" . FloorPuzzles .  "%'"; 
		$result=mysql_query($sql); 
		while($row=mysql_fetch_array($result)){ 
			$Name  =$row['Name'];
			$ID  =$row['ID']; 
			$Description  =$row['Description'];  
			echo "<div class=\"box\">";
			echo "<h1>$Name</h1>";
			echo "<div class=\"floorbox\"><a href=\"?$ID#productspage\"><img src=\"images/products/catalogue/$ID.jpg\" class=\"small\"></a></div>";
			echo "<h2>$Description</h2>";
			echo "</div>";
		}
	}

	if(isset($_GET['anothercategory'])){ 
		$sql="SELECT  ID, Name, Tags, Description, Category FROM products WHERE Category LIKE '%" . AnotherCategory .  "%'"; 
		$result=mysql_query($sql); 
		while($row=mysql_fetch_array($result)){ 
			$Name  =$row['Name'];
			$ID  =$row['ID']; 
			$Description  =$row['Description'];  
			echo "<h1>Our Floor Puzzles</h1>";
			echo "<div class=\"box\">";
			echo "<h1>$Name</h1>";
			echo "<div class=\"floorbox\"><a href=\"?$ID0#productspage\"><img src=\"images/products/catalogue//$ID.jpg\" class=\"small\"></a></div>";
			echo "<h2>$Description</h2>";
			echo "</div>";
		}
	}

	if(isset($_GET['$ID'])){   
		$sql="SELECT  ID, Name, Tags, Description, Peices, Size, Barcode, Category FROM products WHERE ID LIKE '%" . $ID .  "%'";   
		$result=mysql_query($sql);   
		while($row=mysql_fetch_array($result)){  
			$Name  =$row['Name'];
			$ID  =$row['ID']; 
			$Description  =$row['Description']; 
			$Pieces  =$row['Pieces']; 
			$Size =$row['Size']; 
			$Barcode  =$row['Barcode'];   
			echo "<div class=\"1\">";
			echo "<h1>$Name</h1>";
			echo "<div class=\"bigbox\">";
			echo "<div class=\"floorbox\"><img src=\"images/products/catalogue/$ID.jpg\" class=\"big\"></div>";
			echo "</div>";
			echo "</div>";
			echo "<div class=\"2\">";
			echo "<p>Puzzle Pieces: $Pieces</p>
				  <p>Puzzle Size: $Size</p>
				  <p>Barcode $Barcode</p>";
			echo "</div>"; 
		}  
	}  

include("footer.php");
?>

Thank you in advance for any assistance given.  

Hello to all.
I'm new here and i am very glad to be a part of this community.
I am new in PHP/mysql but i try to learn as much as i can in php & mysql.

And here is the problem:
Into  a php or html page i want to display 2 dropdown list to act as a filter for displaying a table.
I managed to display a table based on option select from first dropdown but i don'y know how to make  or activate the second dropdown list to act as a filter, and when i press "result" to display on the same page the results.

Thanks a lot.

I am building online dictionary with php. The following code allows the user to search a word and display the definition results from the database. The problem is the user has to input the identical words only. If the words are not exactly similar to the database words it returns error message. But in this case I need it to give a suggestion along with the error message based on the few beginning words of the submitted word. eg. if the user type a word "suggestion", and the word "suggestion" is not available in the database .... instead of just the error message to also search and include other stored data closer to the submitted word ... like "TRY the word SUGGEST".

can any one help me on this please.
Thank you in advance.

here is the code
Code: [Select]
<?php

$script = $_SERVER['PHP_SELF'];

if(isset($_POST['sbm']) && isset($_POST['word']) ) {
  submited();
} else {
  show_form();
}

function show_form() {
?>
<p><center> Type <span style='font-weight:bold;'>ENGLISH</span> word Only! <span style='font-weight:bold;'>SPELL IT CORRECTLY!!!.</span></center></P>
<p><center>Search</center></p>
 <center><form name=frm method=POST action="<?php echo $script ?>">
     <p><input type=text name="word"><br /></p>
    <p><input type=submit name="sbm" value="Submit">
  </form>    </center></p>
<?php
}

function submited() {
  require("dbconn.inc");
  $word=$_POST['word'];
  $sql="select * from words where eng like '".mysql_real_escape_string($word)."'";
  $result=mysql_query($sql,$link); // I assume $link is defined in dbconn.inc

  if(@mysql_num_rows($result)!=0) {
    $rows=mysql_fetch_array($result);
    $am=$rows["am"];
    echo("<center>The Word <h1><b>$word</b></h1> in Am is : <h1><b>$am </b></h1><br></center>");
  } else {
    echo("<center><span style='font-weight:bold;color:#FF0000;'>Could not find it! Check the spelling and try again !!</span></center>");
  }

  // The connection will close automatically since
  // this is near the end of the script.
  mysql_close($link);

  show_form();
}
?>

Hi, I have come up with the following code, I need it to get the details of several scattered products and echo the results, the trick is I don't want it to echo the results one after the other... I want to have the products scattered between unique text on the page but don't want to run the query several times for performance reasons.

E.g.- PAGE to look like this:

$Product_1

unique text/images

$Product_2
$Product_3

unique text/images

$Product_4


Current Code:

Code: [Select]
<?
$result = mysql_query("SELECT * FROM products where Product_ID IN (475, 465, 234, 567, 845)");
while($row = mysql_fetch_array($result))
  {
    $x = "1";
      while ($x<=3)
{
          echo $x;
          $Product = "Product_";
          $Product = $Product.$x;
          echo $Product;
          $Product = $row['Product_ID'];
          echo $Product;
          $x++;
          echo $x;
        }
  }

At the moment it returns the following results:

Quote

1
Product_1
465
2

2
Product_2
465
3

3
Product_3
465
4

1
Product_1
475
2

2
Product_2
475
3

3
Product_3
475
4


A few problems...

In Blue... it duplicates for product 465
In Red... It repeats again for 475
Also.... it starts with 465, but I want it to go in order as how it appears - $result = mysql_query("SELECT * FROM products where Product_ID IN (475, 465, 234, 567, 845)");  so should start with 475


I want to get the following result:

Quote

1
Product_1
475
2

2
Product_2
465
3

3
Product_3
234
4

4
Product_4
567
4

(and so on.....)



If anyone could provide me assistance with my troubled 'while loop' statement that would be much appreciated! 

OK, Here is the code

$sql = "SELECT
TrialListing.listingID AS Trial, TrialClass.classID AS Class, place.place_name AS Place,
CONCAT_WS(
' ',
pedigree.pretitle,
pedigree.`Name`) AS Hound,
CONCAT_WS(
' ',
ped2.pretitle,
ped2. NAME
)AS Sire,
CONCAT_WS(
' ',
ped3.pretitle,
ped3. NAME
)AS Dam,
pedigree.Breeder,
pedigree.`Owner`,
CASE
WHEN placement.place_id < 5 THEN
TRUNCATE(TrialClass.number_of_entrants / placement.place_id,2)
WHEN placement.place_id  = 5 THEN
''
ELSE
0
END

AS Score
FROM
TrialListing
Left Join TrialClass ON TrialListing.listingID = TrialClass.listingID

JOIN placement ON placement.event_id = TrialClass.trialClassID
JOIN pedigree ON pedigree.PedigreeId = placement.hound_id
LEFT OUTER JOIN pedigree AS ped2 ON pedigree.SireId = ped2.PedigreeId
LEFT OUTER JOIN pedigree AS ped3 ON pedigree.DamId = ped3.PedigreeId
LEFT JOIN place ON place.place_id = placement.place_id

WHERE
TrialListing.listingID = 11
ORDER BY Class, FIELD(place.place_id, '1', '2', '3', '4', '0')


";      // Database Query  

$result = mysql_query("$sql");  // Database Query result

$num_rows = mysql_num_rows($result);





// Starts the table
echo "<table class=\"clubList\">\n
<tr>
<th>trialID</th>
<th>ClassID</th>
<th>Place</th>
<th>Hound</th>
<th>Sire</th>
<th>Dam</th>
<th>Score</th>

</tr>";

// Create the contents of the table.
for( $i = 0; $i < $row = mysql_fetch_array($result); $i++){




echo "<tr>\n"
        ."<td>".$row["Trial"]."</td>\n" 
        ."<td>".$row["Class"]."</td>\n" 
        ."<td>".$row["Place"]."</td>\n"  
        ."<td>".$row["Hound"]."</td>\n"  
        ."<td>".$row["Sire"]."</td>\n"                
        ."<td>".$row["Dam"]."</td>\n"
        ."<td>".$row["Score"]."</td>\n"  
        ."</tr>";}



echo "</TABLE>";


Here is the output, I added the TrialID & ClassID for informational purposes, they do not need to be displayed in the live table.

trialID ClassID Place Hound Sire Dam Score 11 1 1st Eaton Brook Tug Hill Tatonka Eaton Brook Hickety Hawk Eaton Brook Gunner's Beulah 43.00 11 1 2nd FC North Bend Igloo FC DFJ Murphy White IFC Brad-Ju's Bella Donna 21.50 11 1 3rd FC North Bend Igloo FC DFJ Murphy White IFC Brad-Ju's Bella Donna 14.33 11 1 4th Rail Road Spike VI Elwell's Mike Elwell's Hannah 10.75 11 1 NBQ FC Fish Creek Spike Fish Creek Bull II Fish Creek Susie [H849395] 11 2 1st Enman Hill Sweet Poppy FTCH Straight Arrow Lucky of Coos 32.00 11 2 2nd Fishflakes Penny At Harehaven FTCH Jill's Fair-Isle Spud FTCH Millbridge Brownie 16.00 11 2 3rd Line Elm Flakers IFC Flakers Rex IFC Line Elm Ginger 10.66 11 2 4th FTCH Fareast Mookie FTCH Mellowrun Sly FTCH Cape Breton Maude 8.00 11 2 NBQ FTCH Mellowrun Sly Mellowrun Skylighter FTCH Mellowrun Becka 11 3 1st Bojangle V Lee Otworth Half Acre's Cocoa Candy 23.00 11 3 2nd Gay Doll Gay Roll II Gay Idol 11.50 11 3 3rd Bruce's Blue Lady FC Kilsock's Blue Creek Bart Bishopville's Zippy 7.66 11 3 4th FC Pearson Creek Barbin FC Pearson Creek Barbarian FC B-Line Stubby 5.75 11 3 NBQ Sims Creek Cricket Ronnie Joe Sims Creek Tiny 11 4 1st FTCH Fareast Mookie FTCH Mellowrun Sly FTCH Cape Breton Maude 26.00 11 4 2nd FTCH Mellowrun Sly Mellowrun Skylighter FTCH Mellowrun Becka 13.00 11 4 3rd Fishflakes Penny At Harehaven FTCH Jill's Fair-Isle Spud FTCH Millbridge Brownie 8.66 11 4 4th Enman Hill Sweet Poppy FTCH Straight Arrow Lucky of Coos 6.50 11 4 NBQ Line Elm Flakers IFC Flakers Rex IFC Line Elm Ginger
Below is what I would like to generate. How do I word or nest the proper PHP code/loops to accomplish this?

ClassID

Place Hound Sire Dam Score 1st Eaton Brook Tug Hill Tatonka Eaton Brook Hickety Hawk Eaton Brook Gunner's Beulah 43.00 2nd FC North Bend Igloo FC DFJ Murphy White IFC Brad-Ju's Bella Donna 21.50 3rd FC North Bend Igloo FC DFJ Murphy White IFC Brad-Ju's Bella Donna 14.33 4th Rail Road Spike VI Elwell's Mike Elwell's Hannah 10.75 NBQ FC Fish Creek Spike Fish Creek Bull II Fish Creek Susie [H849395]

ClassID

Place Hound Sire Dam Score 1st Enman Hill Sweet Poppy FTCH Straight Arrow Lucky of Coos 32.00 2nd Fishflakes Penny At Harehaven FTCH Jill's Fair-Isle Spud FTCH Millbridge Brownie 16.00 3rd Line Elm Flakers IFC Flakers Rex IFC Line Elm Ginger 10.66 4th FTCH Fareast Mookie FTCH Mellowrun Sly FTCH Cape Breton Maude 8.00 NBQ FTCH Mellowrun Sly Mellowrun Skylighter FTCH Mellowrun Becka

ClassID

Place Hound Sire Dam Score 1st Bojangle V Lee Otworth Half Acre's Cocoa Candy 23.00 2nd Gay Doll Gay Roll II Gay Idol 11.50 3rd Bruce's Blue Lady FC Kilsock's Blue Creek Bart Bishopville's Zippy 7.66 4th FC Pearson Creek Barbin FC Pearson Creek Barbarian FC B-Line Stubby 5.75 NBQ Sims Creek Cricket Ronnie Joe Sims Creek Tiny

ClassID

Place Hound Sire Dam Score 1st FTCH Fareast Mookie FTCH Mellowrun Sly FTCH Cape Breton Maude 26.00 2nd FTCH Mellowrun Sly Mellowrun Skylighter FTCH Mellowrun Becka 13.00 3rd Fishflakes Penny At Harehaven FTCH Jill's Fair-Isle Spud FTCH Millbridge Brownie 8.66 4th Enman Hill Sweet Poppy FTCH Straight Arrow Lucky of Coos 6.50 NBQ Line Elm Flakers IFC Flakers Rex IFC Line Elm Ginger

Hi guys I'm having problem on how to display my php mysql result like this..

Digitalpoint, phpfreaks, adsense

here's my code

Code: [Select]
$result = mysql_query ("SELECT dateline, dateline_from, eventid, title FROM vb_event WHERE calendarid = 1 AND dateline_from >= '$day_before' ORDER BY dateline_from LIMIT 2");
while($row = mysql_fetch_array( $result )) { 
echo "<a href='/forum/calendar.php?do=getinfo&amp;e=" . $row['eventid'] . "&amp;c=1' title='". $row['title'] . "' style='font-size:12px;'>" . $row['title'] . "</a> " ;
}
the result is Digitalpoint, phpfreaks, adsense,

how to remove the "," in the end?  it should be like this..

Digitalpoint, phpfreaks, adsense with no , comma  in the end..

Thank you..

I am really lost here with this date issue of mine. The below code is the last part of a query:
Code: [Select]
$defendercheck_3 = $row_checkifattacked3['atdate'];
$defendercheck1_3 = strtotime("$defendercheck_3");
$defendercheck2_3 = date("D", $defendercheck1_3);
The query does not return any results as expected, but when echoing the various steps I get following:

echo "$defendercheck3"; = nothing (as expected)

echo "$defendercheck1_3"; = nothing (as expected)

echo "$defendercheck2_3"; =  result! (NOT expected)

why does it return anything on "date("D", $defendercheck1_3)" when "$defendercheck1_3" is blank?