PHP - Counting Duplicate Rows And Displaying Results

My site seems to be going well, but on the back end, the users database is going crazy with duplicate entrys. but its not doing it from an INSERT. it seems to be doing it with this code:
Code: [Select]
               $bitquery = $bitcoin->move("bittleship$username", "bittleships", $cost, $minconfirmations);
               if ($bitquery == true){
               $query = mysql_query("INSERT INTO `transactions` ( `id` , `username` , `type` , `amount`, `address`) VALUES ('', '$username', 'buyclicks', '$cost', '')")  or die(mysql_error());
               $query = mysql_query("UPDATE users SET `clicks` = `clicks`+$quantity, `balance`=`balance`-$cost WHERE `username` = '$username' ") or die(mysql_error());
               include('update.php');

I wish to have a page that will display a form if there aren't already enough registrations in the database. The following it an outline of how it will be:

<?php
require_once "../scripts/connect_to_mysql.php";                        //this works fine


// Count how many records in the database
(1) $sqlCommand = "SELECT * FROM teams"; 
(2) $sqlCommand = "SELECT COUNT (*) FROM teams";
(3) $sqlCommand = "SELECT COUNT (id) FROM teams";
$query = mysqli_query($myConnection, $sqlCommand) or die (mysqli_error());
(1) $numRegistrations = mysql_num_rows($query); //Count how many rows are returned from the query above
(2) $numRegistrations = $query
(3) $numRegistrations = mysql_num_rows($query);

mysqli_free_result($query);
?>
(Some HTML code, like DOCTYPE, head, start of body tags)
<?php
if($numRegistrations > 35){
echo "Sorry, registrations for this event is at it's maximum.";
}else{
?>

<form blah blah blah>

</form>

<?php
}
?>

(end of body and html tag)



You'll see above there is (1), (2), (3). These are the main 3 that I've been trying, and they match up the $sqlCommand to the $numRegistrations.

What would be the problem with this code? I use wamp server to test, have been using it for ages. Chrome browser to test in.
If I remove the database query, the rest of the page will load.
With the query in there, only the HTML code up until the database query is parsed, so therefore nothing is display on the page.

Please help.

Thanks
Denno

Hi, I need help to check multiple rows for many columns, so that the script won't re-insert a duplicate entry. For eg:


$isRowExist=mysql_query("SELECT (field1,field2) from table1 WHERE field1='$f1' AND field2='$f2' ");

if(mysql_num_rows($isRowExist)==1)
   print "already in table1!";
else
   //proceed to insert into table table1


*BUT I tried this and it says mysql_num_rows expects resource, and this warning only shows when I have multipel columns I want to compare (it works just fine with one column in the WHERE clause above)

Please help!

Hi there, I know I'm doing something stupid, but i've tried for hours to try and figure this out and I just cant seem to figure out why tutorials i've seen seem to work yet my own code doesnt.
basically i've got two functions: getAll() and get($id) inside a class, calling getAll, returns an array with one of the same record as opposed to all the records (which is my intended result).  Can anyone help? thanks.

Code: [Select]
class Test{
        protected $_db;
        protected $_table = "table";
       
        protected $_friends = array();
       
        public function __construct($db) {
            $this->_db = $db;
        }
       
        public function getAll()
        {
            $db = $this->_db;
            $sql = "SELECT * FROM $this->_table";
            $db->query($sql);
            while($data = $db->fetch_array())
            {
                $this->_friends[$data['id']] = $this->get($data['id']);
            }
            return $this->_friends;
        }
       
        public function get($id)
        {
            $db = $this->_db;
            $sql = "SELECT * FROM $this->_table WHERE id='$id'";
            $db->query($sql);
            $data = $db->fetch_array();
           
            return (object)$data;
           
        }
}

$test = new Test(new mysqlConnClass());
$arrayOfAllAsObjects = $test->getAll();

This topic has been moved to MySQL Help.

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

Hey there. Not sure how to word this. I've been flying blind as a newbie trying to figure out some pagination for a left joined query. I've got syntax errors trying to set up the SELECT COUNT function that adds up the results of the search on a previous page so it knows how many results matched both tables.

Right now, I've got this mess, and it's giving me a syntax error,
"You have an error in your SQL syntax; .... near 'LEFT JOIN plantae ON (descriptors.plant_id = plantae.pla' at line 12"
Code: [Select]
$data = "Select (SELECT COUNT(*)
                    FROM
                        descriptors
                    ) AS
                        count1,
                (SELECT COUNT(*)
                    FROM
                         plantae
                    ) AS
                        count2

                    LEFT JOIN
                        plantae ON (descriptors.plant_id = plantae.plant_name)
                    WHERE
                        `leaf_shape` LIKE '%$select1%'
                        AND `leaf_venation` LIKE '%$select3%'
                        AND `leaf_margin` LIKE '%$select4%'";
                   
 
