[RESOLVED] using php to get_contents, strip unwanted info, insert to db

[planethax]

There are many sites that have Nascar standings.
They all seem to be updated at exact same time.
So I am assuming most go some place, grab the info to update their own site (CNN, Yahoo, SI, Msn, Nascar etc)

So this is all I am wanting to do.
I have a program to do this, but would rather to it server side with php once a week.

So, so far I am able to get the contents, but can someone please help me $strip the
Header (and all info before table) and all info after table.

Then I think I can use fgetss to remove html tags so I can insert into database.

The following comes up with a blank page, I believe I am using $strip functions incorrectly, hopfully someone can point me in right direction here.

<?php
$fh = fopen("http://sports.yahoo.com/nascar/standings", "rb");

$file = file_get_contents("http://sports.yahoo.com/nascar/standings");


fclose($fh);
$contents = $file

$split1 = "<script language="javascript">
yearList = document.f1.year;
typeList = document.f1.type_index;
buildSelect(yearList,years,0);
updateType(0);

</script>"; // end of google header - this may change so keep tabs on googles source code
    $split2 = "<table width="100%" border="0" cellspacing="0" cellpadding="0">

 <tr>
  <td height="7">"; // beginning of  footer - this may also change - see above

$results = explode($split1, $contents); // seperate header from page

//print_r($results); // use to check array in debugging

$topchunk = $results[0]; // google header, which we wont be using
$midchunk = $results[1]; // the rest of the page, which includes the body and footer

$results2 = explode($split2, $midchunk); // seperate footer from page

$body = $results2[0]; // the page without the header or footer

echo $body;
?> 

[faisalmajeed]

dont have your solution, but for discussion I am thinking this is more complicated than acquiring the table.
The tabular data would have to be read into the right fields, so there needs to be logic to identify which record goes to which field.
I am guessing someone here must have figured this out

[bpat1434]

Here's something I whipped up based on regular expressions. They're relatively simple in nature. Just took some time looking at the HTML that was produced by Yahoo! and scraping that for the data.

The easier solution would be to find an RSS feed of this stuff and grab that since then you could use SimpleXML to do all this.

The code I paste will give you an array of data in this format:

