I am making a comment box in PHP for my site. This is the code:\[code\]$con = mysql_connect($hostname,$username,$password); // Connect to MySQL databaseif (!$con) { die("Could not connect: " . mysql_error()); }mysql_select_db($dbname);if(isset($_POST["submit"])){ $comment=$_POST["comment"]; $q="INSERT INTO comments_table (comments) VALUES ('$comment')"; // Could also be (\"comment\") mysql_query($q);} $q="SELECT comments FROM comments_table";$result=mysql_query($q);while($row=mysql_fetch_array($result)){ // List the comments - how could I get some markup between each to make each have it's own area? echo $row['comments']."";}?><html><body><form method="post" action="/comments-test.php"><textarea name="comment" rows=30 cols=10></textarea><input type="submit" name="submit" value="http://stackoverflow.com/questions/14046570/submit"></form></body></html>\[/code\]What I want to know is how I should go about making each comment have it's own box or markup. It can't be the same HTML between each comment (e.g., \[code\],</div><div class="comment">\[/code\]), otherwise there will be some comment box at the end of the comments that has no closing tag and a stray closing tag at the beginning. I am new to SQL, but not PHP. How should I do this?
How can I put markup between each MySQL field result?
- Thread starter Tka
- Start date