Last 10 that have two properties mysql

Jazzy_Girl

Hello I'm not sure how to do this need help.

Trying to pull onto a web page from mysql. The last 10 id numbers that were inserted into the database but that also have something filled in a certain database column called 'category' as well. Doesn't matter what's in that other column named 'category' just as long as any text or numbers are in that column row, then it will pull their last entered ids into the database as well. So I have so far done all myself:

<?php
$link = mysql_connect('databasename', 'databaselogin', 'databasepassword');
if (!$link) {
die('Not connected : ' . mysql_error());
}

$db_selected = mysql_select_db('databaselogin', $link);
if (!$db_selected) {
die ('Can\'t use database : ' . mysql_error());
}

$query =

"SELECT category, link, entryname FROM addentry WHERE `category` has anything in its row and `id` also = 'something that pulls the 1st of the 10 last entries here'";

$result = mysql_query($query);
while ($row = mysql_fetch_array($result))

{
print "<table border=3 class='' style='' cellspacing=0 cellpadding=0 width=545>
<tr><td colspan=2 style=''>
<table border=0 cellpadding=0 cellspacing=0 width=560><tr><td><a style='' href='$row[link]'><b>$row[entryname]</b></a></td></tr></table>
?>
<?php
$link = mysql_connect('databasename', 'databaselogin', 'databasepassword');
if (!$link) {
die('Not connected : ' . mysql_error());
}

$db_selected = mysql_select_db('databaselogin', $link);
if (!$db_selected) {
die ('Can\'t use database : ' . mysql_error());
}

$query =

"SELECT category, link, entryname FROM addentry WHERE `category` has anything in its row and `id` also = 'something that pulls the 2nd of the 10 last database entries here and so on below on through to ten of the last database ids that also have something in category'";

$result = mysql_query($query);
while ($row = mysql_fetch_array($result))

I have highlighted the part I know I have wrong. Just explained there what I need there, don't know the code that will make it work. Why needed to come here because I'm stuck and need help. The rest of it not highlighted already works well. I'm not any expert programmer obviously only know some.

Please let me know how to do this or if you don't understand something in my detailed question. Thank you very, very, much for your help.

johanafm

SELECT fields, to, use FROM your_table WHERE category IS NOT NULL ORDER BY id DESC LIMIT 0,10

Jazzy_Girl

Thank you sooooo much!!!! What does ORDER BY id DESC LIMIT mean? Only part I don't know what that does. So I can see if it is doing it. I looked it up online but their explainations aren't good and many of them are different. Thank you very much for your help.

halojoy

supposing you have id= 1-17

ORDER BY id ASC LIMIT 5 (... or just ORDER BY id LIMIT 5)
would give:
1
2
3
4
5

ORDER BY id DESC LIMIT 5
would give:
17
16
15
14
13

Jazzy_Girl

Thank you very much that is what it's doing.

$query = "SELECT category, link, entryname FROM addentry WHERE `category` IS NOT NULL ORDER BY id DESC LIMIT 0,10";

But it's pulling the very last entries in the database. It's not pulling yet the very last entries that have anything found in their "category" row yet. If that means where "category" is not empty, it's not reading that for some reason. It's only pulling "category" that has empty fields instead. When is supposed to pull those that have something in "category" along with what it's doing.

Any clue why?

I also put an "AND" here:

IS NOT NULL AND ORDER BY id

Thinking maybe it needed that to know to do both of them at the same time. But it didn't like it with the "AND" added. Maybe it was already trying to do that the way it already was. But something else is wrong explained above.

Anyone please let me know where I have the error. Thank you very much for your help.

johanafm

There is a difference between having null and having an empty string. Both will appear to you as having nothing. Try

WHERE category IS NOT NULL AND NOT category = ''

halojoy

I think $query is alright.
I have changed a bit in the while loop, the display output

Can you try this

<?php
error_reporting(E_ALL);
ini_set('display_errors', '1');

$link = mysql_connect('databasename', 'databaselogin', 'databasepassword');
if (!$link) {
	die('Not connected : ' . mysql_error());
}
$db_selected = mysql_select_db('databaselogin', $link);
if (!$db_selected) {
	die ('Can\'t use database : ' . mysql_error());
}

$query = "SELECT category, link, entryname 
		FROM addentry 
		WHERE `category` IS NOT NULL ORDER BY id DESC LIMIT 0,10"; 
$result = mysql_query($query);

while ($row = mysql_fetch_array($result)) 
{
echo "<table border=3 class='' style='' cellspacing=0 cellpadding=0 width=545>
<tr><td colspan=2 style=''>
<table border=0 cellpadding=0 cellspacing=0 width=560><tr>
<td><a style='' href='".$row['link']."'><b>".$row['entryname']."</b></a></td></tr></table>
</td></tr></table>";
}

exit('The END');

?>

Jazzy_Girl

Lol you had me laughing at your little The End message showing up at the end of everything. It's still pulling all the info from all columns asked for in database fine, sorry about the missing bracket..I forgot to add in the earlier code.

It's just not pulling the right rows yet that has anything in a category column.

It didn't like yet..

$query = "SELECT category, link, entryname FROM addentry WHERE `category` IS NOT NULL AND NOT category = '' ORDER BY id DESC LIMIT 0,10";

When AND NOT category = ''

is added nothing happens together or with it alone. Maybe I read what you meant wrong on adding that with the other.

I added this to have it show any exta errors on the page
ini_set('error_reporting', 8191);
ini_set('display_startup_errors', 1);
ini_set('display_errors', 1);
They are bringing up no extra errors either.

Anyone know how to get it to pull the mysql database last rows if there is anything found in their "category" field as well?

Thankyou very much for your help.

halojoy

They say in SQL syntax
<> -- not equal to

so I should try

WHERE `category` IS NOT NULL AND category <> '' ....

or using NOT

WHERE `category` IS NOT NULL AND category NOT ''

I think you are doing some good thinking
because
NULL is not the same as '' (an empty string)

Of course best is if you could really find out
what actually is in those 'category' database fields.

Jazzy_Girl

This worked for your records! I don't even understand why it's just great that it does. It works well and just as needed pulling only the last 10 that only have something in them. For some reason what you did works well and the null wasn't working. Thing was it takes so long adding something new to the database everytime just for that and don't want all of them pulled, why a lot better if was possible to notice when there is already something in something already there. When something is already in category means it's ready to go on the page, not all entries have something in category because not ready to go on the page. That's too great of a trick you now can do for a lot of things at least you understand it.

$query = "SELECT category, link, entryname FROM addentry WHERE category<> '' ORDER BY id DESC LIMIT 0,10";

You did it 🙂!! Your tops! Thanks a whole lot, nice to get that last part finally done.