Jun 04
mysql_insert_id()
Jun 04
mysql_affected_rows()
May 29
#drop trigger
DROP TRIGGER `TRIGGER_NAME`
#auto DateTime, Date, Time
CREATE TRIGGER `TRIGGER_NAME` BEFORE INSERT ON `TABLE_NAME`
FOR EACH ROW SET NEW.DATEFIELD = NOW()
#insert something in another table
CREATE TRIGGER `TRIGGER_NAME` AFTER INSERT ON `TABLE_NAME`
FOR EACH ROW
INSERT INTO another_table SET some_field = NEW.fieldfromparenttable, text_field = 'sometext'
#if statement
CREATE TRIGGER `TRIGGER_NAME` AFTER INSERT ON `TABLE_NAME`
FOR EACH ROW BEGIN
IF NEW.Type = 0 THEN
INSERT INTO another_table SET ParentType = NEW.Type;
END IF;
END
DROP TRIGGER `TRIGGER_NAME`
#auto DateTime, Date, Time
CREATE TRIGGER `TRIGGER_NAME` BEFORE INSERT ON `TABLE_NAME`
FOR EACH ROW SET NEW.DATEFIELD = NOW()
#insert something in another table
CREATE TRIGGER `TRIGGER_NAME` AFTER INSERT ON `TABLE_NAME`
FOR EACH ROW
INSERT INTO another_table SET some_field = NEW.fieldfromparenttable, text_field = 'sometext'
#if statement
CREATE TRIGGER `TRIGGER_NAME` AFTER INSERT ON `TABLE_NAME`
FOR EACH ROW BEGIN
IF NEW.Type = 0 THEN
INSERT INTO another_table SET ParentType = NEW.Type;
END IF;
END
May 28
Jul 10
<?
$query = mysql_query("SELECT name FROM Table");
while ($item = mysql_fetch_object($query)) {
echo $item->name;
echo "<br>";
}
?>
$query = mysql_query("SELECT name FROM Table");
while ($item = mysql_fetch_object($query)) {
echo $item->name;
echo "<br>";
}
?>
Jul 10
<?
header('Content-Type: text/html; charset=utf-8');
?>
header('Content-Type: text/html; charset=utf-8');
?>
<?
mysql_select_db("DataBase");
mysql_query("SET NAMES UTF8");
?>
Recent Comments