 |  |  |  |  |  |  |  |
How to display result in a new line
Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
 |
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['id'] ?>" ><?php echo $data['first'] ?></option>
<?php } ?>
</select>
<br>
Mobile :
<input name="mobile" type="text" id="mobile">
</p>
<p>
<input type="submit" value="Submit" name="Submit"/>
</p>
<p> </p>
</form>
</body>
</html>
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['id'] ?>" ><?php echo $data['first'] ?></option>
<?php } ?>
</select>
<br>
Mobile :
<input name="mobile" type="text" id="mobile">
</p>
<p>
<input type="submit" value="Submit" name="Submit"/>
</p>
<p> </p>
</form>
</body>
</html>
seems like your new to HTML too...
do you mean they display on the same line after you've submitted the form or what?
do you mean they display on the same line after you've submitted the form or what?
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?
|
Other Threads in the PHP Forum
- Previous Thread: convert php/mysql page to html
- Next Thread: How to upload an image on page
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest PHP Posts
- Today's Posts
- Unanswered Threads
.htaccess alerts apache api archive array autocomplete beginner binary broken cakephp checkbox class cms code convert cron curl database dataentry date display duplicates dynamic echo email emptydisplayvalue error execute explodefunction file files firstoptioninphpdroplist folder form forms function functions google hack href htaccess html htmlspecialchars image include insert ip javasciptvalidation javascript joomla keywords limit link login mail matching menu methods mlm multiple mysql network object oop paypal pdf php problem query radio random recursion recursive redirect remote script search securephp server sessions shot sms source space sql subscription syntax system table tutorial tutorials update upload url validator variable video web youtube
