<?php
function dbconnect(){
$dbh=mysql_connect ("******", "******", "******") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("******");
}
$dbname = "*******"; $urlname = "parteditlists.php";
function drawtable2($id, $company, $division, $contact, $address1, $city, $state, $zip, $voice, $fax, $email, $dbname, $urlname){
echo "
<form action='do_editlists.php?action=edit&id={$id}&db={$dbname}&url={$urlname}' method='post' enctype='application/x-www-form-urlencoded' name='editpartmembers{$id}'>
<table width='760' border='0' cellspacing='0' cellpadding='0'>
<tr align='center'>
<td width='9'><font color='#000000' size='1' face='Arial, Helvetica, sans-serif'> </font></td>
<td width='18'><font color='#000000' size='1' face='Arial, Helvetica, sans-serif'> </font></td>
<td width='144' align='center'><font color='#000000' size='1' face='Arial, Helvetica, sans-serif'>company</font></td>
<td width='145' align='center'><font color='#000000' size='1' face='Arial, Helvetica, sans-serif'>division</font></td>
<td width='146' align='center'><font color='#000000' size='1' face='Arial, Helvetica, sans-serif'>contact</font></td>
<td width='147' align='center'><font color='#000000' size='1' face='Arial, Helvetica, sans-serif'>address</font></td>
<td width='151' align='center'><font color='#000000' size='1' face='Arial, Helvetica, sans-serif'>city</font></td>
</tr>
<tr>
<td colspan='2' align='center'><font size='1' face='Arial, Helvetica, sans-serif'><a href='javascript:if(confirm(\"Do you really want to edit this entry?\")){this.document.editpartmembers{$id}.submit();}'>edit</a></font><font size='1' face='Arial, Helvetica, sans-serif'><br><a href='javascript:if(confirm(\"Do you really want to delete this entry?\")){window.open(\"do_editlists.php?action=delete&id={$id}&db={$dbname}&url={$urlname}\",\"_self\");}'>delete</a></font></td>
<td align='center'><font size='1' face='Arial, Helvetica, sans-serif'> <textarea name='company' cols='15' rows='2'>{$company}</textarea></font></td>
<td align='center'><font size='1' face='Arial, Helvetica, sans-serif'> <textarea name='division' cols='15' rows='2'>{$division}</textarea></font></td>
<td align='center'><font size='1' face='Arial, Helvetica, sans-serif'> <textarea name='contact' cols='15' rows='2'>{$contact}</textarea></font></td>
<td align='center'><font size='1' face='Arial, Helvetica, sans-serif'> <textarea name='address1' cols='15' rows='2'>{$address1}</textarea></font></td>
<td align='center'><font size='1' face='Arial, Helvetica, sans-serif'> <textarea name='city' cols='15' rows='2'>{$city}</textarea></font></td>
</tr>
<tr>
<td colspan='2' rowspan='2' align='center'> </td>
<td align='center'><font color='#000000' size='1' face='Arial, Helvetica, sans-serif'>state</font></td>
<td align='center'><font color='#000000' size='1' face='Arial, Helvetica, sans-serif'>zip</font></td>
<td align='center'><font color='#000000' size='1' face='Arial, Helvetica, sans-serif'>voice</font></td>
<td align='center'><font color='#000000' size='1' face='Arial, Helvetica, sans-serif'>fax</font></td>
<td align='center'><font color='#000000' size='1' face='Arial, Helvetica, sans-serif'>email</font></td>
</tr>
<tr>
<td align='center'><font size='1' face='Arial, Helvetica, sans-serif'> <textarea name='state' cols='15' rows='2'>{$state}</textarea></font></td>
<td align='center'><font size='1' face='Arial, Helvetica, sans-serif'> <textarea name='zip' cols='15' rows='2'>{$zip}</textarea></font></td>
<td align='center'><font size='1' face='Arial, Helvetica, sans-serif'> <textarea name='voice' cols='15' rows='2'>{$voice}</textarea></font></td>
<td align='center'><font size='1' face='Arial, Helvetica, sans-serif'> <textarea name='fax' cols='15' rows='2'>{$fax}</textarea></font></td>
<td align='center'><font size='1' face='Arial, Helvetica, sans-serif'> <textarea name='email' cols='15' rows='2'>{$email}</textarea></font></td>
</tr>
</table>
</form>";
}
?> <html> <head> <title>New York One Call - Participating Members Administration Page</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<font color="#000000" size="2" face="Arial, Helvetica, sans-serif"><strong>New York One Call<br>Participating Members List Add Form.</strong><br>
<br></font>
<form action="do_editlists.php?action=add&db=nypartmembers&url=parteditlists.php" method="post" enctype="application/x-www-form-urlencoded" name="addmembers">
<table width="305" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="111"><font color="#000000" size="2" face="Arial, Helvetica, sans-serif">Company Name:</font></td>
<td width="194" align="left"><font color="#000000" size="2" face="Arial, Helvetica, sans-serif"><input name="company" type="text" size="30"></font></td>
</tr>
<tr>
<td width="111"><font color="#000000" size="2" face="Arial, Helvetica, sans-serif">Company Division:</font></td>
<td width="194" align="left"><font color="#000000" size="2" face="Arial, Helvetica, sans-serif"><input name="division" type="text" size="30"></font></td>
</tr>
<tr>
<td><font color="#000000" size="2" face="Arial, Helvetica, sans-serif">Contact Name:</font></td>
<td align="left"><font color="#000000" size="2" face="Arial, Helvetica, sans-serif"><input name="contact" type="text" size="30"></font></td>
</tr>
<tr>
<td><font color="#000000" size="2" face="Arial, Helvetica, sans-serif">Address:</font></td>
<td align="left"><font color="#000000" size="2" face="Arial, Helvetica, sans-serif"><input name="address1" type="text" size="30"></font></td>
</tr>
<tr>
<td><font color="#000000" size="2" face="Arial, Helvetica, sans-serif">City:</font></td>
<td align="left"><font color="#000000" size="2" face="Arial, Helvetica, sans-serif"><input name="city" type="text" size="30"></font></td>
</tr>
<tr>
<td><font color="#000000" size="2" face="Arial, Helvetica, sans-serif">State:</font></td>
<td align="left"><font color="#000000" size="2" face="Arial, Helvetica, sans-serif"><input name="state" type="text" size="30"></font></td>
</tr>
<tr>
<td><font color="#000000" size="2" face="Arial, Helvetica, sans-serif">Zip:</font></td>
<td align="left"><font color="#000000" size="2" face="Arial, Helvetica, sans-serif"><input name="zip" type="text" size="30"></font></td>
</tr>
<tr>
<td><font color="#000000" size="2" face="Arial, Helvetica, sans-serif">Voice Number:</font></td>
<td align="left"><font color="#000000" size="2" face="Arial, Helvetica, sans-serif"><input name="voice" type="text" size="30"></font></td>
</tr>
<tr>
<td><font color="#000000" size="2" face="Arial, Helvetica, sans-serif">Fax Number:</font></td>
<td align="left"><font color="#000000" size="2" face="Arial, Helvetica, sans-serif"><input name="fax" type="text" size="30"></font></td>
</tr>
<tr>
<td><font color="#000000" size="2" face="Arial, Helvetica, sans-serif">Email:</font></td>
<td align="left"><font color="#000000" size="2" face="Arial, Helvetica, sans-serif"><input name="email" type="text" size="30"></font></td>
</tr>
<tr align="center">
<td><font color="#000000" size="2" face="Arial, Helvetica, sans-serif"> </font></td>
<td align="left"><font color="#000000" size="2" face="Arial, Helvetica, sans-serif"><input type="submit" name="Submit" value="Submit"><input name="reset" type="reset" id="reset" value="Reset"></font></td>
</tr>
</table>
</form>
<br>
<a href="http://www.nycli1calldsi.com/lists/partmemtest.php"; target="_blank"><font color="#000000" size="2" face="Arial, Helvetica, sans-serif">Display the Participating Members page.</font></a><br>
<br>
<font color="#000000" size="2" face="Arial, Helvetica, sans-serif"><strong>New York One Call<br>Participating Members List Edit Form.</strong></font><br>
<?php
dbconnect();
$query = "SELECT * FROM {$dbname} ORDER BY company";
$result = mysql_query( $query )
or die ( "MySQL Error - " . mysql_errno() . ": " . mysql_error() );
$numresult = mysql_num_rows($result);for($i=0; $i<$numresult; $i++){
$row = mysql_fetch_array($result);
drawtable2($row['id'], $row['company'], $row['division'], $row['contact'], $row['address1'], $row['city'], $row['state'], $row['zip'], $row['voice'], $row['fax'], $row['email'], $dbname, $urlname);
}
?>
</body> </html>
_________________________________________________________________
Tired of spam? Get advanced junk mail protection with MSN 8. http://join.msn.com/?page=features/junkmail
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
