PHP Foreach statement issue. Multiple rows are returned

firestorm_1984

New Member
I'm a PHP beginner and lately i've been having a problem with my source code. Here it is:\[code\] <html> <head> <title> Bot </title> <link type="text/css" rel="stylesheet" href="http://stackoverflow.com/questions/13772343/main.css" /> </head> <body> <form action="bot.php "method="post"> <lable>You:<input type="text" name="intrebare"></lable> <input type="submit" name="introdu" value="http://stackoverflow.com/questions/13772343/Send"> </form> </body></html><?php//error_reporting(E_ALL & ~E_NOTICE);mysql_connect("localhost", "root", "") or die(mysql_error());mysql_select_db("robo") or die(mysql_error());$intrebare=$_POST['intrebare'];$query = "SELECT * FROM dialog where intrebare like '%$intrebare%'"; $result = mysql_query($query) or die(mysql_error());$row = mysql_fetch_array($result) or die(mysql_error());?><div id="history"><?php foreach($row as $rows){ echo "<b>The robot says: </b><br />"; echo $row['raspuns']; }?></div>\[/code\]It returns me the result x6 times.This problem appeared when I've made that foreach because I wanted the results to stuck on the page one by one after every sql querry.Can you please tell me what seems to be the problem? Thanks!
 
Back
Top