supprimer une ligne sql et php

[cr500]

salut voila j aimerais savoir kel est le SCRIPT qui me permet de supprimer une ligne de ma table en php

es ce ?

$connection = mysql_connect("$host","$user","$pass");
@mysql_connect($host,$user,$pass) or die("Impossible de se connecter à la base de données"); 
@mysql_select_db("$bdd") or die("Impossible de se connecter à la base de données");


$commandesupp = "DELATED * FROM $table WHERE email='$email''";
$result1 = mysql_query("$commandesupp",$connection);

 

[fredsoft]

$commandesupp = "DELETE * FROM $table WHERE email='$email''";

 

[pc07]

ta syntaxe sql n'est pas la bonne,

c "DELETE FROM nom_de_la_table WHERE conditions"

Donc dans ton cas ca donne "DELETE FROM $table WHERE email='$email'"

 

[jeano0o]

Comment supprimer cette requête SVp
INSERT INTO phpbb_config (config_name, config_value) VALUES ('sitemap_enable', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('sitemap_cache_time', '96');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('sitemap_priority_0', '0.5');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('sitemap_priority_1', '0.5');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('sitemap_priority_2', '0.5');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('sitemap_priority_3', '0.5');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('sitemap_freq_0', 'daily');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('sitemap_freq_1', 'daily');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('sitemap_freq_2', 'daily');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('sitemap_freq_3', 'daily');