$link = mysql_connect('127.0.0.1', 'desk', 'd3sk') or die('Could not connect: ' . mysql_error());
mysql_select_db('desk') or die('Could not select database');
$query = "SELECT * FROM desk.notes where deleted = 'F' ";
$result = mysql_query($query) or die('Query failed: ' . mysql_error());
?>
Tistaert.com
while ($row = mysql_fetch_assoc($result)) {
$noteClass = 'noteYellow';
$canDelete = $row['canDelete'];
if ($canDelete == 'T'){
$noteClass = 'noteBlue';
} else {
$noteClass = 'noteYellow';
}
$id = $row['id']; ?>
if ($canDelete == 'T') { ?>
} ?>
} ?>
-[Create New Note]-
$query = "SELECT max(id) as mx FROM notes n";
$result = mysql_query($query);
$maxNote = 1;
if ($row = mysql_fetch_assoc($result)) {
$maxNote = $row['mx'];
}
$query = "SELECT max(z) as mx FROM notes n where canDelete = 'T'";
$result = mysql_query($query);
$maxZ = 100;
if ($row = mysql_fetch_assoc($result)) {
$maxZ = $row['mx'];
}
?>