Return one value from SQL database using PHP
<p>just wondering is there any way that I can return one value from my SQL database? Basically I am writining a website for my A level ICT coursework.
The website must allow posts to be made users and these posts must be stored in a table and then can be viewed by clicking on them
So far I have created a registration form and log in script to authenticate the session and delegate permission levels to users, I have created scripts which post threads to my database and have another script in place to store the data in the table
Now I wish to be able to view my posts when I click on them
So far my script is as follows </p>

<pre><code>    &lt;?php include_once('scripts/session_a.php') ; ?&gt;
&lt;?php include_once('scripts/connection.php') ; ?&gt;


&lt;?php


            $strSQL = "SELECT description FROM posts WHERE description=description";
            $result = mysql_query($strSQL) or die('SQL Error :: '.mysql_error());
            $row = mysql_fetch_assoc($result);

            echo $row['description'];


?&gt;
</code></pre>

<p>and this script is called from</p>

<pre><code>   &lt;!--////////////////////////////////////////////////////////
    // Project : Absolute Beginners log in system ///////////
    // Purpose : A2 Level Coursework for ICT ////////////////
    // Teacher : Mr L Hawkins ///////////////////////////////
    // Student : Alex Sims //////////////////////////////////
    // Candidate No. : 4173 /////////////////////////////////
    // Centre No : 27168 ////////////////////////////////////
    /////////////////////////////////////////////////////////--&gt;

    &lt;?php include_once('includes/header.php') ; ?&gt;
    &lt;?php include_once('includes/posts-header.php') ;?&gt;

    &lt;div&gt; &lt;!-- Main Wrapper --&gt;
        &lt;div class="Post Head"/&gt;&lt;!-- Start Page --&gt;
            &lt;name="Post" id="Post"/&gt;
            &lt;h2&gt;Absolute Beginners Forum&lt;/h2&gt;




        &lt;div name="postname" id="postname"/&gt;    &lt;!--PHP SCRIPT FEEDS NAME DATE AND AUTHOR HERE --&gt;
                &lt;label&gt;&lt;/label&gt;

                &lt;?php include('scripts/echo_test.php');?&gt;

        &lt;/div&gt;


        &lt;div name="content" id="content"/&gt;     &lt;!-- PHP SCRIPT FEEDS CONTENT HERE --&gt;

                &lt;?php include('scripts/get_post_content.php')?&gt;

        &lt;/div&gt;

    &lt;/div&gt;&lt;!-- End board--&gt;







&lt;/div&gt;&lt;!--End of page--&gt;






&lt;/div&gt; &lt;!-- Main Wrapper Ends --&gt;
&lt;?php
</code></pre>

<p>a screenshot can be seen here of what I was trying to describe </p>

<p><a href="http://gyazo.com/a8cfda3735c8bf2fd26b3b1c70fab191" rel="nofollow">http://gyazo.com/a8cfda3735c8bf2fd26b3b1c70fab191</a></p>

<p>Hopefully this generates a better understanding of my problem.</p>

<p>Thanks</p>

<p>Alex.</p>
