|
I'm trying to fetch the previous and next record using PDO/MYSQL. The SQL code for Next fetches the next record, but for Previous always returns the first record. Don't understand why Previous does not work. There are 7 records in this test set and the 'article_id' field is not contiguous (due to deletions) but is broken up as such: 24, 45,46,47, 48, 50, 51. Code below:
$id = 47;
echo 'current id is:'.$id;
$stmt= $db->prepare("SELECT * FROM blog WHERE article_id<$id LIMIT 0,1");
$stmt->execute();
$row=$stmt->fetch(PDO::FETCH_ASSOC);
echo '<br>';
echo 'Previous ID is:'.$row['article_id'];
$stmt= $db->prepare("SELECT * FROM blog WHERE article_id>$id LIMIT 0,1");
$stmt->execute();
$row=$stmt->fetch(PDO::FETCH_ASSOC);
echo '<br>';
echo 'Next ID is:'.$row['article_id'];
The resultant output is:
current id is:47
Previous ID is:24
Next ID is:48
The previous ID should be 46, not 24!
I've tried the same SQL in phpMyAdmin directly and it still returns 24 for the previous, but works fine for the next. I've seen many other examples on the web showing the similar code as I have, but theirs seems to work (via youtube), mine doesn't. Any help would be appreciated!
Thanks in advance.
|
|
|
|
|
I am not a SQL expert, but the following occurs to me. Your SELECT statement says: find all records whose article_id is less than the value given (i.e. 47), and return the first record found. So SQL starts searching the table at the beginning, checks the first record and its id is 24, and that matches your search criteria. In order to do what you want you need somehow to tell it to find the record with the highest id that is less than 47. But I am not sure how you would specify that.
|
|
|
|
|
To extend Richard's reply:
you may want to refine your SQL query using ORDER BY clause or/and MAX / MIN functions.
|
|
|
|
|
Solved the issue, and thanks for the hints!
$stmt= $db->prepare("SELECT * FROM blog WHERE article_id<$id ORDER by article_id DESC LIMIT 0,1");
It seems like the for the next record, the system naturally assumes ascending, but for the previous, I had to put in the DESC order in!
|
|
|
|
|
I think that Ascending is the default order for all SELECT clauses.
|
|
|
|
|
What is the underlying software or language used by Argue Commercial Valuation?
|
|
|
|
|
|
Google for the following. Select computer and search. Create an account and look at full job descriptions. Should provide an idea.
"Altus group" jobs
However the functionality can be implemented in a variety of different ways. The specific technology does not limit it.
|
|
|
|
|
I am looking for a programming expert to assist in the creation of a commercial real estate software package I am designing. Where is the best place to post a description of the skills I am looking for in a developer, and finding the absolute best?
Thank you for any guidance you can provide.
|
|
|
|
|
Monster.com, Freelancer.com - but not here. We are not a recruitment site, and take a dim view of what appear to be recruiters trolling for bodies ...
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
|
|
I got a chuckle from Swinkarans suggestion, the after learning part seems to imply junior developers, not "the very best"
I have built and supported RE apps in the past and know how big a job it is, what makes you think your solution is going to be better than the existing apps. Feel free to contact me via PM, if you are just another recruiter I get the chance to be rude, otherwise it may be useful to discuss it.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Mycroft Holmes wrote: what makes you think your solution is going to be better than the existing apps.
That of course never stopped anyone from creating competing products in any industry. As long as they have the money and the sales expertise then it only requires a bit of care to actually create a product. If they don't have the first two then it will never fly at all. And without the second it can provide employment for a while but will very likely fail.
|
|
|
|
|
|
Hi,
I have SQL Server 2012 on my machine, I have developed an SSIS Package that I could able to run on locally in debug environment and deployed on SQL Server 2012 Server as well. But the Test and Staging Servers are 2008 R2, when I tried to deploy the Package on the 2008 R2 servers I am getting the following error, any help would be greatly helpful, thanks in advance.
<h2>TITLE: Import Package</h2>
The package failed to load due to error 0xC0010014 "One or more error occurred. There should be more specific errors preceding this one that explains the details of the errors. This message is used as a return value from functions that encounter errors.". This occurs when CPackage::LoadFromXML fails.
<hr />
ADDITIONAL INFORMATION:
The package failed to load due to error 0xC0010014 "One or more error occurred. There should be more specific errors preceding this one that explains the details of the errors. This message is used as a return value from functions that encounter errors.". This occurs when CPackage::LoadFromXML fails.
<hr />
BUTTONS:
<h2>OK</h2>
..==================================
The package failed to load due to error 0xC0010014 "One or more error occurred. There should be more specific errors preceding this one that explains the details of the errors. This message is used as a return value from functions that encounter errors.". This occurs when CPackage::LoadFromXML fails.
And when I queried to see the actual error of the Job I am getting following error message:
Executed as user: NT Service\SQLSERVERAGENT. Microsoft (R) SQL Server Execute Package Utility Version 11.0.6020.0 for 64-bit Copyright (C) Microsoft Corporation. All rights reserved. Started: 2:11:14 PM Error: 2018-06-04 14:11:14.23 Code: 0xC0011007 Source: {12A3883D-DB4A-4085-A76A-DFB45C939490} Description: Unable to load the package as XML because of package does not have a valid XML format. A specific XML parser error will be posted. End Error Error: 2018-06-04 14:11:14.23 Code: 0xC0011002 Source: {12A3883D-DB4A-4085-A76A-DFB45C939490} Description: Failed to open package file "C:\Users\ssubrama\Desktop\CFRS_Provider_2.dtsx" due to error 0x80070005 "Access is denied.". This occurs when loading a package and the file cannot be opened or loaded correctly into the XML document. This can be the result of specifying an incorrect file name when calling LoadPackage or the specified XML file has an incorrect format. End Error Could not load package "C:\Users\ssubrama\Desktop\CFRS_Provider_2.dtsx" because of error 0xC0011002. Description: Failed to open package file "C:\Users\ssubrama\Desktop\CFRS_Provider_2.dtsx" due to error 0x80070005 "Access is denied.". This occurs when loading a package and the file cannot be opened or loaded correctly into the XML document. This can be the result of specifying an incorrect file name when calling LoadPackage or the specified XML file has an incorrect format. Source: {12A3883D-DB4A-4085-A76A-DFB45C939490} Started: 2:11:14 PM Finished: 2:11:14 PM Elapsed: 0.125 seconds. The package could not be found. The step failed.
The job failed. The Job was invoked by User DHSINTRA\SSubrama. The last step to run was step 1 (OPSExtract).
Any help would be very great, thanks in advance buddies - thanks a lot.
Thanks,
Abdul Aleem
"There is already enough hatred in the world lets spread love, compassion and affection."
-- modified 4-Jun-18 18:23pm.
|
|
|
|
|
Very few software applications are forwards compatible, so what you are doing, 2012 => 2008 is probably not going to work.
The error messages are probably invalid/random as there will almost certainly be a compatibility error in the package.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Hey guys!
I can't find a section on where to ask about html questions but I have been following this tutorial by mmtuts:
16: How to Create HTML5 Videos and Embed Videos | Learn HTML and CSS | HTML Tutorial | Basics of CSS - YouTube[^]
I am wondering if someone could check to see if the code is working because for some reason, I can' seem to get it to show the correct width and height..
Is it possible to copy sniptool here because I can't get seem to paste it..
My apologies.. I forgot to include my stylesheet... is there still a way to paste images from sniptool?
|
|
|
|
|
YouTube videos include a comments section below them so you can talk directly to the author, who will know a lot more about the subject than we will - we'd have to follow the whole "tutorial" to work out what you might possibly have done wrong (assuming the video doesn't miss stuff out, and most do).
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
Youtube is considered one of the WORST teaching methods for developers. You want us to sit through 10 minutes video to try and work out what it does wrong. Not going to happen.
Also what does HTML and CSS got to do with databases - pick the correct forum, post the code that is giving you a problem and tell us where the problem is occurring and we may be able to help.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
If you are still struggling with this and have not had a response from mmtuts, then I suggest you post a question with the code that you have written (only the relevent bits). You are more likely to get help that way.
|
|
|
|
|
Hey guys!
I am not sure if this is a good idea but am trying to insert multiple options for the user into a single column in my memberships table.. My table looks like this:(I can't paste the link) but this is my code in trying to use explode to convert back to an arrray so that I can do some checks. Is the last part correct where I use the foreach loop to check for a certain variable to be true or not?
<!DOCTYPE html>
<html>
<head>
<title></title>
<meta charset="utf-8">
<link rel="stylesheet" type="text/css" href="style.css">
</head>
<body>
<?php
session_start();
if(!isset($_SESSION['u_uid'])) {
header("Location: index.php?notlevel1user");
exit();
} else {
include_once 'includes/dbh.php';
$sql = "SELECT * FROM memberships WHERE user_uid = '".$_SESSION['u_uid']."'";
$result = mysqli_query($conn, $sql);
$resultCheck = mysqli_num_rows($result);
if($resultCheck > 0) {
while($row = mysqli_fetch_assoc($result)) {
$subscriptionplan = $row['subscriptionplan'];
$expirydate = $row['expirydate'];
$expirydate2 = $row['expirydate2'];
$expirydate3 = $row['expirydate3'];
$activate = $row['activate'];
$token2 = $row['token2'];
if ($activate == 0) {
header("Location: index.php?level1=premiumplannotactivated");
exit();
} else {
if ($subscriptionplan == 'Level 1' && date("Y-m-d") > $expirydate && $activate == 1) {
$sql = "UPDATE memberships
SET subscriptionplan = '', subscriptionplandate = '', expirydate = ''
WHERE user_uid = '".$_SESSION['u_uid']."'
";
mysqli_query($conn, $sql);
header("Location: index.php?level1=expired");
exit();
} else {
if ($subscriptionplan == 'Level 1' && $activate == 0) {
header("Location: index.php?level1=notactivated");
exit();
} else {
$sql = "SELECT * FROM memberships WHERE user_uid = '".$_SESSION['u_uid']."'";
$result = mysqli_query($conn, $sql);
$resultCheck = mysqli_num_rows($result);
if($resultCheck > 0) {
while($row = mysqli_fetch_assoc($result)) {
if($row['activate'] == 1) {
$sql = "UPDATE users
SET premium = 1
WHERE user_uid = '".$_SESSION['u_uid']."'
";
mysqli_query($conn, $sql);
exit();
} else {
$subscriptionplan = explode(',', $subscriptionplan);
foreach($subscriptionplan as $subscribe)
if ($subscribe == 'Level 1, Level 2, Level 3') {
header("Location: level1videos.php");
exit();
}
}
}
}
}
}
}
}
}
}
modified 2-Jun-18 23:55pm.
|
|
|
|
|
PHP: explode - Manual[^]
..it is not a very good idea to put an array into a single field. Put them in a separate table and link to it from the original table.
Bastard Programmer from Hell 
If you can't read my code, try converting it here[^]
"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.
|
|
|
|
|
|
Hi guys..
I am new here and i don't see any php section but I think this is more of a database one because i have no errors in my code but for some reason, it is inserting into my memberships table but the users' table is working...
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
