what's wrong with this php code ?

I

ISSASSD

New member
please help !!!


<?php
function f($s, $name)
{
$s = $_POST["lname"];
$rows=mysql_numrows($s);
if($rows == 0)
print $name . " is not in the database.";
else
{
print "<pre>First Name Last Name " .
"Your Date of birth is Birth date\n</pre>";

for($i = 0; $i < $rows; $i++){
$f=str_pad(mysql_result($s,$i,"firstname"), 15, " ");
$l=str_pad(mysql_result($s,$i,"lastname"), 15, " ");
$b=str_pad(mysql_result($s,$i,"birthdate"), 25, " ");
$ss=mysql_result($s,$i,"ss");
print "<pre>" . . $l . $b . $d . "\n</pre>";
}
}
}

mysql_connect (localhost,testuser,testuser);
mysql_select_db (testuser);
mysql_query("CREATE DATABASE myDatabase");//(2)

mysql_query("USE myDatabase");

mysql_query("DROP TABLE myTable");
mysql_query("CREATE TABLE myTable (firstname VARCHAR(20), " .
"lastname VARCHAR(20), birthdate DATE, dependents INT, ss VARCHAR(11))");
mysql_query("LOAD DATA LOCAL INFILE 'names.txt' INTO TABLE myTable")
or die(mysql_error());
$s = mysql_query("SELECT * FROM myTable ORDER BY lastname");
$rows=mysql_numrows($s);
print "<pre>First Name Last Name Birth date " .
"Number of Dependents Social secority number\n</pre>";

for($i = 0; $i < $rows; $i++){
$f=str_pad(mysql_result($s,$i,"firstname"), 15, " ");
$l=str_pad(mysql_result($s,$i,"lastname"), 15, " ");
$b=str_pad(mysql_result($s,$i,"birthdate"), 25, " ");
$d=str_pad(mysql_result($s,$i,"dependents"), 18, " ");
$ss=mysql_result($s,$i,"ss");
print "<pre>" . $f . $l . $b . $d . $ss . "\n</pre>";
}
?>
 
Back
Top