Two Step MySql update - Big Noobie Question

[Micah_D]

Here's what I am doing:

I am building a IP tracking table that logs an IP Address, and how many times it has been hit.

What I need help with:

• how to find the IP in the table

• how to use the update query to update the field entry with the IP in it!

[insectis]

To find an IP:

$query = "SELECT * FROM log WHERE ip = '$ipAddy'";
$result = mysql_query($query);

To print the results:

while ($rows = mysql_fetch_array($result))
     echo $rows['ip'] . "<br>";

To update a row:

$query = "UPDATE log SET numHits = '$num' WHERE ip = '$ip'";
$result = mysql_query($query);

hth,

insectis

[Micah_D]

hey thanks, let me put something together, and see if it works for me!

[Micah_D]

so psuedo code please overview...

//find if one exist
$query = "SELECT * FROM log WHERE ip = '$ipAddy'";
if ($result = mysql_query($query))
{
    //Update Row
    $query = "UPDATE log SET numHits = '$num' WHERE ip = '$ip'"; 
    $result = mysql_query($query);
}
else
{
   // Insert new Entry
}

am I getting close?

[insectis]

Actually, this will probably get what you want done:

//find if one exist
$query = "SELECT * FROM log WHERE ip = '$ipAddy' LIMIT 1";
$result = mysql_query($query);
$numResults = mysql_num_rows($result);
if ($numResults > 0)
{
    //Update Row
    $rows = mysql_fetch_array($result);
    $query = "UPDATE log SET numHits = '$num' WHERE ip = '" . $rows['ip'] ."'"; 
    $result = mysql_query($query);
}
else
{
   // Insert new Entry
}

[Micah_D]

OK, I am still having a problem...

Err.... Wrong parameter count for mysql_db_query()

           //Update Row 
           $rows = mysql_fetch_array($result); 
		   $num = $rows['NumberTimesHit'] + 1;
           $querys = "UPDATE PounderPits_homepage SET NumberTimesHit = '$num' WHERE ClientIP = '" . $rows['ClientIP'] ."'";  

           $results = mysql_db_query($querys); 

It is a cut and paste of your code, just with modified variable names. Thanks for the help, and please continue...

[insectis]

Use mysql_query instead of mysql_db_query.

If you use mysql_db_query you have to specify your database as a parameter. See www.php.net/mysql_db_query

[insectis]

By the way, I looked at your website, those are some nice looking pits you've got!!

I've been thinking about getting a pitbull lately... 😉

[Micah_D]

BTW that does the trick, ms_query... I have to figure out how to increment the counter, but that is another question, and I think I have the know how already...

You should ask some questions in the forum, it is really new right now, but I'd be more than happy to answer any questions... they're great dogs...

the site needs people to get on it so other people will leave messages too!

[insectis]

In that case, I'm heading over there right now! Glad I could be of help. 😉

If in the future, you need any help writing that IP logger, just PM me, I wrote a fairly unique one awhile back, it tracks each unique IP per day and then it adds up how many hits each IP had for that day. Finally it reports in a nice little table your daily/weekly/monthly traffic.