mysql_fetch_array()... not a valid MySQL result resource

ukndoit

Here is the code I have so far...

I'm getting this message:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /path/to/index.php on line 226

Also this one:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /path/to/index.php on line 221

I put the line numbers next to them, the ones mentioned above in the "warning".

if ($_POST[custom0]) {
	$res = mysql_query( "SELECT * FROM {$pre}dept WHERE ( !(options & {$HD_DEPARTMENT_INVISIBLE}) )" );
	if( mysql_num_rows( $res ) == 1 ) {
		echo "<option value=\"0\">Global</option>\n";
	} else {
		$res = mysql_query( "SELECT * FROM {$pre}dept WHERE ( !(options & {$HD_DEPARTMENT_INVISIBLE}) ) AND id != 0" );
	Line 221:	while($row = mysql_fetch_array($res)) {
			if($row[id] == 2) {
				//Get Value from Database record....
				$_domain_check = $_POST[custom0];
				$res = mysql_query("SELECT addon_choices FROM user_db.orders WHERE domain_name = '$_domain_check'");
			Line 226:	$_rs = mysql_fetch_array($res);
				$_db_value = $_rs[addon_choices];
				$each_field = explode("|", $_db_value);
				// That just split each value into the array $each_field, right??
				if (in_array("5", $each_field)) {
					echo "<option value=\"{$row[id]}\" " . (($_POST[department] == $row[id] || $_POST[department] == $row[name]) ? "selected" : "") . ">" . field( $row[name] ) . "</option>\n";
				} else {
					echo "<option value=\"5\" " . (($_POST[department] == 5 || $_POST[department] == $row[name]) ? "selected" : "") . ">" . field( "Non 24 Hour Hosting Support" ) . "</option>\n";
				}
			} else { //  if ($row[id] != 0)
				echo "<option value=\"{$row[id]}\" " . (($_POST[department] == $row[id] || $_POST[department] == $row[name]) ? "selected" : "") . ">" . field( $row[name] ) . "</option>\n";
			}
		}
	}
}

What could be the problem here?
I know the coding might not be the best, I'm EXTREMELY NEW to PHP. I have been playing with it a while, but few and far between on the times I do so...

Thank you for any tips/advice you have.

Richard

laserlight

For starters, check your associative array indices.
$POST[custom0] should be $POST['custom0'] or $_POST["custom0"], unless you have defined a constant named custom0

Next, the more important part.
Check your database connection, and database selection.
If necessary, check that your queries are executed correctly.

e.g.

$res = mysql_query("SELECT addon_choices
	FROM user_db.orders
	WHERE domain_name = '$_domain_check'")
	OR die(mysql_error());

ukndoit

Thank you! That fixed those error codes from showing up...

One more thing is happening though...

I added this to the code:

$_number_of_records = mysql_num_rows( $res );

That is showing that there are 3 records, as there should be.

Why is it that in my while statement...


if ($_POST["custom0"]) {
	$res = mysql_query( "SELECT * FROM {$pre}dept WHERE ( !(options & {$HD_DEPARTMENT_INVISIBLE}) )" ) or die(mysql_error());
	$_number_o_recs = mysql_num_rows( $res );
	if( $_number_o_recs == 1 ) {
		echo "<option value=\"0\">Global</option>\n";
	} else {
		$res = mysql_query( "SELECT * FROM {$pre}dept WHERE ( !(options & {$HD_DEPARTMENT_INVISIBLE}) ) AND id != '0'" ) or die(mysql_error());
		$_number_of_records = mysql_num_rows( $res );
		while($row = mysql_fetch_array($res)) {
			$_this_id = $row["id"];
			if( $_this_id == 2 ) {
				//Get Value from Database record....
				$_domain_check = $_POST["custom0"];
				$res = mysql_query("SELECT addon_choices FROM user_db.orders WHERE domain_name = '$_domain_check'") or die(mysql_error());
				$_rs = mysql_fetch_array($res);
				$_db_value = $_rs['addon_choices'];
				if ($_db_value) {
					$each_field = explode("|", $_db_value);
				} else {
					$each_field = array();
				}
				if (in_array("5", $each_field)) {
					echo "<option value=\"{$row['id']}\" " . (($_POST['department'] == $row['id'] || $_POST['department'] == $row['name']) ? "selected" : "") . ">" . field( $row['name'] ) . "</option>\n";
				} else {
					echo "<option value=\"5\" " . (($_POST['department'] == 5 || $_POST['department'] == $row['name']) ? "selected" : "") . ">" . field( "Free Hosting Support" ) . "</option>\n";
				}
			} else {
				echo "<option value=\"{$row['id']}\" " . (($_POST['department'] == $row['id'] || $_POST['department'] == $row['name']) ? "selected" : "") . ">" . field( $row['name'] ) . "</option>\n";
			}
		}
	}
}
if ($_POST["custom0"]) {
echo ("
</select> Records: " . $_number_of_records . "
....

There should be 3 departements no matter what. But no matter what I enter, rather there is the one that has the 5 in the array or not, there is always ONLY ONE dept.

Any idea what I did wrong on that?

Thank you,
Richard