Array
(
    [contention] => Array
        (
            [1] => Array
                (
                    [rank] => 1
                    [rank_delta] => -
                    [driver] => Tony Stewart
                    [points] => 3383
                    [behind] => Leader
                    [start] => 22
                    [poles] => 4
                    [wins] => 3
                    [top5] => 13
                    [top10] => 18
                    [dnf] => 0
                    [winnings] => $5,084,829
                )

        [2] => Array
            (
                [rank] => 2
                [rank_delta] => -
                [driver] => Jimmie Johnson
                [points] => 3123
                [behind] => 260
                [start] => 22
                [poles] => 1
                [wins] => 3
                [top5] => 9
                [top10] => 14
                [dnf] => 1
                [winnings] => $4,607,420
            )

            ....

[field] => Array
    (
        [13] => Array
            (
                [rank] => 13
                [rank_delta] => -
                [driver] => Kyle Busch
                [points] => 2627
                [behind] => 756
                [start] => 22
                [poles] => 1
                [wins] => 3
                [top5] => 5
                [top10] => 7
                [dnf] => 2
                [winnings] => $4,044,855
            )

        [14] => Array
            (
                [rank] => 14
                [rank_delta] => -
                [driver] => Brian Vickers
                [points] => 2589
                [behind] => 794
                [start] => 22
                [poles] => 5
                [wins] => 0
                [top5] => 3
                [top10] => 10
                [dnf] => 3
                [winnings] => $3,070,173
            )
    )
)

<?php
$url = 'http://sports.yahoo.com/nascar/standings';
$html = file_get_contents($url);

// First, get that one single table.
preg_match('~(<table width="100&#37;" border="0" cellspacing="0" cellpadding="0">.*<tr.*class="ysptblthbody1".*>.*</table>)~iUs', $html, $matches);

// $matches[0] is now the full match (e.g. the whole $html content)
// $matches[1] is just the table we need

// We'll split it up between those in the contention and those not
preg_match('~(<tr class="ysprow(?:1|2)">.*)<tr><td.*><img.*></td></tr>(<tr class="ysprow(?:1|2)".*>.*</tr>.*)</table>~iUs', $matches[1], $parts);

// $parts[1] are those in contention
// $parts[2] are the other drivers in the field

// Look for all the information for those in contention, save to $matches
preg_match_all('~<tr class="ysprow.*">.*<td.*>.*([\d]*)</td>.*<td.*>([+|-][\d]*)</td><td class=".*padded2px.*".*>.*<a.*>(.*)</a></td>.*<td class=".*ysptblclbg6.*".*>(.*)</td>.*<td.*>(.*)</td><td.*>(.*)</td><td.*>(.*)</td><td.*>(.*)</td><td.*>(.*)</td><td.*>(.*)</td><td.*>(.*)</td><td.*>(.*)</td>.*</tr>~iUs', $parts[1], $matches, PREG_SET_ORDER);

// Look for all the information for the other drivers, store in $matches2
preg_match_all('~<tr class="ysprow.*">.*<td.*>.*([\d]*)</td>.*<td.*>([+|-][\d]*)</td><td class=".*padded2px.*".*>.*<a.*>(.*)</a></td>.*<td class=".*ysptblclbg6.*".*>(.*)</td>.*<td.*>(.*)</td><td.*>(.*)</td><td.*>(.*)</td><td.*>(.*)</td><td.*>(.*)</td><td.*>(.*)</td><td.*>(.*)</td><td.*>(.*)</td>.*</tr>~iUs', $parts[2], $matches2, PREG_SET_ORDER);

// Prepare our array for population
$drivers = array(
    'contention' => array(),
    'field' => array()
);

// Add the drivers in contention
foreach($matches as $match)
{
    $drivers['contention'][$match[1]] = array(
        'rank' => $match[1],
        'rank_delta' => $match[2],
        'driver' => $match[3],
        'points' => $match[4],
        'behind' => $match[5],
        'start' => $match[6],
        'poles' => $match[7],
        'wins' => $match[8],
        'top5' => $match[9],
        'top10' => $match[10],
        'dnf' => $match[11],
        'winnings' => $match[12]
    );
}

// Add those drivers that are in the rest of the field
foreach($matches2 as $match)
{
    $drivers['field'][$match[1]] = array(
        'rank' => $match[1],
        'rank_delta' => $match[2],
        'driver' => $match[3],
        'points' => $match[4],
        'behind' => $match[5],
        'start' => $match[6],
        'poles' => $match[7],
        'wins' => $match[8],
        'top5' => $match[9],
        'top10' => $match[10],
        'dnf' => $match[11],
        'winnings' => $match[12]
    );
}

echo '<pre>'.print_r($drivers, 1).'</pre>';

Hope that helps.

[planethax]

bpat1434;10924670 wrote:

Here's something I whipped up based on regular expressions. ........

Hope that helps.

You sir are amazing!!!

Thank you every so much!!!!

Now I need to insert all this into my database.

What would be the best and easiest format as to be able to then retrieve info and insert into my own table?

1 table (standings)
12 Fields (rank, rankdelta,driver,points etc) ?

[planethax]

Well this is what I have so far, I created the table and fields,
Just not sure if it is the best format to be able to insert to db, then retrieve to insert into a table.

CREATE TABLE `standings` (
   `rank` INT,
   `rank_delta` INT,
   `driver` TEXT,
   `points` INT,
   `behind` INT,
   `start` INT,
   `poles` INT,
   `wins` INT,
   `top5` INT,
   `top10` INT,
   `dnf` INT,
   `winnings` BIGINT
) 

Now to insert into database, I am thinking I will need to you
"foreach" statements?

[planethax]

Ok, I have been doing some reading, along with previous question, I have a second question as well.

Should I be serializing and unserializing these arrays?

[planethax]

I was hoping the following would do the trick, but it causes a blank page 🙁

Am I close though?

// Connect and select database
$link = mysqli_connect("localhost", "user", "password", "dbname") or die('Could not connect');

// now, you either update in a loop like so:

foreach ($drivers) {
    $result = mysqli_query("UPDATE table SET Build = 'standings' WHERE Area='$drivers'");
    echo "$drivers updated. <";
}

[bpat1434]

Personally, if I were to do this, I would create 1 table and put all the information in it. I would structure it as so:

CREATE TABLE `nascar_standings` (
    `id` INT AUTO_INCREMENT PRIMARY KEY,
    `race_week` INT NOT NULL,
    `rank` INT NOT NULL,
    `rank_delta` VARCHAR(5),
    `driver` TEXT NOT NULL,
    `points` INT NOT NULL,
    `behind` VARCHAR(20),
    `start` INT,
    `poles` INT,
    `wins` INT,
    `top5` INT,
    `top10` INT,
    `dnf` INT,
    `winnings` VARCHAR(15),
    `in_contention` INT DEFAULT '0',
    UNIQUE (`race_week`)
) ENGINE=InnoDB COMMENT="Nascar Standings from Yahoo!";

Now, for the race_week column, I would do an extra scrape to get the exact race week we were getting the standings for. Then when I go to update, I'd first check if race_week is already in the database, and if so, then skip it (since the standings shouldn't change without a race); otherwise, insert it.

