retriving multi line text data in a div from mysql database in php , entered by textarea

Question

i want to retrieve a paragraph from MySQL data base in Ampps server i wrote code as

    <?php                
            mysql_connect("localhost","root","mysql"); mysql_select_db("employ");
            $query="select 'db_post_contant' from blog where id=6";
            $run1=mysql_query($query);                  
              if(!$run1){
                echo"oops".mysql_error();
              }
              while($row=mysql_fetch_array($run1))                  
              {                         
                 $show=$row['db_post_contant'];
    ?>
                 <div > <?php echo"".$show ?> </div> 
    <?php 
              }
    ?>

Your question doesn't really explain anything. Is there any more detail you can add? — Dean Barnes, Apr 25 '14 at 10:04

score 0 · Answer 1 · edited Apr 25 '14 at 11:10

0

Change the query:

$query="select 'db_post_contant' from blog where id=6";

To:

$query="select db_post_contant from blog where id=6";

You cannot use quotes >'< around your table's name.

edited Apr 25 '14 at 11:10

Funk Forty Niner

73,764
15
63
131

answered Apr 25 '14 at 10:25

Salini L

799
5
11
38

thanks every one this was helpful – Maahi May 17 '14 at 06:45
@Maahi If it was helped u to solve the problem plz accept this as the answer. – Salini L May 19 '14 at 04:36

retriving multi line text data in a div from mysql database in php , entered by textarea

1 Answers1