| Information
Saved /* 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='text'"; $result = MYSQL_QUERY($query); }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',body='$body' WHERE item='$item'"; $result = MYSQL_QUERY($query); } $time = date("h:i s");?> Back |
|