$sql = "SELECT accessIP FROM `access` ORDER BY `accessID` DESC"; $sql_result = mysql_query($sql, $connection) or die ("Could not get Query");
if (db_num_rows() > 0) { // Update view where ip = visitor_ip } else { // Normal insert $sql = "INSERT INTO `access` (`accessID`, `accessIP`, `accessDNS`, `accessTIME`, `accessUPDATE`, `accessVIEW`) VALUES ('', '$proxy_ip', '$proxy_dns', '$add_date', NOW(NULL), '0')"; $result = mysql_query($sql); } this gives me Fatal error: Call to undefined function: db_num_rows() in d:\hosting\crushme\index.php on line 20 anyone helo me fix this ----- Original Message ----- From: "Philip J. Newman" <[EMAIL PROTECTED]> To: "Julio Nobrega Trabalhando" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, March 20, 2002 8:46 AM Subject: Re: [PHP] Re: [NEWMAN] make an "if" or "else if" statement from mysql. > if (db_num_rows() > 0) { > > mysql_query("UPDATE access SET access VIEW= accessVIEW+1 WHERE accessIP > = accessIP"); // Update view where ip = visitor_ip > > } else { > > $sql = "INSERT INTO `access` (`accessID`, `accessIP`, `accessDNS`, > `accessTIME`, `accessUPDATE`, `accessVIEW`) VALUES ('', '$proxy_ip', > '$proxy_dns', '$add_date', NOW(NULL), '0')"; > $result = mysql_query($sql); > > } > > if (db_num_rows() > 0) { <= WHERE DOSE THIS VERABLE COME FROM? > > ----- Original Message ----- > From: "Julio Nobrega Trabalhando" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Wednesday, March 20, 2002 8:45 AM > Subject: [PHP] Re: [NEWMAN] make an "if" or "else if" statement from mysql. > > > > Select before to see if exists: > > > > if (db_num_rows() > 0) { > > // Update view where ip = visitor_ip > > } else { > > // Normal insert > > } > > > > -- > > > > Julio Nobrega. > > > > Um dia eu chego lá: > > http://sourceforge.net/projects/toca > > > > Ajudei? Salvei? Que tal um presentinho? > > http://www.submarino.com.br/wishlistclient.asp?wlid=664176742884 > > > > > > "Philip J. Newman" <[EMAIL PROTECTED]> wrote in message > > 003401c1cf85$1afe54c0$0401a8c0@philip">news:003401c1cf85$1afe54c0$0401a8c0@philip... > > I have a log of IP numbers that come to WEBSITE A > > > > $sql = "INSERT INTO `access` (`accessID`, `accessIP`, `accessDNS`, > > `accessTIME`, `accessUPDATE`, `accessVIEW`) VALUES ('', '$proxy_ip', > > '$proxy_dns', '$add_date', NOW(NULL), '0')"; > > > > This has worked well, how ever when someone comes back with the same > > "accessIP" then I would like then "accessVIEW" aadds a +1 to the value. > > > > I would like help to create this .. > > > > > > if (!$remote_addr) <- if the ip that they are using is the same as one in > > the table then update the record and use the accessID for that record. > > > > else if there isn't that $remote_addr in the table then it is added. > > > > I have yet to start on the code, so would some direction. > > > > Philip J. Newman > > PhilipNZ :: Design Solutions > > http://www.philipnz.com/ > > [EMAIL PROTECTED] > > ICQ# 20482482 > > +64 25 6144012 > > > > > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php