I am trying to write a query that gets the name of every
personr who has a neme: $neve
This parameter come from a form like this:
FORM ACTION="sqlphp.php" METHOD="post">
<input type="text" name="neve" size="40">
<input type="submit" value="Dend data">
</FORM>
</pre>
The following script is running, but if I write in the 7-th row:
$result = mysql_query("SELECT * FROM employees WHERE first = $neve",$db)
It is wrong...
(I want to replace the "if" statement in the 21-th row.)
Can anyone help?
<html>
<body>
<?php
$db = mysql_connect("localhost", "root");
mysql_select_db("mydb",$db);
$result = mysql_query("SELECT * FROM employees",$db)
or die ("Not valid request");
$rows = mysql_num_rows($result);
echo "Whole number of rows:.$rows<br>";
echo "<table border=1>\n";
echo "<tr><td><b>Name</td><td><b>Address</tr><td><b>Position</tr>";
// $i=0;
// while ($myrow = mysql_fetch_array($result))
for ($i = 0; $i <=$rows - 1; $i++)
{
if (mysql_result($result,$i,"first") == $neve){
printf("<tr><td>%s %s</td><td>%s</td><td>%s</td></tr>\n",
mysql_result($result,$i,"first"),
mysql_result($result,$i,"last"),
mysql_result($result,$i,"address"),
mysql_result($result,$i,"position"));
}
// $i++;
}
echo "</table>\n";
mysql_free_result ($result);
?>
</body>
</html>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
