Form Fill Fields?

[raouleduke]

I am using this form fill field and I am getting an error. any suggestions.
<?php
mysql_connect("");
mysql_select_db("");
if($id){
if($submit){
$sql="UPDATE keycadros SET DealerID='$DealerID',ServiceAdvisorID='$ServiceAdvisorID',CU#='$CU#',CUNAME='$CUNAME',CUHOME='$CUHOME',CUWORK='$CUWORK',RO#='$RO#',VIN='$VIN',Tech#='$Tech#',ProdcessedDate='$ProcessedDate',ServiceDate='$ServiceDate',Follow-UpContact='$Follow-UpContact',CustomerNotReached='$CustomerNotReached'
WHERE id=$id";
$result=mysql_query($sql);
echo"Thank you! Information updated.\n";
}else{
$sql="SELECT FROM keycardros WHERE id=$id";
$result=mysql_query($sql);
$myrow=mysql_fetch_array($result);
?>
<form method="post" action="<?php echo $PHP_SELF?>">
<input type=hidden name="id" value="<?php echo $myrow["id"]?>">
Dealer ID:<input type="text" name="DealerID" value="<?php echo $myrow["DealerID"]?>"><br>
ServiceAdvisorID:<input type="text" name="ServiceAdvisorID" value="<?php echo $myrow["ServiceAdvisorID"]?>"><br>
Customer#:<input type="text" name="CU#" value="<?php echo $myrow["CU#"]?>"><br>
Customer Name:<input type="text" name="CUNAME" value="<?php echo $myrow["CUNAME"]?>"><br>
Customer Home #:<input type="text" name="CUHOME" value="<?php echo $myrow["CUHOME"]?>"><br>
Customer Work #:<input type="text" name="CUWORK" value="<?php echo $myrow["CUWORK"]?>"><br>
RO#:<input type="text" name="RO#" value="<?php echo $myrow["RO#"]?>"><br>
VIN:<input type="text" name="VIN" value="<?php echo $myrow["VIN"]?>"><br>
Tech#:<input type="text" name="Tech#" value="<?php echo $myrow["Tech#"]?>"><br>
Processed Date:<input type="text" name="ProcessedDate" value="<?php echo $myrow["ProcessedDate"]?>"><br>
Service Date:<input type="text" name="ServiceDate" value="<?php echo $myrow["ServiceDate"]?>"><br>
Follow-Up Contact:<input type="text" name="Follow-UpContact" value="<?php echo $myrow["Follow-UpContact"]?>"><br>
Customer Not Reached:<input type="text" name="CustomerNotReached" value="<?php echo $myrow["CustomerNotReached"]?>"><br>
<input type="Submit" name="submit" value="Enter Information">
</form>
<?php
}
}else{
$result=mysql_query("SELECT FROM keycadros",$db);
while($myrow=mysql_fetch_array($result)){
printf("<a href=\"%s?id=%s\">%s %s</a><br>\n", $PHP_SELF, $myrow["id"], $myrow["ServiceAdvisorID"], $myrow["CU#"], $myrow["CUNAME"], $myrow["CUHOME"], $myrow["CUWORK"], $myrow["RO#"], $myrow["VIN"], $myrow["Tech#"], $myrow["ProcessedDate"], $myrow["ServiceDate"], $myrow["Follow-UpContact"], $myrow["CustomerNotReached"]);
}
}
?>

Here is the error:
Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /usr/home/v1/a0020386/html/customers/keycadillac/indexsave.php on line 46

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /usr/home/v1/a0020386/html/customers/keycadillac/indexsave.php on line 47

Thanks in advance:mad:

[ahundiak]

It's probably not a good idea to use # in a table column name (or even as a php name for that matter).
CU# and RO#
Not sure if that is the problem.

Following your mysql_query statements with
if (mysql_errno()) die(mysql_error());

Will probably give you a hint as to where the problem is.

[raouleduke]

I got it to work, but when I click on the link, it doesn't update
the form fields to the id#, and does not update the database,
could the cause of this be that I don't have all the fields listed.
Please help!