I'm getting this on everything...

Jason_Jones

While attempting to solve one problem, I have discovered that no matter what I use, I always get this message:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource on line #

What does that mean?

getDizzle

Whatever query you are using is not returning a mysql result.
Try running your query from the mysql command line and make sure it returns results. Post the relevant code if this doesn't help.

Jason_Jones

Hey!

I got it working!!!!

New question:

How do I get this:

while ($sql -> ReadRow()) {
echo $sql -> RowData["plant"] . ", ";
echo $sql -> RowData["quantity"] . ", ";
echo $sql -> RowData["stock"] . ", ";
echo $sql -> RowData["location"] . " ";

}

To print within HTML without embedding HTML into the PHP? This example does not work:

<html>
<head>
<title>Plant Information</title>
</head>

Tekron-X

You can always embed your php into HTML 🙂

For example

<?php
$sample1 = "Hello";
$sample2 = "World";
?>

that won't being that I did put in all the html tags needed but you get the idea. 🙂

philipolson

<?php
while ($row = mysql_fetch_assoc($result)) {
?>
<tr>
 <td><?php echo $row['foo']; ?></td>
 <td><?php echo $row['bar']; ?></td>
</tr>
<?php
}
?>

</table>
</html>

Note that everything within the while loops {braces} is looped through, whether it's html or php doesn't matter.

Regarding mysql errors, mysql_error() is your friend. Remember that mysql_query returns false on failure.