[Dillon]

Hello I am making a website in php, and mysql, and I am getting this error at the top of one of the pages, does anyone know what it means, and how to fix it? Thanks alot!

The error is:
Warning: mysql_numrows(): supplied argument is not a valid MySQL result resource in /home/halescom/public_html/FBLA_Reservation/providerinfo.php on line 15

Heres the code:

PHP Code:

<?



$areacode = $_GET["areacode"];

$phonenum = $_GET["phonenum"];

$provider = $_GET["provider"];



include ('providerinfo.php');



$num = $areacode . $phonenum . $to;



echo ("this is what it got $num");



//This is the MySQL Information

$username="**";

$password="*****";

$database="****";



//This tells to connect to the MySQL Database, via the provided information above

mysql_connect(localhost,$username,$password);

@mysql_select_db($database) or die( "Unable to select database");



//The query is to insert data into the "Info" table

$query = "INSERT INTO `txtusers` (`mobile`) VALUES ('$num')";

//$result = mysql_query($query);

mysql_close();



?>

-Dillon

[phpdoctor]

Looks like the error is coming from 'providerinfo.php'
Could you show us the code in that file?

[Dillon]

Here ya go

PHP Code:

<?



if( $provider == "Alltel" ) {



$to = "$num@message.Alltel.com";

$subject = "CONFIRMATION";

$body = "$confirmmessage";



if (mail($to, $subject, $body)) {

include ('providerpage.php');

}



}



if( $provider == "AT&T" ) {



$to = "$num@txt.att.net";

$subject = "CONFIRMATION";

$body = "$confirmmessage";



if (mail($to, $subject, $body)) {

include ('providerpage.php');

}



}



if( $provider == "Cingular" ) {



$to = "$num@cingularme.com ";

$subject = "CONFIRMATION";

$body = "$confirmmessage";



if (mail($to, $subject, $body)) {

include ('providerpage.php');

}



}



if( $provider == "Nextel" ) {



$to = "$num@messaging.nextel.com  ";

$subject = "CONFIRMATION";

$body = "$confirmmessage";



if (mail($to, $subject, $body)) {

include ('providerpage.php');

}



}



if( $provider == "Sprint" ) {



$to = "$num@messaging.sprintpcs.com ";

$subject = "CONFIRMATION";

$body = "$confirmmessage";



if (mail($to, $subject, $body)) {

include ('providerpage.php');

}



}



if( $provider == "SunCom" ) {



$to = "$num@tms.suncom.com ";

$subject = "CONFIRMATION";

$body = "$confirmmessage";



if (mail($to, $subject, $body)) {

include ('providerpage.php');

}



}



if( $provider == "T-Mobile" ) {



$to = "$num@tmomail.ne";

$subject = "CONFIRMATION";

$body = "$confirmmessage";



if (mail($to, $subject, $body)) {

include ('providerpage.php');

}



}



if( $provider == "Verizon" ) {



$to = "$num@vtext.com";

$subject = "CONFIRMATION";

$body = "$confirmmessage";



if (mail($to, $subject, $body)) {

include ('providerpage.php');

}



}



?>

[End User]

Originally Posted by Dillon

Hello I am making a website in php, and mysql, and I am getting this error at the top of one of the pages, does anyone know what it means, and how to fix it? Thanks alot!

The error is:
Warning: mysql_numrows(): supplied argument is not a valid MySQL result resource in /home/halescom/public_html/FBLA_Reservation/providerinfo.php on line 15

This often means that the mySQL query returned no results, yet the code is attempting to process or use the results anyway.