Sherri W (SyntaxSeed) on Nostr: I have an #SQL #WordPress query that is ordering by post_date. But the date for this ...
I have an #SQL #WordPress query that is ordering by post_date. But the date for this particular set of posts is identical.
So it's giving me them in different orders if I run the same query a few times. Which is messing up pagination.
What the heck?
#WebDev
Published at
2024-06-04 22:31:41Event JSON
{
"id": "22afca7cffa6b7a2698d765d76d6386c9bf3455ff5da1a9b7c897e71bfce03d5",
"pubkey": "6adf0c2f565ae9fdf64310bdc6d5efee934c5b1faca9a82512b62230077b896c",
"created_at": 1717540301,
"kind": 1,
"tags": [
[
"t",
"sql"
],
[
"proxy",
"https://phpc.social/@syntaxseed/112560721205535973",
"web"
],
[
"t",
"webdev"
],
[
"t",
"wordpress"
],
[
"proxy",
"https://phpc.social/users/syntaxseed/statuses/112560721205535973",
"activitypub"
],
[
"L",
"pink.momostr"
],
[
"l",
"pink.momostr.activitypub:https://phpc.social/users/syntaxseed/statuses/112560721205535973",
"pink.momostr"
]
],
"content": "I have an #SQL #WordPress query that is ordering by post_date. But the date for this particular set of posts is identical.\n\nSo it's giving me them in different orders if I run the same query a few times. Which is messing up pagination.\n\nWhat the heck? \n\n#WebDev",
"sig": "a22405ac78fbb48bfe7a5fd7656f0ddd7804b1d17e07986b02a2ba2cc9cf87f96a41c7e07d256d8fe180ff6768e23b6321bc27ba4f7953ff277342f7d0b5a0ff"
}
