help with a simple problem

[scottbarry]

I have a simple database with 4 fields

ID
name
company
position

I have a form that when the user enters a name it should display all records that match that name.

this is my form (its very simple)

<form name="form1" method="POST" action="action.php">

<p> name: <input name="name" type="text" id="name">
<p><input type="submit" name="submit" value="submit">
</form>

this is my action.php

<?
$host = "db.database.com";
$user = "user";
$pass = "password";
$dbname = "data";

$connection = mysql_connect($host,$user,$pass) or die (mysql_errno().": ".mysql_error()."<BR>");
mysql_select_db($dbname);

$query = "select * from eagle where name=" . $_POST['name'] . "'";
echo $sql;

$query = mysql_query($sql);

while ($row = mysql_fetch_array($query)) { echo "<p>",$row['name'],":",$row['company'],":",$row['position']; }

?>

can you tell me what I am doing wrong?

[AtroZ]

Your query var is named "query" not "sql", also ckeck out the single quotes in your query statement.

<?
$host = "db.database.com";
$user = "user";
$pass = "password";
$dbname = "data";

$connection = mysql_connect($host,$user,$pass) or die (mysql_errno().": ".mysql_error()."<BR>");
mysql_select_db($dbname);

/*## HERE ##*/
$query = "select * from eagle where name=" . $_POST['name'] . "'";
/*## HERE ##*/

// You should be using $query here!!!
//  $query = mysql_query($query);
$query = mysql_query($sql);

while ($row = mysql_fetch_array($query)) { echo "<p>",$row['name'],":",$row['company'],":",$row['position']; }

?> 

[scottbarry]

can you then tell me where i went wrong in

/## HERE ##/
$query = "select from eagle where name=" . $_POST['name'] . "'";
/## HERE ##*/

when i enter a name in my form..returns a blank page

[AstroTeg]

$query = "select * from eagle where name='" . $_POST['name'] . "'";

You're missing the single quote right after "name=". See the above with correction.

[scottbarry]

thank you ..that helped

one more question..how can I have the results displayed in a table form instead of

scott:xyzcomapny:ceo

[sanam]

Replace

while ($row = mysql_fetch_array($query)) { echo "<p>",$row['name'],":",$row['company'],":",$row['position']; }

with

echo "<table cellpadding='1' cellspacing='1' border='1'>";
echo "<tr><td>Name</td><td>Company</td><td>Position></td></tr>";
while ($row = mysql_fetch_array($query)) { echo "<tr><td>".$row['name']."</td><td>".$row['company']."</td><td>".$row['position']."</td></tr>"; }
echo "</table>";

this is simple example, but for now will get you started.