/* declare some relevant variables */
$hostname = "mysql.whiz.to";
$username = "lodging";
$dbpassword = "lodging";
$userstable = "photos";
$dbName = "lodging";
/* 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");
IF($new=="new"){
$query = "INSERT INTO $userstable SET item='',clientlink='$clientlink',pagename='$pagename',name='$name',body='$body',type='$type'";
$result = MYSQL_QUERY($query);
$queryb = "SELECT * FROM $userstable WHERE clientlink='$clientlink'AND pagename='$pagename'AND name='$name'AND body='$body'AND type='$type'";
$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");
$clientlink = mysql_result($resultb,$ib,"clientlink");
$ib++;
ENDWHILE; ENDIF;
}ELSE{
$queryb = "SELECT * FROM $userstable WHERE item='$p'";
$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");
$clientlink = mysql_result($resultb,$ib,"clientlink");
$ib++;
ENDWHILE; ENDIF;
$query = "UPDATE $userstable SET pagename='$pagename',name='$name',type='$type' WHERE item='$item'";
$result = MYSQL_QUERY($query);
}
?>
Information
Saved
|
}?>
|
Back
|
| |