par
badibad » 19 août 2005, 14:00
merci mais voilla je n'y arrive toujour pas je ne sais pas comment fair
Code : Tout sélectionner
<?PHP
$db = mysql_connect('sql.free.fr', 'xx', 'xx');
mysql_select_db('singeroyonnax',$db);
$sql = 'SELECT * FROM depannage';
$req = mysql_query($sql) or die('Erreur SQL !
'.$sql.'
'.mysql_error());
while($data = mysql_fetch_array($req))
{
?>
<table height="82" cellSpacing="0" cellPadding="0" width="100%" background="http://singeroyonnax.free.fr/admin/images/logo-banner_bg.gif" border="0">
<tr>
<td background="http://singeroyonnax.free.fr/admin/images/logo-banner_bg.gif">
<a href="#">
<img height="82" src="http://singeroyonnax.free.fr/admin/images/admin_logo.gif" width="211" border="0"></a>
</td>
<td> </td>
<td width="462" background="http://singeroyonnax.free.fr/admin/images/admin_logo_right.gif" height="82">
<table height="72" cellSpacing="0" cellPadding="0" width="100%" border="0">
<tr>
<td class="headerBarContent" align="middle">
<font color="#333333" size="1"><strong>If you would like
professional hosting and real support<br>
for this application please go to:<br>
<a class="headerLink" href="http://singeroyonnax.free.fr/admin/www.chainreactionweb.com">
www.chainreactionweb.com</a> </strong></font></td>
</tr>
<tr>
<td class="headerBarContent" align="middle">
<a class="headerLink" target="_blank" href="http://phesis.cool-networks.net/index.php">
Help Desk</a> |
<a class="headerLink" href="http://www.chainreactionweb.com/">
Chainreactionweb</a> |
<a class="headerLink" href="http://www.oscommerce.com">
osCommerce</a> |
<a class="headerLink" href="http://singeroyonnax.free.fr/">
Catalog</a> |
<a class="headerLink" href="http://singeroyonnax.free.fr/admin/index.php">
Administration</a>|
<a class="headerLink" href="http://singeroyonnax.free.fr/admin/logoff.php">
Se Déconnecter</a> </td>
</tr>
</table>
</td>
</tr>
</table>
<!-- Menu bar #1. -->
<div class="menuBar" style="WIDTH: 100%">
<a class="menuButton" onmouseover="buttonMouseover(event, 'administratorMenu');" onclick="return buttonClick(event, 'administratorMenu');">
Administrateur</a><a class="menuButton" onmouseover="buttonMouseover(event, 'configurationMenu');" onclick="return buttonClick(event, 'configurationMenu');">Configuration</a><a class="menuButton" onmouseover="buttonMouseover(event, 'catalogMenu');" onclick="return buttonClick(event, 'catalogMenu');">Catalogue</a><a class="menuButton" onmouseover="buttonMouseover(event, 'informationMenu');" onclick="return buttonClick(event, 'informationMenu');">Info
système</a><a class="menuButton" onmouseover="buttonMouseover(event, 'newsdeskMenu');" onclick="return buttonClick(event, 'newsdeskMenu');">Newsdesk</a><a class="menuButton" onmouseover="buttonMouseover(event, 'faqdeskMenu');" onclick="return buttonClick(event, 'faqdeskMenu');">FAQDesk</a><a class="menuButton" onmouseover="buttonMouseover(event, 'modulesMenu');" onclick="return buttonClick(event, 'modulesMenu');">Modules</a><a class="menuButton" onmouseover="buttonMouseover(event, 'gv_adminMenu');" onclick="return buttonClick(event, 'gv_adminMenu');">Bon
d'achat/Coupons</a><a class="menuButton" onmouseover="buttonMouseover(event, 'customersMenu');" onclick="return buttonClick(event, 'customersMenu');">Clients</a><a class="menuButton" onmouseover="buttonMouseover(event, 'paypalipnMenu');" onclick="return buttonClick(event, 'paypalipnMenu');">Paypal
IPN</a></div>
<!-- Menu bar #2. -->
<div class="menuBar" style="WIDTH: 100%">
<a class="menuButton" onmouseover="buttonMouseover(event, 'affiliateMenu');" onclick="return buttonClick(event, 'affiliateMenu');">
Affiliations</a><a class="menuButton" onmouseover="buttonMouseover(event, 'taxesMenu');" onclick="return buttonClick(event, 'taxesMenu');">Lieux
/ Taxes</a><a class="menuButton" onmouseover="buttonMouseover(event, 'localizationMenu');" onclick="return buttonClick(event, 'localizationMenu');">Localisation</a><a class="menuButton" onmouseover="buttonMouseover(event, 'design_controlsMenu');" onclick="return buttonClick(event, 'design_controlsMenu');">Contrôle
du Design</a><a class="menuButton" onmouseover="buttonMouseover(event, 'linksMenu');" onclick="return buttonClick(event, 'linksMenu');">Liens
Manager</a><a class="menuButton" onmouseover="buttonMouseover(event, 'reportsMenu');" onclick="return buttonClick(event, 'reportsMenu');">Rapports</a><a class="menuButton" onmouseover="buttonMouseover(event, 'toolsMenu');" onclick="return buttonClick(event, 'toolsMenu');">Outils</a></div>
<p><b>Depannage</b></p>
<table border="1" width="586" height="365">
<tr>
<td><b>Prenom:</b> <?php echo($data['firstname']); ?></td>
</tr>
<tr>
<td><b>Nom:</b> <?php echo($data['name']); ?></td>
</tr>
<tr>
<td><b>Email:</b> <?php echo($data['email']); ?></td>
</tr>
<tr>
<td><b>Nom de la société:</b> <?php echo($data['company']); ?></td>
</tr>
<tr>
<td><b>Tva intercom:</b> <?php echo($data['tva_intracom']); ?></td>
</tr>
<tr>
<td><b>Adresse:</b> <?php echo($data['street_address']); ?></td>
</tr>
<tr>
<td><b>Quartier:</b> <?php echo($data['suburb']); ?></td>
</tr>
<tr>
<td><b>Code postal:</b> <?php echo($data['postcode']); ?></td>
</tr>
<tr>
<td><b>Ville:</b> <?php echo($data['city']); ?></td>
</tr>
<tr>
<td><b>Departement:</b> <?php echo($data['state']); ?></td>
</tr>
<tr>
<td><b>Pays:</b> <?php echo($data['country']); ?></td>
</tr>
<tr>
<td><b>Telephone:</b> <?php echo($data['telephone']); ?></td>
</tr>
<tr>
<td><b>Fax:</b> <?php echo($data['fax']); ?></td>
</tr>
<tr>
<td><b>Type:</b> <?php echo($data['type']); ?></td>
</tr>
<tr>
<td><b>Quantite:</b> <?php echo($data['quantite']); ?></td>
</tr>
<tr>
<td><b>Reference:</b> <?php echo($data['reference']); ?></td>
</tr>
<tr>
<td><b>Composant:</b> <?php echo($data['composant']); ?></td>
</tr>
</table> <?php
}
$sql = "DELETE FROM table WHERE champ_identifiant = '". $id_element ."';";
mysql_close();
?>
merci d'vance si tu peur m'aider[/code]
merci mais voilla je n'y arrive toujour pas je ne sais pas comment fair
[code]<?PHP
$db = mysql_connect('sql.free.fr', 'xx', 'xx');
mysql_select_db('singeroyonnax',$db);
$sql = 'SELECT * FROM depannage';
$req = mysql_query($sql) or die('Erreur SQL !
'.$sql.'
'.mysql_error());
while($data = mysql_fetch_array($req))
{
?>
<table height="82" cellSpacing="0" cellPadding="0" width="100%" background="http://singeroyonnax.free.fr/admin/images/logo-banner_bg.gif" border="0">
<tr>
<td background="http://singeroyonnax.free.fr/admin/images/logo-banner_bg.gif">
<a href="#">
<img height="82" src="http://singeroyonnax.free.fr/admin/images/admin_logo.gif" width="211" border="0"></a>
</td>
<td> </td>
<td width="462" background="http://singeroyonnax.free.fr/admin/images/admin_logo_right.gif" height="82">
<table height="72" cellSpacing="0" cellPadding="0" width="100%" border="0">
<tr>
<td class="headerBarContent" align="middle">
<font color="#333333" size="1"><strong>If you would like
professional hosting and real support<br>
for this application please go to:<br>
<a class="headerLink" href="http://singeroyonnax.free.fr/admin/www.chainreactionweb.com">
www.chainreactionweb.com</a> </strong></font></td>
</tr>
<tr>
<td class="headerBarContent" align="middle">
<a class="headerLink" target="_blank" href="http://phesis.cool-networks.net/index.php">
Help Desk</a> |
<a class="headerLink" href="http://www.chainreactionweb.com/">
Chainreactionweb</a> |
<a class="headerLink" href="http://www.oscommerce.com">
osCommerce</a> |
<a class="headerLink" href="http://singeroyonnax.free.fr/">
Catalog</a> |
<a class="headerLink" href="http://singeroyonnax.free.fr/admin/index.php">
Administration</a>|
<a class="headerLink" href="http://singeroyonnax.free.fr/admin/logoff.php">
Se Déconnecter</a> </td>
</tr>
</table>
</td>
</tr>
</table>
<!-- Menu bar #1. -->
<div class="menuBar" style="WIDTH: 100%">
<a class="menuButton" onmouseover="buttonMouseover(event, 'administratorMenu');" onclick="return buttonClick(event, 'administratorMenu');">
Administrateur</a><a class="menuButton" onmouseover="buttonMouseover(event, 'configurationMenu');" onclick="return buttonClick(event, 'configurationMenu');">Configuration</a><a class="menuButton" onmouseover="buttonMouseover(event, 'catalogMenu');" onclick="return buttonClick(event, 'catalogMenu');">Catalogue</a><a class="menuButton" onmouseover="buttonMouseover(event, 'informationMenu');" onclick="return buttonClick(event, 'informationMenu');">Info
système</a><a class="menuButton" onmouseover="buttonMouseover(event, 'newsdeskMenu');" onclick="return buttonClick(event, 'newsdeskMenu');">Newsdesk</a><a class="menuButton" onmouseover="buttonMouseover(event, 'faqdeskMenu');" onclick="return buttonClick(event, 'faqdeskMenu');">FAQDesk</a><a class="menuButton" onmouseover="buttonMouseover(event, 'modulesMenu');" onclick="return buttonClick(event, 'modulesMenu');">Modules</a><a class="menuButton" onmouseover="buttonMouseover(event, 'gv_adminMenu');" onclick="return buttonClick(event, 'gv_adminMenu');">Bon
d'achat/Coupons</a><a class="menuButton" onmouseover="buttonMouseover(event, 'customersMenu');" onclick="return buttonClick(event, 'customersMenu');">Clients</a><a class="menuButton" onmouseover="buttonMouseover(event, 'paypalipnMenu');" onclick="return buttonClick(event, 'paypalipnMenu');">Paypal
IPN</a></div>
<!-- Menu bar #2. -->
<div class="menuBar" style="WIDTH: 100%">
<a class="menuButton" onmouseover="buttonMouseover(event, 'affiliateMenu');" onclick="return buttonClick(event, 'affiliateMenu');">
Affiliations</a><a class="menuButton" onmouseover="buttonMouseover(event, 'taxesMenu');" onclick="return buttonClick(event, 'taxesMenu');">Lieux
/ Taxes</a><a class="menuButton" onmouseover="buttonMouseover(event, 'localizationMenu');" onclick="return buttonClick(event, 'localizationMenu');">Localisation</a><a class="menuButton" onmouseover="buttonMouseover(event, 'design_controlsMenu');" onclick="return buttonClick(event, 'design_controlsMenu');">Contrôle
du Design</a><a class="menuButton" onmouseover="buttonMouseover(event, 'linksMenu');" onclick="return buttonClick(event, 'linksMenu');">Liens
Manager</a><a class="menuButton" onmouseover="buttonMouseover(event, 'reportsMenu');" onclick="return buttonClick(event, 'reportsMenu');">Rapports</a><a class="menuButton" onmouseover="buttonMouseover(event, 'toolsMenu');" onclick="return buttonClick(event, 'toolsMenu');">Outils</a></div>
<p><b>Depannage</b></p>
<table border="1" width="586" height="365">
<tr>
<td><b>Prenom:</b> <?php echo($data['firstname']); ?></td>
</tr>
<tr>
<td><b>Nom:</b> <?php echo($data['name']); ?></td>
</tr>
<tr>
<td><b>Email:</b> <?php echo($data['email']); ?></td>
</tr>
<tr>
<td><b>Nom de la société:</b> <?php echo($data['company']); ?></td>
</tr>
<tr>
<td><b>Tva intercom:</b> <?php echo($data['tva_intracom']); ?></td>
</tr>
<tr>
<td><b>Adresse:</b> <?php echo($data['street_address']); ?></td>
</tr>
<tr>
<td><b>Quartier:</b> <?php echo($data['suburb']); ?></td>
</tr>
<tr>
<td><b>Code postal:</b> <?php echo($data['postcode']); ?></td>
</tr>
<tr>
<td><b>Ville:</b> <?php echo($data['city']); ?></td>
</tr>
<tr>
<td><b>Departement:</b> <?php echo($data['state']); ?></td>
</tr>
<tr>
<td><b>Pays:</b> <?php echo($data['country']); ?></td>
</tr>
<tr>
<td><b>Telephone:</b> <?php echo($data['telephone']); ?></td>
</tr>
<tr>
<td><b>Fax:</b> <?php echo($data['fax']); ?></td>
</tr>
<tr>
<td><b>Type:</b> <?php echo($data['type']); ?></td>
</tr>
<tr>
<td><b>Quantite:</b> <?php echo($data['quantite']); ?></td>
</tr>
<tr>
<td><b>Reference:</b> <?php echo($data['reference']); ?></td>
</tr>
<tr>
<td><b>Composant:</b> <?php echo($data['composant']); ?></td>
</tr>
</table> <?php
}
$sql = "DELETE FROM table WHERE champ_identifiant = '". $id_element ."';";
mysql_close();
?> [/code]
merci d'vance si tu peur m'aider[/code]