help with insert

[tridoc]

When I run this $result will be true but $result1 will not be true. I was wondering if somebody had an idea while it will not insert. I did a similar setup and it worked.

Thanks for any help
tridoc

$result = mysql_query("select fname, lname, phone, phone1, phone2, housing_agency1, city, state from hannausers where username like '$username'") or
die (mysql_error());
while (list ($fname, $lname, $phone, $phone1, $phone2, $housing_agency1, $city, $state)= mysql_fetch_array($result))

$result1 = mysql_query("INSERT INTO eviction (resnum, lastname, firstname, ssn, ssn1, ssn2, evictiondate, courteviction, username, fname, lname, phone, phone1, phone2, housing_agency1, city, state) VALUES ('$resnum', '$lastname', '$firstname', '$ssn', '$ssn1', '$ssn2', '$evictiondate', '$courteviction', '$username', '$fname', '$lname', '$phone', '$phone1', '$phone2', '$housing_agency1', '$city', '$state')");
{

[emcb_php]

Hi,

With that you would not need to specify the field names just the values:

$result = mysql_query("INSERT INTO table_name
VALUES $resnum, $lastname, $firstname, $ssn, $ssn1, $ssn2, $evictiondate, $courteviction, $username, $fname, $lname, $phone, $phone1, $phone2, $housing_agency1, $city, $state");

That should work,

Elfyn