You're correct in that it would have to be done in a foreach loop; however, given my array of users, I might modify the code just a bit and create an array more along the lines of:

$drivers = array(
    'contention' => array(),
    'field' => array()
);

// Add the drivers in contention
foreach($matches as $match)
{
    $drivers[$match[1]] = array(
        'rank' => $match[1],
        'rank_delta' => $match[2],
        'driver' => $match[3],
        'points' => $match[4],
        'behind' => $match[5],
        'start' => $match[6],
        'poles' => $match[7],
        'wins' => $match[8],
        'top5' => $match[9],
        'top10' => $match[10],
        'dnf' => $match[11],
        'winnings' => $match[12],
        'in_contention' => 1
    );
}

foreach($matches2 as $match)
{
    $drivers[$match[1]] = array(
        'rank' => $match[1],
        'rank_delta' => $match[2],
        'driver' => $match[3],
        'points' => $match[4],
        'behind' => $match[5],
        'start' => $match[6],
        'poles' => $match[7],
        'wins' => $match[8],
        'top5' => $match[9],
        'top10' => $match[10],
        'dnf' => $match[11],
        'winnings' => $match[12],
        'in_contention' => 0
    );
}

Giving me an array like:

Array(
[1] => Array
                (
                    [rank] => 1
                    [rank_delta] => -
                    [driver] => Tony Stewart
                    [points] => 3383
                    [behind] => Leader
                    [start] => 22
                    [poles] => 4
                    [wins] => 3
                    [top5] => 13
                    [top10] => 18
                    [dnf] => 0
                    [winnings] => $5,084,829
                    [in_contention] => 1
                )

        [2] => Array
            (
                [rank] => 2
                [rank_delta] => -
                [driver] => Jimmie Johnson
                [points] => 3123
                [behind] => 260
                [start] => 22
                [poles] => 1
                [wins] => 3
                [top5] => 9
                [top10] => 14
                [dnf] => 1
                [winnings] => $4,607,420
                [in_contention] => 1
            )
  ....
[13] => Array
                (
                    [rank] => 13
                    [rank_delta] => -
                    [driver] => Kyle Busch
                    [points] => 2627
                    [behind] => 756
                    [start] => 22
                    [poles] => 1
                    [wins] => 3
                    [top5] => 5
                    [top10] => 7
                    [dnf] => 2
                    [winnings] => $4,044,855
                    [in_contention] => 0
                )

        [14] => Array
            (
                [rank] => 14
                [rank_delta] => -
                [driver] => Brian Vickers
                [points] => 2589
                [behind] => 794
                [start] => 22
                [poles] => 5
                [wins] => 0
                [top5] => 3
                [top10] => 10
                [dnf] => 3
                [winnings] => $3,070,173
                [in_contention] => 0
            )
)

To which I would then do:

foreach($drivers as $driver)
{
    $query = sprintf("INSERT INTO `nascar_standings` 
					(`race_week`, `rank`, `rank_delta`, `driver`, `points`, `behind`, `start`, `poles`, `wins`, `top5`, `top10`, `dnf`, `winnings`, `in_contention`)
					VALUES (%d, %d, '%s', %d, '%s', %d, %d, %d, %d, %d, '%s', %d)",
			intval($race_week),
			intval($driver['rank']),
			mysql_real_escape_string($driver['driver']),
			intval($driver['points']),
			mysql_real_escape_string($driver['behind']),
			intval($driver['start']),
			intval($driver['poles']),
			intval($driver['wins']),
			intval($driver['top5']),
			intval($driver['top10']),
			intval($driver['dnf']),
			mysql_real_escape_string($driver['winnings']),
			intval($driver['in_contention'])
);
    $result = mysql_query($query);
    if(!$result)
    {
        die('Unable to make the full update!<br />'.mysql_error());
    }
}

