search form problem
Posted: Fri Oct 14, 2005 9:46 pm
feyd | Please use
feyd | Please use
Code: Select all
andCode: Select all
tags where appropriate when posting code. Read: [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url][/color]
I am trying to get my PHP script to display multiple search results for a keyword that a user inputs into my search form. So far I can only get it to display 1 record (whatever the last record entered was). Can someone tell me what I need to add to my PHP script to get it to display more than one search record?
Here is my PHP code:Code: Select all
<?php
$dbHost = 'mysql';
$dbUser = 'username';
$dbPass = 'password';
$dbname = 'alumni';
$db = mysql_connect($dbHost,$dbUser,$dbPass);
$db_selected = mysql_select_db($dbname,$db);
if (!$db_selected) { die('Error : ' . mysql_error()); }
$sql = "SELECT * FROM signup";
$result = mysql_query($sql,$db);
while ($newArray = mysql_fetch_array($result))
{
$firstname = $newArray['firstname'];
$maidenname = $newArray['maidenname'];
$lastname = $newArray['lastname'];
$email = $newArray['email'];
$url = $newArray['url'];
$update = $newArray['update'];
}
?>
<hr width="60%" size="1" color="#006633" align="left">
<font color="#006633" size="4"><b><?php echo "$firstname $maidenname $lastname";?></b></font><p>
<font color="#006633" size="3"><?php echo "$update/n";?></font>feyd | Please use
Code: Select all
andCode: Select all
tags where appropriate when posting code. Read: [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url][/color]