Delete something unless id=1?

[.:Jack120:.2]

Well, how do I make it so this deletes all the entrys unless the id of the entry is 1?
Code:

<?php
include "includes/config.php"; // config file

        $query = mysql_query("TRUNCATE TABLE `timefriday` ;");

        mysql_query("INSERT INTO `timefriday` VALUES ('00:00', '');") or exit("It didnt do it :(");
        mysql_query("INSERT INTO `timefriday` VALUES ('01:00', '');") or exit("It didnt do it :(");
        mysql_query("INSERT INTO `timefriday` VALUES ('02:00', '');") or exit("It didnt do it :(");
        mysql_query("INSERT INTO `timefriday` VALUES ('03:00', '');") or exit("It didnt do it :(");
        mysql_query("INSERT INTO `timefriday` VALUES ('04:00', '');") or exit("It didnt do it :(");
        mysql_query("INSERT INTO `timefriday` VALUES ('05:00', '');") or exit("It didnt do it :(");
        mysql_query("INSERT INTO `timefriday` VALUES ('06:00', '');") or exit("It didnt do it :(");
        mysql_query("INSERT INTO `timefriday` VALUES ('07:00', '');") or exit("It didnt do it :(");
        mysql_query("INSERT INTO `timefriday` VALUES ('08:00', '');") or exit("It didnt do it :(");
        mysql_query("INSERT INTO `timefriday` VALUES ('09:00', '');") or exit("It didnt do it :(");
        mysql_query("INSERT INTO `timefriday` VALUES ('10:00', '');") or exit("It didnt do it :(");
        mysql_query("INSERT INTO `timefriday` VALUES ('11:00', '');") or exit("It didnt do it :(");
        mysql_query("INSERT INTO `timefriday` VALUES ('12:00', '');") or exit("It didnt do it :(");
        mysql_query("INSERT INTO `timefriday` VALUES ('13:00', '');") or exit("It didnt do it :(");
        mysql_query("INSERT INTO `timefriday` VALUES ('14:00', '');") or exit("It didnt do it :(");
        mysql_query("INSERT INTO `timefriday` VALUES ('15:00', '');") or exit("It didnt do it :(");
        mysql_query("INSERT INTO `timefriday` VALUES ('16:00', '');") or exit("It didnt do it :(");
        mysql_query("INSERT INTO `timefriday` VALUES ('17:00', '');") or exit("It didnt do it :(");
        mysql_query("INSERT INTO `timefriday` VALUES ('18:00', '');") or exit("It didnt do it :(");
        mysql_query("INSERT INTO `timefriday` VALUES ('19:00', '');") or exit("It didnt do it :(");
        mysql_query("INSERT INTO `timefriday` VALUES ('20:00', '');") or exit("It didnt do it :(");
        mysql_query("INSERT INTO `timefriday` VALUES ('21:00', '');") or exit("It didnt do it :(");
        mysql_query("INSERT INTO `timefriday` VALUES ('21:00', '');") or exit("It didnt do it :(");
        mysql_query("INSERT INTO `timefriday` VALUES ('23:00', '');") or exit("It didnt do it :(");

?>

Thank You

[redtom]

DELETE FROM table WHERE id => 2 

Not sure but would somthing like that work?

[Invent]

DELETE FROM `table` WHERE `id` != '1'

[.:Jack120:.2]

DELETE FROM table WHERE id => 2 

Not sure but would somthing like that work?

nope

DELETE FROM `table` WHERE `id` != '1'

That worked but when I run it, I get 2 entries So I end up with two 05:00
Whats the code so it dosnt duplicate =]

[redtom]

nope

Change the => to >=

[.:Jack120:.2]

Change the => to >=

Im using invents (Ill +Rep you when/if I get my other account back for helping)

But because its our timetable and we dont want two 02:00 slots (Because one is id 1) how do we do it. we tried (Below) but didnt work.

        mysql_query("INSERT IGNORE INTO `timefriday` VALUES ('02:00', '', '');") or exit("It didnt do it :("); 

but still adds an id=0

[redtom]

Im using invents (Ill +Rep you when/if I get my other account back for helping)

