//add marker with comment system in it....bubble
function repopulate(){
mysql_connect("localhost","mmaaaco_ksecor","hamilton");
mysql_select_db("mmaaaco_mydb");
$whichImg = 'thumbnail.php?pic=sticky-notes.jpg&ht=30&wd=30';
$sql = mysql_query("select comments,location,xcoord,ycoord from critique");
while ($row = mysql_fetch_array($sql))
{
$comment = $row[0];
$location= $row[1];
$xcoord = $row[2];
$ycoord = $row[3];
echo '
'."\n";
}
//move_uploaded_file($_FILES['pic']['tmp_name'],$_FILES['pic']['name']);
}
?>
Critique
repopulate();
?>
/*
CREATE TABLE IF NOT EXISTS `critique` (
`id` int(5) NOT NULL auto_increment,
`comments` text NOT NULL,
`location` varchar(255) NOT NULL,
`xcoord` int(11) NOT NULL,
`ycoord` int(11) NOT NULL,
`picid` int(5) NOT NULL,
PRIMARY KEY (`id`)
)
*/
?>
/*
CREATE TABLE IF NOT EXISTS `critiquepics` (
`id` int(5) NOT NULL auto_increment,
`url` varchar(255) NOT NULL,
`description` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
*/
?>