echo 'Completed update.';

Hope that helps.

FYI: $race_week would be scraped out of the info we have already received from Yahoo! Sports.

[planethax]

hmmm, couple things, this does not seem to be filling the database, hope the connect string is correct?
Plus, I just started from the last line of the code you supplied earlier

echo '<pre>'.print_r($drivers, 1).'</pre>'; 

// Connect and select database
$link = mysqli_connect("localhost", "ninfouser", "mypassword", "ninfo") or die('Could not connect');



foreach($drivers as $driver)

Also, reading through this I am a bit confused, will this just update the stats each week? or add new ones each week?

(hoping to just update the fields with new stats each week)

Thanx again!

[bpat1434]

This would actually insert new stats each week; however, if you use the race_week value, you can order by that DESC to get the latest. You could also add a "added" or "created" column to which you can have it be a timestamp and then order by that DESC to get the latest.

Can you show your whole code? I don't think you're taking into account the structure of the array, and your SQL query code is getting messed up.

[planethax]

Ok, started fresh.
I made a new database called ninfo with a user ninfouser,

Ran your query making table and feilds successfully,

Ran the page, the arrays printed to browser, but database is still empty.

This is my complete code except password ********* out

I am also still confuse about the weeks, as all point are accumilative, will this (when I get it working) write over the current stats each week?

Thank you again.

<?php
$url = 'http://sports.yahoo.com/nascar/standings';
$html = file_get_contents($url);

// First, get that one single table.
preg_match('~(<table width="100%" border="0" cellspacing="0" cellpadding="0">.*<tr.*class="ysptblthbody1".*>.*</table>)~iUs', $html, $matches);

// $matches[0] is now the full match (e.g. the whole $html content)
// $matches[1] is just the table we need

// We'll split it up between those in the contention and those not
preg_match('~(<tr class="ysprow(?:1|2)">.*)<tr><td.*><img.*></td></tr>(<tr class="ysprow(?:1|2)".*>.*</tr>.*)</table>~iUs', $matches[1], $parts);

// $parts[1] are those in contention
// $parts[2] are the other drivers in the field

// Look for all the information for those in contention, save to $matches
preg_match_all('~<tr class="ysprow.*">.*<td.*>.*([\d]*)</td>.*<td.*>([+|-][\d]*)</td><td class=".*padded2px.*".*>.*<a.*>(.*)</a></td>.*<td class=".*ysptblclbg6.*".*>(.*)</td>.*<td.*>(.*)</td><td.*>(.*)</td><td.*>(.*)</td><td.*>(.*)</td><td.*>(.*)</td><td.*>(.*)</td><td.*>(.*)</td><td.*>(.*)</td>.*</tr>~iUs', $parts[1], $matches, PREG_SET_ORDER);

// Look for all the information for the other drivers, store in $matches2
preg_match_all('~<tr class="ysprow.*">.*<td.*>.*([\d]*)</td>.*<td.*>([+|-][\d]*)</td><td class=".*padded2px.*".*>.*<a.*>(.*)</a></td>.*<td class=".*ysptblclbg6.*".*>(.*)</td>.*<td.*>(.*)</td><td.*>(.*)</td><td.*>(.*)</td><td.*>(.*)</td><td.*>(.*)</td><td.*>(.*)</td><td.*>(.*)</td><td.*>(.*)</td>.*</tr>~iUs', $parts[2], $matches2, PREG_SET_ORDER);

// Prepare our array for population
$drivers = array(
    'contention' => array(),
    'field' => array()
);

// Add the drivers in contention
foreach($matches as $match)
{
    $drivers[$match[1]] = array(
        'rank' => $match[1],
        'rank_delta' => $match[2],
        'driver' => $match[3],
        'points' => $match[4],
        'behind' => $match[5],
        'start' => $match[6],
        'poles' => $match[7],
        'wins' => $match[8],
        'top5' => $match[9],
        'top10' => $match[10],
        'dnf' => $match[11],
        'winnings' => $match[12],
        'in_contention' => 1
    );
}

foreach($matches2 as $match)
{
    $drivers[$match[1]] = array(
        'rank' => $match[1],
        'rank_delta' => $match[2],
        'driver' => $match[3],
        'points' => $match[4],
        'behind' => $match[5],
        'start' => $match[6],
        'poles' => $match[7],
        'wins' => $match[8],
        'top5' => $match[9],
        'top10' => $match[10],
        'dnf' => $match[11],
        'winnings' => $match[12],
        'in_contention' => 0
    );
} 
echo '<pre>'.print_r($drivers, 1).'</pre>'; 

