0

Hi i am new to php. The code below is a page that display results from the database. i included a table. When the search result displays the result it doesnt go on a new line. For example the name neil Mcman and Peter Worth comes in the same line. I want it to go to a new line. for eg

Neil Mcmarn

Peter worth

Any help will be much apreciated

<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body>
<form action="welcome.php" method="post">
<?
$username="proper_asik112";
$password="ashik112";
$database="proper_contacts";

mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
?>

<select name="name" id="name">

<?php
$sql="SELECT id,first FROM contacts";
$result =mysql_query($sql);
while ($data=mysql_fetch_assoc($result)){
?>
<option value ="<?php echo $data ?>" ><?php echo $data ?></option>
<?php } ?>

</select>
<br>
Mobile :
<input name="mobile" type="text" id="mobile">
</p>
<p>
<input type="submit" value="Submit" name="Submit"/>
</p>
<p>&nbsp; </p>
</form>
</body>
</html>

3
Contributors
4
Replies
5
Views
8 Years
Discussion Span
Last Post by upstream
0

seems like your new to HTML too...

do you mean they display on the same line after you've submitted the form or what?

0

yes after i'v submitted the form. And i want it too display in a new line not the same.

Thanks

0

you've posted the wrong bit of code, you need to post the bit of code that looks at the form AFTER it's been submitted... welcome.php?

0

if you want to display a result in a new line
use this "\n" on your php code (if you just want a clear view of your list in loop..or <br /> tags in html...

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.