$result = mysql_query ($data);
if (!$result) {
    die("Oops, my query failed.  The query is: <br>$data<br>The error is:<br>".mysql_error());
}

Hi,

I use this code (found in post http://www.phpfreaks.com/forums/index.php?topic=205633.0) to create a tree structure of categories and subgategories.

Code: [Select]
$prevcat = '';
$prevsubcat = '';
$sql = "SELECT * FROM $tbl_name ORDER BY categ, subcateg";
$result = mysql_query($sql) or trigger_error(mysql_error(),E_USER_ERROR);
while($row = mysql_fetch_assoc($result)) {
    $cat = $row['categ'];
    $subcat = $row['subcateg'];
    $item = $row['itemname'];
$description = $row['itemdesc'];
    if($cat != $prevcat){
        echo $cat.'<br />';
        echo 'sc '. $subcat.'<br />';//if the category has changed, we also want to show the new subcat
    }elseif($subcat != $prevsubcat){
        echo $subcat.'<br />';
    }
    echo 'it '.$item.'<br />';
echo 'desc '.$description.'<br />';

$prevcat = $cat;
$prevsubcat = $subcat;
}

The above code works fine but I am trying to figure out how to count results of the deepest subcategory, so I will be able to change cell color or have results presented in two colums (left and right).

Example:

- main category 1
-- subcategory under category 1
------ result 1
------ result 2
------ result 3


- main category 2
-- subcategory under category 2
------ result 1
------ result 2


- main category 3
-- subcategory under category 3
------ result 1
------ result 2
------ result 3
------ result 4

etc

I want to count results under each subcategory, so on the above example I should have:
3 results for category 1 
2 results for category 2
4 results for category 3

Any suggestions?

Thank you.

Code: [Select]
$PlayerQuery = "SELECT FirstName, SurName FROM players p, rounds m, entrants e, games t WHERE p.PlayerID = e.PlayerID AND m.GameID = '$ID' AND e.EntrantID = m.Player";
$PlayerResult = mysql_query($PlayerQuery);
$PlayerRow = mysql_num_rows($PlayerResult);

Can someone suggest why this returns game*the number of results. For each new game it returns an extra duplicate result. For example for 2 games:
j Smith
j Smith
t John
t John etc

There are no duplicate entry's! and results should be unique.  Not in a loop (positive)

Hi

I am building a product search engine using MySql and PHP (Jquery / AJAX).
As i am getting the search results i wondered is it possible to count the instances of a category?
For example:
If i search for "Dell Laptops" i get 400+ results back because it has lots of laptops and accessories.
What i am aiming for it to do is while looping through look at the categories and if its the first instanc eof it i want it to begin a count. until it has finished looping and then i can display it.
Results: 436 [ Laptops(127) - Accesories (244) - Components(65)  ]

Im not even sure where to start here so any advice will be helpful

Here is the code im using to generate the search:
   $id = str_replace(" ", "%", "$id");
   $q = "SELECT * FROM products WHERE prod_name LIKE '%$id%' order by fee asc LIMIT 20";

Just finished a search script. However, when type two keywords it will return duplicate entries:

Code: [Select]
elseif(isset($_GET['search'])){
$search=$_POST['search'];
$search=str_replace(" ", ".", $search);
header("Location: ./index.php?q=".$search);
}
elseif(isset($_GET['q'])){
$search=$_GET['q'];
$keywords=explode(".",$search);
$sql10000="SELECT product_id FROM $tbl_name2 WHERE keyword LIKE '%" . implode("%' OR keyword LIKE '%",$keywords) . "%'";
$result10000=mysql_query($sql10000);
if(mysql_num_rows($result10000)==0){
$content='<div class="center">Search found no results.</div>';
}
else{
while($row10000=mysql_fetch_array($result10000)){
$product_id3=$row10000['product_id'];
$sql15000="SELECT * FROM $tbl_name WHERE product_id=".$product_id3;
$result15000=mysql_query($sql15000);
while($row15000=mysql_fetch_array($result15000)){
extract($row15000);
$content.=$product_name;
}
}
}
}

I have 3 products:
Test2 - microphone
Test3 - audio, microphone
Test123 - audio

When you search "audio" you get:
Test3, Test123

When you search "microphone" you get:
Test2, Test3

When you search "audio microphone" you get:
Test2, Test3, Test3, Test123
with Test3 being a duplicate.

Is there anyway to correct this? I tried SELECT DISTINCT * FROM, but there's no difference in the results returned, from what I have now.

Hey all, I've been re-developing a cracker for my site, and when i enter the hash to crack it displays the results 3 times.

Example:
http://www.just-hack.com/index.php?action=cracker

Here's my source:
Code: [Select]
<?php

/**
*
* @PHP Dictionary Cracker for SMF, v1.0
*
*/


 function template_main()

{

echo "
<table width='100%' border='0' cellspacing='0' cellpadding='4' align='center' class='tborder'>
<tr class='catbg'>
<td>Cracker</td>
</tr>
<tr>
<td class='windowbg'>
<div align='center'>";

function des($word)
{

    return crypt($word, "sl");

}

function undes($word, $hash)
{

    $salt = substr($hash, 0, 2);

    return crypt($word, $salt);

}

if (!$_POST["encrypt"])
{

    if (!$_POST["decrypt"])
    {

        echo "
        <table width='80%' cellspacing='5' cellpadding='5' align='center'>
        <form method='post'>
        <td class='windowbg2' align='center'><br />Hash:  <input type='text' style='width:50%;'name='hash' /> <select name='type'>
        <option>MD5</option>
        <option>DES</option>
        <option>SHA1</option>
        </select>
           &nbsp;&nbsp;&nbsp;&nbsp;<input type='submit' name='decrypt' value='Crack' />
        </form></td></table><br />
        <table width='80%' cellspacing='5' cellpadding='5' align='center'>
        <form method='post'>
        <td class='windowbg2' align='center'><br />Word: <input type='text' style='width:50%;'name='word' /> <select name='type'>
        <option>MD5</option>
        <option>DES</option>
        <option>SHA1</option>
        </select>
           &nbsp;&nbsp;&nbsp;&nbsp;<input type='submit' name='encrypt' value='Encode' />
        </form></td></table><br />";

$hash = $_POST['hash'];



    }
    else
    {
        $hash = $_POST['hash'];
        if($hash==""){
            echo " 
    <table width='80%' cellspacing='5' cellpadding='5' align='center'>
        <form method='post'>
        <td class='windowbg2' align='center'><br />Hash:  <input type='text' style='width:50%;'name='hash' /> <select name='type'>
        <option>MD5</option>
        <option>DES</option>
        <option>SHA1</option>
        </select>
         &nbsp;&nbsp;&nbsp;&nbsp;<input type='submit' name='decrypt' value='Crack' />
        </form></td></table><br />
    <table width='80%' cellspacing='5' cellpadding='5' align='center'>
        <form method='post'>
        <td class='windowbg2' align='center'><br />Word: <input type='text' style='width:50%;'name='word' /> <select name='type'>
        <option>MD5</option>
        <option>DES</option>
        <option>SHA1</option>
        </select>
         &nbsp;&nbsp;&nbsp;&nbsp;<input type='submit' name='encrypt' value='Encode' />
        </form></td></table><br />
        <table width='80%' cellspacing='5' cellpadding='5' align='center'>
        <td class='windowbg2' align='center'>Type a hash to Crack!</td></table><br />";
} else {
        if ($type == "DES")
        {

            echo "
            <table width='80%' cellspacing='5' cellpadding='5' align='center'>
            <form method='post'>
            <td class='windowbg2' align='center'><br />Hash: <input type='text' style='width:50%;'name='hash' /> <select name='type'>
            <option>MD5</option>
            <option>DES</option>
            <option>SHA1</option>
            </select>
             &nbsp;&nbsp;&nbsp;&nbsp;<input type='submit' name='decrypt' value='Crack' />
            </form></td></table><br />
    <table width='80%' cellspacing='5' cellpadding='5' align='center'>
        <form method='post'>
        <td class='windowbg2' align='center'><br />Word: <input type='text' style='width:50%;'name='word' /> <select name='type'>
        <option>MD5</option>
        <option>DES</option>
        <option>SHA1</option>
        </select>
         &nbsp;&nbsp;&nbsp;&nbsp;<input type='submit' name='encrypt' value='Encode' />
        </form></td></table><br />";

//DES

        }
        else
        {

            echo "
            <table width='80%' cellspacing='5' cellpadding='5' align='center'>
            <form method='post'>
            <td class='windowbg2' align='center'><br />Hash: <input type='text' style='width:50%;'name='hash' /> <select name='type'>
            <option>MD5</option>
            <option>DES</option>
            <option>SHA1</option>
            </select>
             &nbsp;&nbsp;&nbsp;&nbsp;<input type='submit' name='decrypt' value='Crack' />
            </form></td></table><br />
    <table width='80%' cellspacing='5' cellpadding='5' align='center'>
        <form method='post'>
        <td class='windowbg2' align='center'><br />Word: <input type='text' style='width:50%;'name='word' /> <select name='type'>
        <option>MD5</option>
        <option>DES</option>
        <option>SHA1</option>
        </select>
         &nbsp;&nbsp;&nbsp;&nbsp;<input type='submit' name='encrypt' value='Encode' />
        </form></td></table><br />";


            $type = $_POST['type'];


        }

    }
}
}
else
{

    echo "
    <table width='80%' cellspacing='5' cellpadding='5' align='center'>
    <form method='post'>
    <td class='windowbg2' align='center'><br />Hash: <input type='text' style='width:50%;'name='hash' /> <select name='type'>
    <option>MD5</option>
    <option>DES</option>
    <option>SHA1</option>
    </select>
     &nbsp;&nbsp;&nbsp;&nbsp;<input type='submit' name='decrypt' value='Crack' />
    </form></td></table><br />
    <table width='80%' cellspacing='5' cellpadding='5' align='center'>
    <form method='post'>
    <td class='windowbg2' align='center'><br />Word: <input type='text' style='width:50%;'name='word' /> <select name='type'>
    <option>MD5</option>
    <option>DES</option>
    <option>SHA1</option>
    </select>
    &nbsp;&nbsp;&nbsp;&nbsp;<input type='submit' name='encrypt' value='Encode' />
    </form></td></table><br />";
    $type = $_POST['type'];

    if ($type == "DES")
    {

        $word = strip_tags($_POST['word']);
        if($word == ""){
echo "<table width='80%' cellspacing='5' cellpadding='5' align='center'>
<td class='windowbg2' align='center'>Type a word to encode!</td></table><br />";
} else {
        $enc = des($word);

        echo "
        <table width='80%' cellspacing='5' cellpadding='5' align='center'>
        <td class='windowbg2' align='center'>Encoded:
        <br />
        $word = $enc</td></table><br />";
}

    }
    elseif ($type == "MD5")
    {

        $word = strip_tags($_POST['word']);
        if($word == ""){
echo "<table width='80%' cellspacing='5' cellpadding='5' align='center'>
<td class='windowbg2' align='center'>Type a word to encode!</td></table><br />";
} else {
        $enc = md5($word);

        echo "
        <table width='80%' cellspacing='5' cellpadding='5' align='center'>
        <td class='windowbg2' align='center'>Encoded:
        <br />
        $word = $enc</td></table><br />";
}

    }
    elseif ($type == "SHA1")
    {

        $word = strip_tags($_POST['word']);
        if($word == ""){

echo"<table width='80%' cellspacing='5' cellpadding='5' align='center'>
<td class='windowbg2' align='center'>Type a word to encode!</td></table><br />";

} else {
        $enc = sha1($word);

        echo "
        <table width='80%' cellspacing='5' cellpadding='5' align='center'>
        <td class='windowbg2' align='center'>Encoded:
        <br />
        $word = $enc</td></table><br />";
}
    }
    else
    {
        echo ("Error?!");
    }
}

            $hash = $_POST['hash'];
            $words = file("wordlist.txt");

            foreach ($words as $word)
            {
                $word = rtrim($word);
                if (undes($word, $hash) == $hash)
                {
                    echo "

                    <table width='80%' cellspacing='5' cellpadding='5' align='center'>
                    <td class='windowbg2' align='center'>Plaintext found!
                    <br />
                    $hash = $word</td></table><br />";

                }
            }

  $file = "wordlist.txt";
  $lines = count(file($file));
  echo "There are $lines words in our wordlist!";

echo "</td></div></tr></table>";

}

?>

I'm working on a directory component and have kind of a tricky thing I need to do.

The list of results pop through ajax on the left side along with it's google map number tag, and the google map pops on the right side. To make it even trickier the results are popped through a radius search by proximity.

The problem is if there are multiple results with the same address you end up having all of the number tags on the map buried under the last tag with that address, plus it makes for kind of a long list.

What I need to do is run a check to see if the previous result is the same address, and if yes not pop that result in a new table cell, rather stick it in a jquery drop down div so that all of the following results with the same address are stuffed in the jquery drop down in the same table cell under the first result with that address.

In a perfect world all of the listings with the same addresses would be submitted in order so I could just do a check for the previous itemid's address, but of course that's not the case. I thought about running a query to grab ALL of the addresses and then check the item's address against it to see if it matches and if yes echo the jquery div instead of the <td>, but obviously that won't work because that will cause the first item with that address to be put in the div also. Plus I don't know if that's a very efficient way to go about it anyway.

Here's kind of the basic thing I'm working with:
Code: [Select]
$query = "SELECT data_txt FROM jos_sobi2_fields_data WHERE fieldid = 76 AND itemid = $mySobi->id";
$result = mysql_query($query) or die(mysql_error());
while($row = mysql_fetch_array($result)){
$myaddress = $row['data_txt'];
}
echo "<td $style>";

Any ideas?

I've got my code working OK in that the correct results are drawn from the database. What I have here in the code is an array consisting of an image, accompanied by its title and thirdly a link to activate a quiz associated with the image. Everything works fine, except because the page is dynamic, I always have an unknown number of sets of data (image, title and link) which I want to display so that each set of data takes up a new row.
The code I have here, while displaying the correct data, places all of the results into the same row.
Any suggestions are most welcome.
Code: [Select]
<?php
// Query the database
$query1 = mysql_query("SELECT title FROM topics WHERE managerId='".$managerId."' AND egroup1='"."1"."' ORDER BY title ASC"); 
$query2 = mysql_query("SELECT url_small FROM topics WHERE managerId='".$managerId."' AND egroup1='"."1"."' ORDER BY title ASC"); 
$query3 = mysql_query("SELECT title FROM topics WHERE managerId='".$managerId."' AND egroup1='"."1"."' ORDER BY title ASC");
while($row1 = mysql_fetch_array($query3))
{
$linkname .= $row1['title']."<br />\n";
}
?>
                  <table>
                    <tr>
                      <td>
                      <?php
                      while ($row2 = mysql_fetch_array($query2)) 
                      { 
                      $thumbnail.= $row2['url_small'];
                      echo "<img src='wood_tool_images/{$row2['url_small']}' alt='' /><br />\n";
                      }
                      ?>
                      </td>
                      <td height="200">
                      <?php
                      echo $linkname 
                      ?>
                      </td>
                      <td>
                      <?php
                      while ($row1 = mysql_fetch_array($query1)) 
                      { 
                      $quizname.= $row1['title'];
                      echo "<a href='../{$row1['title']} Safety Quiz/{$row1['title']} Safety Quiz.php'>Take This Quiz</a><br />\n";
                      }
                      ?>
                      </td>
                     </tr>
                  </table>

Hi all,

I need your help as I have got a problem with display the 50 rows in the search results. I want to limit 50 rows in per page and if I have less than 50 rows like 21 rows in the page 2 then display the 21 rows.

I have got a problem with the limit, because when I tried to use `LIMIT 0, 50`, it will display total 71 rows which I only want to display no more than 50 in per page.

Here is what I have tried:

    $search_mailbox = $link->prepare("SELECT * FROM $folder WHERE from_email LIKE ? OR subject LIKE ? OR message LIKE ? ORDER BY received_date DESC LIMIT 0, 50");
    $search_mailbox->execute([$searchemail, $searchsubject, $searchmessage]);

And I have also tried this:

    $search_mailbox = $link->prepare("SELECT * FROM $folder WHERE from_email LIKE ? OR subject LIKE ? OR message LIKE ? ORDER BY received_date DESC LIMIT $offset, $limit");
    $search_mailbox->execute([$searchemail, $searchsubject, $searchmessage]);

It will not limit the rows I want. It will still show the 71 rows.

Here is the full code:

   

<?php
    
    // Initialize the session
    session_start();
    
    //Connect to the database
    require_once('config.php');
    
    $searchemail = '%' . 'gmail.com' . '%';
    $searchsubject = '%' . 'gmail.com' . '%';
    $searchmessage = '%' . 'gmail.com' . '%';
    
    $mailbox = $link->prepare("SHOW TABLES");
    $mailbox->execute();
    $folders = array();
    $total = 0;
    $total_rows = 0;
    $i = 0;
            
    while ($folder = $mailbox->fetch(PDO::FETCH_NUM)) {
        $folder = $folder[0];
    
        if (strpos($folder, 'users') !== false) {
            $folder = str_replace('users', '', $folder);
        }
        else
        {
            $folders[$i] = $folder;
        }
        $i++;
    }
    
    foreach($folders as $folder) {
        $search_mailbox = $link->prepare("SELECT * FROM $folder WHERE from_email LIKE ? OR subject LIKE ? OR message LIKE ? ORDER BY received_date DESC LIMIT 0, 50");
        $search_mailbox->execute([$searchemail, $searchsubject, $searchmessage]);
        
        if ($search_mailbox->rowCount() > 0) {
            $total += $search_mailbox->rowCount();
        }
    }
    
    $page = 1;
    $limit = 50;
    //$per_page = 50;
    //$pages = ceil($total / $per_page);
    
    $offset = ($page - 1) * $limit;
    
    
    foreach($folders as $folder) {
        
        $search_mailbox = $link->prepare("SELECT * FROM $folder WHERE from_email LIKE ? OR subject LIKE ? OR message LIKE ? ORDER BY received_date DESC LIMIT $offset, $limit);
        $search_mailbox->execute([$searchemail, $searchsubject, $searchmessage]);
    
    
        if ($search_mailbox->rowCount() > 0) {
            foreach($search_mailbox->fetchAll() as $k => $row) {
                $email_number = $row['id'];
                $search_from = $row['from_email'];
                $search_subject = $row['subject'];
                $total_rows++;
                echo $search_subject . '.........................' . $total_rows;
                echo "<br>";
            }
        }
                        
    }
    
    ?>

I am unable to fetch the first 50 rows in the page 1 and I am also unable to fetch the 21 rows in the page 2. 

What I am trying to achieve is when I am in page 1, I want to display the first 50 rows, then in the page 2 if I have another 50 rows then display the 50 rows, but if I have less than 50 rows like 21 rows then display the 21 rows.

Can you please show me an example how I can start with first 50 rows when I am in the page 1 then in page 2 display 21 rows to make in total 71 rows?

Any advice would be much appreicated.

Thanks in advance.

So here is what I a trying to do:

Code: [Select]

<?php

/**
 * @author 
 * @copyright 2010
 */
$res = mysql_query("SELECT * FROM `planetsTable` WHERE `section` = '1' LIMIT 9 ASC");
while($row = mysql_fetch_array($res)){ ?>
 
 
            <li>
            <span id="sun">Solar System Star</span>
            <p>The Sun is a star, a hot ball of glowing gases at the heart of our solar system. Its influence extends far beyond the orbits of distant Neptune and Pluto. Without the Sun's intense energy and heat, there would be no life on Earth. And though it is special to us, there are billions of stars like our Sun scattered across the Milky Way galaxy.</p>
            </li>
 
        <li>
            <span id="mercury"><?php echo $row[0]['name']; ?></span>
            <p>Sun-scorched Mercury is only slightly larger than Earth's Moon. Like the Moon, Mercury has very little atmosphere to stop impacts and it is covered with craters. Mercury's dayside is super heated by the Sun, but at night temperatures drop hundreds of degrees below freezing. Ice may even exist in craters. Mercury's egg-shaped orbit takes it around the Sun every 88 days.</p>

            </li>
           
            <li>
            <span id="venus"><?php echo $row[1]['name']; ?></span>
            <p>Venus is a dim world of intense heat and volcanic activity. Similar in structure and size to Earth, Venus' thick, toxic atmosphere traps heat in a runaway 'greenhouse effect.' The scorched world has temperatures hot enough to melt lead. Glimpses below the clouds reveal volcanoes and deformed mountains. Venus spins slowly in the opposite direction of most planets.</p>
            </li>
           
            <li>
            <span id="earth"><?php echo $row[3]['name']; ?></span>

            <p>Earth is an ocean planet. Our home world's abundance of water - and life - makes it unique in our solar system. Other planets, plus a few moons, have ice, atmospheres, seasons and even weather, but only on Earth does the whole complicated mix come together in a way that encourages life - and lots of it.</p>
            </li>
           
            <li>
            <span id="mars"><?php echo $row[4]['name']; ?></span>
            <p>Though details of Mars' surface are difficult to see from Earth, telescope observations show seasonally changing features and white patches at the poles. For decades, people speculated that bright and dark areas on Mars were patches of vegetation, that Mars could be a likely place for life-forms, and that water might exist in the polar caps. When the Mariner 4 spacecraft flew by Mars in 1965, many were shocked to see photographs of a bleak, cratered surface. Mars seemed to be a dead planet. Later missions, however, have shown that Mars is a complex member of the solar system and holds many mysteries yet to be solved.</p>
            </li>
           
            <li>

            <span id="jupiter"><?php echo $row[5]['name']; ?></span>
            <p>The most massive planet in our solar system, with four large moons and many smaller moons, Jupiter forms a kind of miniature solar system. Jupiter resembles a star in composition. In fact, if it had been about 80 times more massive, it would have become a star rather than a planet.</p>
            </li>
           
            <li>
            <span id="saturn">Saturn</span>
            <p>Saturn was the most distant of the five planets known to the ancients. Like Jupiter, Saturn is made mostly of hydrogen and helium. Its volume is 755 times greater than that of Earth. Winds in the upper atmosphere reach 500 meters (1,600 feet) per second in the equatorial region. These super-fast winds, combined with heat rising from within the planet's interior, cause the yellow and gold bands visible in the atmosphere.</p>
            </li>

           
            <li>
            <span id="uranus">Uranus</span>
            <p>The first planet found with the aid of a telescope, Uranus was discovered in 1781 by astronomer William Herschel. The seventh planet from the Sun is so distant that it takes 84 years to complete one orbit.</p>
            </li>
           
            <li>
            <span id="neptune">Neptune</span>
            <p>Nearly 4.5 billion kilometers (2.8 billion miles) from the Sun, Neptune orbits the Sun once every 165 years. It is invisible to the naked eye because of its extreme distance from Earth. Interestingly, the unusual elliptical orbit of the dwarf planet Pluto brings Pluto inside Neptune's orbit for a 20-year period out of every 248 Earth years</p>

            </li>
           
            <li>
            <span id="pluto">Pluto</span>
            <p>Tiny, cold and incredibly distant, Pluto was discovered in 1930 and long considered to be the ninth planet. But after the discoveries of similar intriguing worlds even farther out, Pluto was reclassified as a dwarf planet. This new class of worlds may offer some of the best evidence of the origins of our solar system.</p>
            </li>
        </ul>
   
<?}

?>

What I need to know is if this is possible and if so how would I got about doing this?
Code: [Select]
<?php 
$row['0']['name']; // Main Issue.
?>
McBryver