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
