Click here to Skip to main content
14,639,270 members
Home » Discussions » Database
   

Database

 
QuestionCheck for object existence sql server 2012 is creating stored procedure as dynamic sql Pin
indian14325-Jun-18 10:36
Memberindian14325-Jun-18 10:36 
AnswerRe: Check for object existence sql server 2012 is creating stored procedure as dynamic sql Pin
Richard Deeming26-Jun-18 1:50
mveRichard Deeming26-Jun-18 1:50 
QuestionPDO/mySQL/PHP - when is it OK to NOT use parameter binding, when should I REALLY use it? Pin
needAbreakNow17-Jun-18 16:13
MemberneedAbreakNow17-Jun-18 16:13 
AnswerRe: PDO/mySQL/PHP - when is it OK to NOT use parameter binding, when should I REALLY use it? Pin
Jörgen Andersson17-Jun-18 19:29
professionalJörgen Andersson17-Jun-18 19:29 
AnswerRe: PDO/mySQL/PHP - when is it OK to NOT use parameter binding, when should I REALLY use it? Pin
Mycroft Holmes17-Jun-18 20:43
professionalMycroft Holmes17-Jun-18 20:43 
AnswerRe: PDO/mySQL/PHP - when is it OK to NOT use parameter binding, when should I REALLY use it? Pin
Eddy Vluggen18-Jun-18 0:27
professionalEddy Vluggen18-Jun-18 0:27 
AnswerRe: PDO/mySQL/PHP - when is it OK to NOT use parameter binding, when should I REALLY use it? Pin
jschell23-Jun-18 5:12
Memberjschell23-Jun-18 5:12 
QuestionPDO Get Previous and Next Record partially working Pin
needAbreakNow16-Jun-18 21:19
MemberneedAbreakNow16-Jun-18 21:19 
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;
//GET PREVIOUS 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'];
//GET NEXT 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.
AnswerRe: PDO Get Previous and Next Record partially working Pin
Richard MacCutchan16-Jun-18 21:32
mveRichard MacCutchan16-Jun-18 21:32 
AnswerRe: PDO Get Previous and Next Record partially working Pin
Victor Nijegorodov16-Jun-18 22:45
MemberVictor Nijegorodov16-Jun-18 22:45 
AnswerRe: PDO Get Previous and Next Record partially working Pin
needAbreakNow16-Jun-18 23:06
MemberneedAbreakNow16-Jun-18 23:06 
GeneralRe: PDO Get Previous and Next Record partially working Pin
Richard MacCutchan17-Jun-18 1:11
mveRichard MacCutchan17-Jun-18 1:11 
GeneralArgus Pin
Keith@Stand15-Jun-18 4:17
MemberKeith@Stand15-Jun-18 4:17 
GeneralRe: Argus Pin
CHill6015-Jun-18 4:21
mveCHill6015-Jun-18 4:21 
GeneralRe: Argus Pin
jschell23-Jun-18 5:17
Memberjschell23-Jun-18 5:17 
QuestionCode Expert Pin
Keith@Stand7-Jun-18 8:13
MemberKeith@Stand7-Jun-18 8:13 
AnswerRe: Code Expert Pin
OriginalGriff7-Jun-18 8:16
mveOriginalGriff7-Jun-18 8:16 
AnswerRe: Code Expert Pin
Swinkaran7-Jun-18 18:39
professionalSwinkaran7-Jun-18 18:39 
GeneralRe: Code Expert Pin
Keith@Stand7-Jun-18 19:18
MemberKeith@Stand7-Jun-18 19:18 
GeneralRe: Code Expert Pin
Mycroft Holmes17-Jun-18 20:51
professionalMycroft Holmes17-Jun-18 20:51 
GeneralRe: Code Expert Pin
jschell23-Jun-18 5:21
Memberjschell23-Jun-18 5:21 
AnswerRe: Code Expert Pin
Christopher Stewart27-Jun-18 10:47
MemberChristopher Stewart27-Jun-18 10:47 
QuestionRunning the Package in different versions of SQL Server Pin
indian1434-Jun-18 10:34
Memberindian1434-Jun-18 10:34 
AnswerRe: Running the Package in different versions of SQL Server Pin
Mycroft Holmes4-Jun-18 14:10
professionalMycroft Holmes4-Jun-18 14:10 
Questiontrying to follow this tutorial but video not set at 100% Pin
piano00112-Jun-18 18:14
Memberpiano00112-Jun-18 18:14 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.