But because its our timetable and we dont want two 02:00 slots (Because one is id 1) how do we do it. we tried (Below) but didnt work.

        mysql_query("INSERT IGNORE INTO `timefriday` VALUES ('02:00', '', '');") or exit("It didnt do it :("); 

but still adds an id=0

Wouldn't updating instead of inserting be easyer?

[.:Jack120:.2]

Wouldn't updating instead of inserting be easyer?

yea =]

Im crap with these

<?php
include "includes/config.php"; // config file
        mysql_query("UPDATE `timetest` SET ('00:00', '', '0') WHERE `id` != '1' ;") or exit("Could not import the sunday timetable data");
        mysql_query("UPDATE `timetest` SET ('01:00', '', '0') WHERE `id` != '1' ;") or exit("Could not import the sunday timetable data");
        mysql_query("UPDATE `timetest` SET ('02:00', '', '0') WHERE `id` != '1' ;") or exit("Could not import the sunday timetable data");
        mysql_query("UPDATE `timetest` SET ('03:00', '', '0') WHERE `id` != '1' ;") or exit("Could not import the sunday timetable data");
        mysql_query("UPDATE `timetest` SET ('04:00', '', '0') WHERE `id` != '1' ;") or exit("Could not import the sunday timetable data");
        mysql_query("UPDATE `timetest` SET ('05:00', '', '0') WHERE `id` != '1' ;") or exit("Could not import the sunday timetable data");
        mysql_query("UPDATE `timetest` SET ('06:00', '', '0') WHERE `id` != '1' ;") or exit("Could not import the sunday timetable data");
        mysql_query("UPDATE `timetest` SET ('07:00', '', '0') WHERE `id` != '1' ;") or exit("Could not import the sunday timetable data");
        mysql_query("UPDATE `timetest` SET ('08:00', '', '0') WHERE `id` != '1' ;") or exit("Could not import the sunday timetable data");
        mysql_query("UPDATE `timetest` SET ('09:00', '', '0') WHERE `id` != '1' ;") or exit("Could not import the sunday timetable data");
        mysql_query("UPDATE `timetest` SET ('10:00', '', '0') WHERE `id` != '1' ;") or exit("Could not import the sunday timetable data");
        mysql_query("UPDATE `timetest` SET ('11:00', '', '0') WHERE `id` != '1' ;") or exit("Could not import the sunday timetable data");
        mysql_query("UPDATE `timetest` SET ('12:00', '', '0') WHERE `id` != '1' ;") or exit("Could not import the sunday timetable data");
        mysql_query("UPDATE `timetest` SET ('13:00', '', '0') WHERE `id` != '1' ;") or exit("Could not import the sunday timetable data");
        mysql_query("UPDATE `timetest` SET ('14:00', '', '0') WHERE `id` != '1' ;") or exit("Could not import the sunday timetable data");
        mysql_query("UPDATE `timetest` SET ('15:00', '', '0') WHERE `id` != '1' ;") or exit("Could not import the sunday timetable data");
        mysql_query("UPDATE `timetest` SET ('16:00', '', '0') WHERE `id` != '1' ;") or exit("Could not import the sunday timetable data");
        mysql_query("UPDATE `timetest` SET ('17:00', '', '0') WHERE `id` != '1' ;") or exit("Could not import the sunday timetable data");
        mysql_query("UPDATE `timetest` SET ('18:00', '', '0') WHERE `id` != '1' ;") or exit("Could not import the sunday timetable data");
        mysql_query("UPDATE `timetest` SET ('19:00', '', '0') WHERE `id` != '1' ;") or exit("Could not import the sunday timetable data");
        mysql_query("UPDATE `timetest` SET ('20:00', '', '0') WHERE `id` != '1' ;") or exit("Could not import the sunday timetable data");
        mysql_query("UPDATE `timetest` SET ('21:00', '', '0') WHERE `id` != '1' ;") or exit("Could not import the sunday timetable data");
        mysql_query("UPDATE `timetest` SET ('22:00', '', '0') WHERE `id` != '1' ;") or exit("Could not import the sunday timetable data");
        mysql_query("UPDATE `timetest` SET ('23:00', '', '0') WHERE `id` != '1' ;") or exit("Could not import the sunday timetable data");

