[SOLVED] Why do my SQL queries never work :(

[dmccabe]

All I am wanting to do is to out put all the items in a particular table, but no I get

"#Resourceid_6" instead, what am I doing wrong?

 

if (isset($_POST['submit'])) {
if (isset($_POST['all'])) {
	$query = "SELECT * FROM `tbl_vehicles`";
	if (!mysql_query($query)) {
		die(mysql_error());
	} else {
		$result = mysql_query($query);
		echo "<table>
				<tr>
					<td><strong>REG</strong></td>
					<td><strong>MAKE</strong></td>
					<td><strong>MODEL</strong></td>
					<td><strong>COLOUR</strong></td>
					<td><strong>REG</strong></td>
					<td><strong>STATUS</strong></td>
					<td><strong>LOCATION</strong></td>
					<td><strong>MILEAGE</strong></td>
					<td><strong>FUEL TYPE</strong></td>
					<td><strong>TRANSMISSION</strong></td>
					<td><strong>OFF FLEET DATE</strong></td>
				</tr>";
		while($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
			$make_id = $row['MAKE_ID'];
			echo "<tr><td>{$row['REG']}</td>";
			$make = mysql_query("SELECT `NAME` FROM `tbl_veh_make` WHERE `ID` = '$make_id'");
			echo	"<td>$make</td>
				</tr>";
		}
		echo "</table>";
	}
}
}
?>

[ngreenwood6]

You do not need this:

 

MYSQL_ASSOC

[ngreenwood6]

Try this:

 

if (isset($_POST['submit'])) {
if (isset($_POST['all'])) {
	$query = "SELECT * FROM `tbl_vehicles`";
	$result = mysql_query($query);

echo "<table>
				<tr>
					<td><strong>REG</strong></td>
					<td><strong>MAKE</strong></td>
					<td><strong>MODEL</strong></td>
					<td><strong>COLOUR</strong></td>
					<td><strong>REG</strong></td>
					<td><strong>STATUS</strong></td>
					<td><strong>LOCATION</strong></td>
					<td><strong>MILEAGE</strong></td>
					<td><strong>FUEL TYPE</strong></td>
					<td><strong>TRANSMISSION</strong></td>
					<td><strong>OFF FLEET DATE</strong></td>
				</tr>";
		while($row = mysql_fetch_array($result)){
			$make_id = $row['MAKE_ID'];
			echo "<tr><td>" . $row['REG'] . "</td>";
			$make = mysql_query("SELECT `NAME` FROM `tbl_veh_make` WHERE `ID` = '$make_id'");
                                                   $make_row = mysql_fetch_assoc($make);
			echo	"<td>" . $make_row['name'] . "</td>
				</tr>";
		}
		echo "</table>";
	}
}
}
?>

 

if you get any errors please post them. also tell me what it is not doing.

[premiso]

$query = "SELECT * FROM `tbl_vehicles`";
$result = mysql_query($query) or die (mysql_error());

if (mysql_num_rows($result) > 0) {


echo "<table>











<tr>













<td><strong>REG</strong></td>













<td><strong>MAKE</strong></td>













<td><strong>MODEL</strong></td>













<td><strong>COLOUR</strong></td>













<td><strong>REG</strong></td>













<td><strong>STATUS</strong></td>













<td><strong>LOCATION</strong></td>













<td><strong>MILEAGE</strong></td>













<td><strong>FUEL TYPE</strong></td>













<td><strong>TRANSMISSION</strong></td>













<td><strong>OFF FLEET DATE</strong></td>











</tr>";







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









$make_id = $row['MAKE_ID'];









echo "<tr><td>{$row['REG']}</td>";









$makeRes = mysql_query("SELECT `NAME` FROM `tbl_veh_make` WHERE `ID` = '$make_id'");
$make = mysql_fetch_assoc($makeRes);
$make = $make['NAME'];









echo



"<td>$make</td>











</tr>";

}
echo "</table>";
}

 

Sorry about the formating. I would suggest using [ code] over [ php]

[premiso]

You do not need this:

 

MYSQL_ASSOC

 

Yea, it makes it return an associative array instead of both. It saves memory space. That had nothing to do with why this was not working.

[dmccabe]

Excellent, thanks again guys, you never fail to amaze