| /* declare some relevant variables */ $hostname = "mysql.whiz.to"; $username = "hhe"; $dbpassword = "hhe"; $userstable = "photos"; $dbName = "hhe"; /* make connection to database */ MYSQL_CONNECT($hostname, $username, $dbpassword) OR DIE("Unable to connect to database"); @mysql_select_db( "$dbName") or die( "Unable to select database"); $query = "SELECT * FROM $userstable WHERE item='$p'"; $result = MYSQL_QUERY($query); $number = MYSQL_NUMROWS($result); $i = 0; IF ($number == 0) : ELSEIF ($number > 0) : $query = "UPDATE $userstable SET name='$name',body='$body',type='$type',admin='100' WHERE item='$item'"; $result = MYSQL_QUERY($query); ENDIF; $queryb = "SELECT * FROM $userstable ORDER BY item ASC"; $resultb = MYSQL_QUERY($queryb); $numberb = MYSQL_NUMROWS($resultb); $ib = 0; IF ($numberb == 0) : ELSEIF ($numberb > 0) : WHILE ($ib < $numberb): $item = mysql_result($resultb,$ib,"item"); $item++; $ib++; ENDWHILE; ENDIF; ?> $time = date("h:i s");?> | |