[SOLVED] PHP Error

[jj20051]

Ok I Built A Simple Billing Script, but I Get This Error:

 

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/billing2/public_html/email.php on line 14

 

Here Is The Script Code:

 

<?php
$dbhost = 'localhost';
$dbuser = 'billing2_admin';
$dbpass = 'a3a471';

$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die                      ('Error connecting to mysql');

$dbname = 'billing2_ptc';
mysql_select_db($dbname);

$day=date("j");
$sql="SELECT * FROM `invoices` WHERE `day`={$day}";
$query=mysql_query($sql);
while ($req=mysql_fetch_array($query)) {
mail($req['UserEmail'], "You must pay for protection.", "You haven't paid for protection. You have one day to pay or god may strike down your building.");
}
?> 

[Lamez]

change

<?php
$sql="SELECT * FROM `invoices` WHERE `day`={$day}";
while ($req=mysql_fetch_array($query)) {
?>

to

<?php
$sql=mysql_query("SELECT * FROM `invoices` WHERE `day`={$day}");
while ($req=mysql_fetch_array($sql)) {
?>

[MadTechie]

i assume it a date problem but try this to check

$query=mysql_query($sql) or die(mysql_error());

[jj20051]

Ok With That It Says The Query Was Empty ( The or die Strand )

[Lamez]

when in doubt echo out!

echo out $day!

[jj20051]

Well The Day String Does Exactly What I Wanted It To Do... Spits Out The Number 14, Witch Is Today's Date...

[Lamez]

ok in your query take out the {} and replace them with ' '

 

so like this: $sql="SELECT * FROM `invoices` WHERE `day`= '$day'";

 

[jj20051]

Same Thing, It Spits Out The Date and Says Query Is Empty...

[PFMaBiSmAd]

Start by posting your current actual code.

 

The error does not mean a query with zero rows in it. It means no SQL statement was sent to the mysql server.

[jj20051]

I Pretty Much Figured On That Much ( I Send 0's All The Time with No Problems ) Here Is My Current Code Minus The Database Connection...

 

$day=date("j");
echo "$day";
$sql=mysql_query("SELECT * FROM invoices WHERE day='$day'");
$query=mysql_query($sql) or die(mysql_error());
while ($req=mysql_fetch_array($sql)) {
mail($req['UserEmail'], "You must pay for protection.", "You haven't paid for protection. You have one day to pay or god may strike down your building.");


}

[MadTechie]

No no.. your querying a result change to this

<?php
$day=date("j");
$sql="SELECT * FROM invoices WHERE day='$day'";
$query=mysql_query($sql) or die($sql.mysql_error());
while ($req=mysql_fetch_array($query)) {
mail($req['UserEmail'], "You must pay for protection.", "You haven't paid for protection. You have one day to pay or god may strike down your building.");
}
?>

 

if you get an error please give us that exact error

[Andy-H]

<?php
$day=date("j");
$sql="SELECT * FROM invoices WHERE day='$day'";
$query=mysql_query($sql) or die($sql.mysql_error());
while ($req=mysql_fetch_array($query) && mysql_num_rows($query) != 0) {
mail($req['UserEmail'], "You must pay for protection.", "You haven't paid for protection. You have one day to pay or god may strike down your building.");
}
?>

[jj20051]

Good News and Bad News... The Script No Longer Spits Out An Error, but It Doesn't Send The Email Out Either...

[jj20051]

Good News and Bad News... The Script No Longer Spits Out An Error, but It Doesn't Send The Email Out Either...

[DoddsAntS]

have a try of the following

<?php
$day=date("j");
$sql="SELECT * FROM invoices WHERE day='$day'";
$query=mysql_query($sql) or die($sql.mysql_error());
if(mysql_num_rows($query) > 0) {
while ($req=mysql_fetch_array($query)) {
	if(mail($req['UserEmail'], "You must pay for protection.", "You haven't paid for protection. You have one day to pay or god may strike down your building.")) {
		echo "Sent email to {$req['UserEmail']}\n<br />\n";
	}
	else {
		echo "Failed to send email to {$req['UserEmail']}\n<br />\n";
	}
}
}
else {
echo "No results!";
}
?>

 

Regards,

 

A

[jj20051]

Thank You So Much, I Was Beggining To Feel Like I Would Never Get It To Work...