[RESOLVED] Why won't text display from my MySQL database?

[john1704]

I have a field called note that is a longtext. There is also an id field that's an INI auto_increment. When I select the rows and try to display them, it appears as nothing. There are no error messages, but it just displays as nothing instead of the message in the MySQL database? What's wrong?

<?php
include "db_connect.php";
$id = $_GET['id'];
$sql = 'SELECT note FROM `notes` LIMIT 0, 30 WHERE id=$id';
$result = mysql_query($sql);
echo "Notes:<br><br>$result";
echo "ID #: $id";
?>

[NogDog]

mysql_query() returns a resource ID that is used to reference the query result set. You need to use one of the mysql_fetch_*() functions or mysql_result() to access the actual result data. See the examples on the [man]mysql_fetch_assoc[/man] for ways to loop through your query results.

[john1704]

Now I get this:

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/john1704/public_html/notepad/view.php on line 11

<?php
include "db_connect.php";
$id = $_GET['id'];
$sql = 'SELECT * FROM `notes` LIMIT 0, 30 WHERE id=$id';
$result = mysql_query($sql);
while ($row = mysql_fetch_assoc($result)) {
    echo $row["note"];
 }
echo "ID #: $id";
?>

The table is notes and the field is note as well as the row.

[NogDog]

I think the LIMIT clause has to come last in the query. Also, variables only get interpolated within a quoted string if it uses double quotes (as opposed to single quotes). Therefore, your mysql_query() is probably returning false instead of a resource ID. Try using the following pattern to help debug any SQL errors:

$sql = "SELECT * FROM `notes` WHERE id=$id LIMIT 0, 30";
$result = mysql_query($sql) or die("Query failed ($sql): " . mysql_error());
while ($row = mysql_fetch_assoc($result)) {
    echo $row["note"];
}

[john1704]

Thanks, worked perfectly.