Jump to content

[SOLVED] Simple Query Failing


hellonoko

Recommended Posts

I am using a simple query that I have basically copied from another part of my code where it works perfectly but for some reason I can't see it errors now:

<?php

// connect the db
include_once "connectotron.php";

echo 'updating file sizes...<br>';

$query = mysql_query("SELECT * FROM `mp3links` WHERE `scraped` = '1'");

while ($row = mysql_fetch_array($query))
{

	$file =  '/home2/sharingi/public_html/scrape/scraped/'.$row[sourcefile];

	echo $file_size = filesize($file);
	echo '<br>';

	$update = $row[sourcefile];

	// set the file size
	$query = "UPDATE `mp3links` SET `size` = '$file_size' WHERE `sourcefile` = '$update'";
	$result = mysql_query($query) or die (mysql_error());

}
?>

 

Error:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home2/sharingi/public_html/scrape/update_sizes.php on line 10

 

When I comment out the last two lines of my code it works fine listing all the file sizes. Is there something wrong with my update query I cant see?

 

Thanks

Link to comment
https://forums.phpfreaks.com/topic/155323-solved-simple-query-failing/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.