?>

[Beau]

yea =]

Im crap with these

<?php
include "includes/config.php"; // config file
        mysql_query("UPDATE `timetest` SET ('00:00', '', '0') WHERE `id` != '1' ;") or exit("Could not import the sunday timetable data");
        mysql_query("UPDATE `timetest` SET ('01:00', '', '0') WHERE `id` != '1' ;") or exit("Could not import the sunday timetable data");
        mysql_query("UPDATE `timetest` SET ('02:00', '', '0') WHERE `id` != '1' ;") or exit("Could not import the sunday timetable data");
        mysql_query("UPDATE `timetest` SET ('03:00', '', '0') WHERE `id` != '1' ;") or exit("Could not import the sunday timetable data");
        mysql_query("UPDATE `timetest` SET ('04:00', '', '0') WHERE `id` != '1' ;") or exit("Could not import the sunday timetable data");
        mysql_query("UPDATE `timetest` SET ('05:00', '', '0') WHERE `id` != '1' ;") or exit("Could not import the sunday timetable data");
        mysql_query("UPDATE `timetest` SET ('06:00', '', '0') WHERE `id` != '1' ;") or exit("Could not import the sunday timetable data");
        mysql_query("UPDATE `timetest` SET ('07:00', '', '0') WHERE `id` != '1' ;") or exit("Could not import the sunday timetable data");
        mysql_query("UPDATE `timetest` SET ('08:00', '', '0') WHERE `id` != '1' ;") or exit("Could not import the sunday timetable data");
        mysql_query("UPDATE `timetest` SET ('09:00', '', '0') WHERE `id` != '1' ;") or exit("Could not import the sunday timetable data");
        mysql_query("UPDATE `timetest` SET ('10:00', '', '0') WHERE `id` != '1' ;") or exit("Could not import the sunday timetable data");
        mysql_query("UPDATE `timetest` SET ('11:00', '', '0') WHERE `id` != '1' ;") or exit("Could not import the sunday timetable data");
        mysql_query("UPDATE `timetest` SET ('12:00', '', '0') WHERE `id` != '1' ;") or exit("Could not import the sunday timetable data");
        mysql_query("UPDATE `timetest` SET ('13:00', '', '0') WHERE `id` != '1' ;") or exit("Could not import the sunday timetable data");
        mysql_query("UPDATE `timetest` SET ('14:00', '', '0') WHERE `id` != '1' ;") or exit("Could not import the sunday timetable data");
        mysql_query("UPDATE `timetest` SET ('15:00', '', '0') WHERE `id` != '1' ;") or exit("Could not import the sunday timetable data");
        mysql_query("UPDATE `timetest` SET ('16:00', '', '0') WHERE `id` != '1' ;") or exit("Could not import the sunday timetable data");
        mysql_query("UPDATE `timetest` SET ('17:00', '', '0') WHERE `id` != '1' ;") or exit("Could not import the sunday timetable data");
        mysql_query("UPDATE `timetest` SET ('18:00', '', '0') WHERE `id` != '1' ;") or exit("Could not import the sunday timetable data");
        mysql_query("UPDATE `timetest` SET ('19:00', '', '0') WHERE `id` != '1' ;") or exit("Could not import the sunday timetable data");
        mysql_query("UPDATE `timetest` SET ('20:00', '', '0') WHERE `id` != '1' ;") or exit("Could not import the sunday timetable data");
        mysql_query("UPDATE `timetest` SET ('21:00', '', '0') WHERE `id` != '1' ;") or exit("Could not import the sunday timetable data");
        mysql_query("UPDATE `timetest` SET ('22:00', '', '0') WHERE `id` != '1' ;") or exit("Could not import the sunday timetable data");
        mysql_query("UPDATE `timetest` SET ('23:00', '', '0') WHERE `id` != '1' ;") or exit("Could not import the sunday timetable data");

?>

The above works? Or do you still need help?

[.:Jack120:.2]

The above works? Or do you still need help?

Still need help please =]