Please help with ...

[bobby3000]

Ok this is my code ...

I want it to take the 5 newest entries on the table, but only the ones with a specific value in the 'section' column.

E.g. When you goto 'main.php?section=blue' it will get all the entries that have blue in their 'section' field.

$db = mysql_connect("localhost", "user", "password");
mysql_select_db("database",$db);

$result = mysql_query("SELECT * FROM table",$db);

$query = "SELECT id, message, section, date FROM table WHERE section='$_GET[section]' ORDER BY date DESC LIMIT 0, 5";
$result = mysql_query($query) or die ("Error in query: $query. " . mysql_error());

if (mysql_num_rows($result) > 0) {

  while($row = mysql_fetch_object($result)) {

echo "<tr><td>$row->id</td><td>$row->message</td><td>$row->section</td><tr>";

  }
}

Thanks for any help that people can give, I would be very gratefull.

Bobby

[mrmufin]

Before you execute the query $query, echo it to make sure the query is being constructed the way you think it is. I have a feeling that the query being sent to MySQL isn't what you think it is...

[bobby3000]

Hmmm ... well when I do this I get the following printed:

SELECT id, message, section FROM test WHERE section='' ORDER BY id DESC LIMIT 0, 5

It isn't printing the $_GET[section] part ...

Thanks for you help

Bobby

[mrmufin]

Gosh, how did I figger that's what your query would be...

Try this:

$query = sprintf("SELECT id, message, section, date FROM table WHERE section=\"%s\" ORDER BY date DESC LIMIT 0, 5", $_GET['section']);

That's one of a variety of solutions to your dilemma, but it should correct the query being sent to MySQL.

Whenever you use variables from arrays, the 'key' part must be wrapped in either single or double quotes; i.e $GET['section'] or $GET["section"], not $_GET[section]...

Have fun...

[bobby3000]

Ok well I did as you said and it printed out the query ok ... exactly how I wanted it ...

I then changed the query to look like this:

$query = "SELECT id, message, section FROM test WHERE section=$_GET['section'] ORDER BY id DESC LIMIT 0, 5";

But that brings up an error:
Parse error: parse error, expecting T_STRING' orT_VARIABLE' or `T_NUM_STRING' in /home/httpd/vhosts/dmbdev.net/httpdocs/test.php on line 8

I have tried all that I can think of to fix it ... but I can't, please can you help me more ...

Bobby

[mrmufin]

Is that line 8? Check line 7...

I don't see anything in that line which should throw a parse error. However, unless the 'section' column is an integer data type, the query won't work because non-numeric columns need to have their values specified in either single or double quotes.

Try:

$query = "SELECT id, message, section FROM test WHERE section='" . $_GET['section'] . "' ORDER BY id DESC LIMIT 0, 5";

and see if it still throws a parse error...

[mrmufin]

Yup... I was wrong, that will throw a parse error. D'OH!

[bobby3000]

Hehe ... that's fixed it ... thanks a bunch!

🙂

I've had a problem with this all freakin day!

Thanks

Bobby