debugging

[inquisitive]

Here is the error; Warning: mysql_fetch_array(): 7 is not a valid MySQL...and the line is that errors is the while statement at the end...

 

The following is the code:

 

<?php

if(isset($_POST['mysubmit']))

switch($_POST['type_account']) {

case "pr_specialist":

$type = "PRSpecialist";

break;

case "contractors":

$type = "Contractor";

break;

case "students":

$type = "Student";

break;

case "admin":

$type = "admin";

break;

/* more */

}

$query = "SELECT * FROM users WHERE pending = 0 AND type = '$type'";

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

while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {

/* parse rows */

?>

     

[Xurion]

Put an echo to see how many rows you have in your result set. I'm gona guess you have none, and that's what's causing your error:

 

echo mysql_num_rows($result);

[inquisitive]

The number 2 comes up on my page...when the ehco is put in

[inquisitive]

Why don't you think my result variable is storing anything...?

[PFMaBiSmAd]

The code inside of the while() loop is overwriting $result.

 

How do I know this? Your mysql_query() has an or die() statement that would prevent the while loop from being executed at all if there was no result resource (and this has nothing to do with how many rows there are in the result set because a result set with zero rows returns a result resource.)

[inquisitive]

this use to work...then it just crashed....how would i make it then so it retrieves all data..instead of just a single record...

[Xurion]

Try this

 

<?php
if(isset($_POST['mysubmit'])){
switch($_POST['type_account']) {
	case "pr_specialist":
		$type = "PRSpecialist";
		break;
	case "contractors":
		$type = "Contractor";
		break;
	case "students":
		$type = "Student";
		break;
	case "admin":
		$type = "admin";
	break;
}
$query = "SELECT * FROM users WHERE pending = 0 AND type = '$type'";
$result = mysql_query($query) or die(mysql_error());
while ($line = mysql_fetch_assoc($result)) {
	print_r($line);
}
}
?>