// Connect and select database
$link = mysqli_connect("localhost", "ninfouser", "*******", "ninfo") or die('Could not connect');



foreach($drivers as $driver)
{
    $query = sprintf("INSERT INTO `nascar_standings`
                    (`race_week`, `rank`, `rank_delta`, `driver`, `points`, `behind`, `start`, `poles`, `wins`, `top5`, `top10`, `dnf`, `winnings`, `in_contention`)
                    VALUES (%d, %d, '%s', %d, '%s', %d, %d, %d, %d, %d, '%s', %d)",
            intval($race_week),
            intval($driver['rank']),
            mysql_real_escape_string($driver['driver']),
            intval($driver['points']),
            mysql_real_escape_string($driver['behind']),
            intval($driver['start']),
            intval($driver['poles']),
            intval($driver['wins']),
            intval($driver['top5']),
            intval($driver['top10']),
            intval($driver['dnf']),
            mysql_real_escape_string($driver['winnings']),
            intval($driver['in_contention'])
);
    $result = mysql_query($query);
    if(!$result)
    {
        die('Unable to make the full update!<br />'.mysql_error());
    }
}

echo 'Completed update.'; 

PS, I have a feeling my connecting to db may be wrong?

[bpat1434]

You know what, I forgot to remove the "contention => array()" and "field => array()" from the initial $drivers creation. So this:

$drivers = array(
    'contention' => array(),
    'field' => array()
);

should be this:

$drivers = array();

Each week this will would create a new row for each driver instead of updating a single row. So there would be 62 rows per week that you have. The only reason I do this is because it may be nice if you perhaps wanted to show the progression from week to week for a particular driver (or even graph the standings of the contenders in a line-graph or something).

[planethax]

Ok, I changed that, but still not filling in db,
the browser shows the array, but nothing after that.

I have been changing my connect method but still nothing.

I even tried the following thinking it would at least print an error, but still nothing.

