not sure why this is happening...

el_kab0ng

Typical error...

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in blah.php on line 13

Code:

$sql = "SELECT * FROM tbl where Status = 'Expired' and to_days(now()) - to_days(Dated) >= 2";
$connection = mysql_connect("localhost", "user", "pass")
or die ("Couldn't connect to server.");
$db = mysql_select_db("db")
or die ("Database could not be selected. Please inform the Administrator.");
$sql_result = mysql_query($sql)
or die("Selection of expired posts could not be obtained. Please inform the Administrator.");
if (mysql_num_rows ($sql_result) == 0) { 
echo "No expired records at this time.";
exit;
} else {
while ($row = mysql_fetch_array($sql_result)) {
// ^^ line 13 ^^
$id = $row["ID"];
$name = $row["Name"];

Any thoughts?

Svarog

well, try to put brackets in sql statement

$sql = "SELECT * FROM tbl where Status = 'Expired' and (to_days(now()) - to_days(Dated)) >= 2";

and always probe a mysql query

$sql_result = mysql_query($sql) or die("sql result failed");

it seems to me that you're getting no result and you can not fetch the query result

el_kab0ng

I'll give that a shot and see if it works. Thanks!

el_kab0ng

Ok.. so it didn't matter about the brackets, but I did some more testing..

I think the problem lies within what I do after that loop. What I am trying to achieve is something like this:

$sql = "SELECT * FROM tbl where (to_days(now()) - to_days(Dated) >= 2) and Status = 'Expired'";
$connection = mysql_connect("localhost", "user", "pass")
or die ("Couldn't connect to server.");
$db = mysql_select_db("db")
or die ("Database could not be selected. Please inform the Administrator.");
$sql_result = mysql_query($sql)
or die("Selection of expired posts could not be obtained. Please inform the Administrator.");
if (mysql_num_rows ($sql_result) == 0) { 
echo "No expired records worth moving at this time.";
exit;
} else {
while ($row = mysql_fetch_array($sql_result)) {
$id = $row["ID"];
$name = $row["Name"];
$email = $row["Email"];

$sql2 = "INSERT INTO tbl2 VALUES ('$id', '$name', '$email')";
$connection = mysql_connect("localhost", "user", "pass")
or die ("Couldn't connect to server.");
$db = mysql_select_db("db")
or die ("Database could not be selected. Please inform the Administrator.");
$sql_result = mysql_query($sql2)
or die ("Items could not be inserted. Please inform the Administrator.);
// or die("Addition could not be made to the past. Please inform the Administrator.");
}
}

I was able to remove the second half and just echo the looped items just fine, but the problem lies where I try to insert the looped values into another table.

So you see, I want to suck out the data that's 2 days or older and insert the values into another table.

Where am I going wrong with this?

Svarog

um, problem is that the result of first mysql query is stored in $sql_result and inside a loop you're overwriting that object executing another query

I would do something like this:

$sql = "SELECT * FROM tbl where (to_days(now()) - to_days(Dated) >= 2) and Status = 'Expired'";
$connection = mysql_connect("localhost", "user", "pass")
or die ("Couldn't connect to server.");
$db = mysql_select_db("db")
or die ("Database could not be selected. Please inform the Administrator.");
$sql_result = mysql_query($sql)
or die("Selection of expired posts could not be obtained. Please inform the Administrator.");
if (mysql_num_rows ($sql_result) != 0) { 
while ($row = mysql_fetch_array($sql_result)) {
mysql_query("INSERT INTO tbl2 VALUES ('".$row["ID"]." '".$row["Name"]."', '".$row["Email"]."')")
or die ("Items could not be inserted. Please inform the Administrator.);
}

} else {
echo "No expired records worth moving at this time.";
}

el_kab0ng

So I added in your suggestions, and expanded it a little bit, and now I still get breaks.

$sql = "Select * from tbl where Status = 'Expired' and to_days(now()) - to_days(Dated) >= 2";
$connection = mysql_connect("localhost", "user", "pass")
or die ("Couldn't connect to server.");
$db = mysql_select_db("db")
or die ("Database could not be selected. Please inform the Administrator.");
$sql_result = mysql_query($sql)
or die("Preliminary check coould not be completed. Please inform the Administrator.");
if_(mysql_num_rows_($sql_result)_>_0)_{
// ^^ line 10 ^^
while_($row_=_mysql_fetch_array($sql_result))_{
mysql_query("INSERT INTO tbl2 VALUES (\"".$row["ID"]."\", \"".$row["Name"]."\", \"".$row["Email"]."\", \"".$row["Item4"]."\", \"".$row["Item5"]."\", \"".$row["Item6"]."\", \"".$row["Item7"]."\", \"".$row["Item8"]."\", \"".$row["Item9"]."\"")")
		or_die_("Items could not be inserted. Please inform the Administrator.");
}
} else {
echo "No_expired_records_worth_moving_at_this_time.";
}

Returns:

Parse error: parse error, unexpected T_STRING in blah.php on line 10

el_kab0ng

The above is another case where the forums have screwed up a paste. the _'s are not there in my code.