Page only prints initial array (last printed part in browser is array #62)

my msql version is

MySQL 4.1.22 running on localhost as ninfouser@localhost

$mysqli = new mysqli('localhost', 'ninfouser', '********', 'ninfo');

/*
 * This is the "official" OO way to do it,
 * BUT $connect_error was broken until PHP 5.2.9 and 5.3.0.

if ($mysqli->connect_error) {
    die('Connect Error (' . $mysqli->connect_errno . ') '
            . $mysqli->connect_error);
}
 */
/*
 * Use this instead of $connect_error if you need to ensure
 * compatibility with PHP versions prior to 5.2.9 and 5.3.0.
 */
if (mysqli_connect_error()) {
    die('Connect Error (' . mysqli_connect_errno() . ') '
            . mysqli_connect_error());
}

echo 'Success... ' . $mysqli->host_info . "\n";

foreach($drivers as $driver)

[planethax]

Well I keep making changes as trial & error (more error than anything lol)

By using the following code I now get messages printed to browser

Connected successfullyUnable to make the full update!
No database selected

echo '<pre>'.print_r($drivers, 1).'</pre>'; 

$link = mysql_connect('localhost', 'ninfouser', '********', 'ninfo');
if (!$link) {
    die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';


foreach($drivers as $driver)
{
    $query = sprintf("INSERT INTO `nascar_standings`
                    (`race_week`, `rank`, `rank_delta`, `driver`, `points`, `behind`, `start`, `poles`, `wins`, `top5`, `top10`, `dnf`, `winnings`, `in_contention`)
                    VALUES (%d, %d, '%s', %d, '%s', %d, %d, %d, %d, %d, '%s', %d)",
            intval($race_week),
            intval($driver['rank']),
            mysql_real_escape_string($driver['driver']),
            intval($driver['points']),
            mysql_real_escape_string($driver['behind']),
            intval($driver['start']),
            intval($driver['poles']),
            intval($driver['wins']),
            intval($driver['top5']),
            intval($driver['top10']),
            intval($driver['dnf']),
            mysql_real_escape_string($driver['winnings']),
            intval($driver['in_contention'])
);
    $result = mysql_query($query);
    if(!$result)
    {
        die('Unable to make the full update!<br />'.mysql_error());
    }
}

echo 'Completed update.'; 

I think that is because I changed to mysql from mysqli

If I put i back in, I go back to getting nothing but array printed to browser and db not filling.

I am sure its something small and stupid I have done.

[planethax]

Well I am closer anyways,
now I get

Success... Localhost via UNIX socket Unable to make the full update!
Column count doesn't match value count at row 1

with this code

echo '<pre>'.print_r($drivers, 1).'</pre>'; 

$link = mysql_connect('localhost', 'ninfouser', '********');
$select_db=mysql_select_db('ninfo');
if (!$link) {
    die('Connect Error (' . mysql_connect_errno() . ') '
            . mysqli_connect_error());
}

echo 'Success... ' . mysql_get_host_info($link) . "\n";;


foreach($drivers as $driver)
{
    $query = sprintf("INSERT INTO `nascar_standings`
                    (`race_week`, `rank`, `rank_delta`, `driver`, `points`, `behind`, `start`, `poles`, `wins`, `top5`, `top10`, `dnf`, `winnings`, `in_contention`)
                    VALUES (%d, %d, '%s', %d, '%s', %d, %d, %d, %d, %d, '%s', %d)",
            intval($race_week),
            intval($driver['rank']),
            mysql_real_escape_string($driver['driver']),
            intval($driver['points']),
            mysql_real_escape_string($driver['behind']),
            intval($driver['start']),
            intval($driver['poles']),
            intval($driver['wins']),
            intval($driver['top5']),
            intval($driver['top10']),
            intval($driver['dnf']),
            mysql_real_escape_string($driver['winnings']),
            intval($driver['in_contention'])
);
    $result = mysql_query($query);
    if(!$result)
    {
        die('Unable to make the full update!<br />'.mysql_error());
    }
}

echo 'Completed update.'; 

[planethax]

Ok, I think now this is what I am missing

FYI: $race_week would be scraped out of the info we have already received from Yahoo! Sports.

I will go back and see how to do this

EDIT: I have just read through the source code for the page, and see no reference to which race week it is, am I over looking it?

[planethax]

I even tried to remove all reference to race week in code and db but still get

Column count doesn't match value count at row 1

So I am not sure if that is the problem or not?

EDIT:
to add, I searched google for this error, added id to the query but also same error

    $query = sprintf("INSERT INTO `nascar_standings`
                    (`id`, `race_week`, `rank`, `rank_delta`, `driver`, `points`, `behind`, `start`, `poles`, `wins`, `top5`, `top10`, `dnf`, `winnings`, `in_contention`)
                    VALUES (%d, %d, '%s', %d, '%s', %d, %d, %d, %d, %d, '%s', %d)",

[planethax]

A little more info,

It seemed to me that the query was missing rank_delta so I added that with both id and with out
still same error

foreach($drivers as $driver)
{
    $query = sprintf("INSERT INTO `nascar_standings`
                    (`id`, `race_week`, `rank`, `rank_delta`, `driver`, `points`, `behind`, `start`, `poles`, `wins`, `top5`, `top10`, `dnf`, `winnings`, `in_contention`)
                    VALUES (%d, %d, '%s', %d, '%s', %d, %d, %d, %d, %d, '%s', %d)",
            intval($race_week),
            intval($driver['rank']),
			mysql_real_escape_string($driver['rank_delta']), 
            mysql_real_escape_string($driver['driver']),
            intval($driver['points']),
            mysql_real_escape_string($driver['behind']),
            intval($driver['start']),
            intval($driver['poles']),
            intval($driver['wins']),
            intval($driver['top5']),
            intval($driver['top10']),
            intval($driver['dnf']),
            mysql_real_escape_string($driver['winnings']),
            intval($driver['in_contention'])
);
    $result = mysql_query($query);
    if(!$result)
    {
        die('Unable to make the full update!<br />'.mysql_error());
    }
}

echo 'Completed update.'; 

[planethax]

This just not making sense to me.

So, I manually inserted a row with phpmyadmin.
Then copied the php code and it is the same as I have in the page

					(`id`, `race_week`, `rank`, `rank_delta`, `driver`, `points`, `behind`, `start`, `poles`, `wins`, `top5`, `top10`, `dnf`, `winnings`, `in_contention`)

[johanafm]

You have
INSERT INTO table(15 fields listed)
VALUES(12 values listed)
and sprintf gets 14 variables arguments for the 12 format specifiers in the VALUES list.

You need 15, 15, 15.