Query was working in MYSQL but not MYSQLI -


my query working in mysql not in mysqli.

i'm selecting students have done pre , post test.

 select    studid username,    prepoints 'fitness assessment points grade',    end 'end-of-line indicator'      fittest, points     year(submitted) = '2017'    , semester = 'summer2'   group studid  having    (max(prepost = 'pre' ) + max(prepost = 'post')) = 2 , count(distinct prepost) = 2

any ideas changes need made working again?

here sample data:

 create table `fittest` (   `id` int(11) not null,   `submitted`  datetime default null,   `studid` varchar(100) default null,    `semester` varchar(50) default null,   `instructor` varchar(30)  default null,   `course` enum('phed 1164') default null,   `section`  enum('5001','5003','5005','5007','5009','5011','5013','5015','5017','5019','5021','5023','5025','5027','5029','5031','5033','5035','5037','5039','5041','5043','5045','5047','5049','5051','5053','5055','5057','5059','5061','5063','5065','5067','5069')  default null,   `age` varchar(50) default null,   `gender`  enum('m','f') default null,   `ethnicity` enum('hispanic','african  american','asian','white-non hispanic','other') default null,    `height` char(4) default null,   `weight` int(3) default null,    `flexibility` int(2) default null,   `crunches` int(3) default null,    `pushups` int(3) default null,   `treadtimemin` int(2) default null,    `treadtimesec` int(2) not null,   `treadhr` int(3) default null,    `prepost` enum('pre','post') not null,   `end` char(1) not null  default '#' ) engine=myisam default charset=utf8;   insert `fittest` (`id`, `submitted`, `studid`, `semester`,  `instructor`, `course`, `section`, `age`, `gender`, `ethnicity`,  `height`, `weight`, `flexibility`, `crunches`, `pushups`,  `treadtimemin`, `treadtimesec`, `treadhr`, `prepost`, `end`) values  (17, '2017-01-02 21:55:33', 'slacker', 'spring', 'tim', 'phed 1164',  '5001', '32', 'm', null, '69.5', 155, null, 29, 34, 22, 15, 76, 'pre',  '#'), (16, '2017-01-02 21:31:34', 'bfun', 'spring', 'tim', 'phed  1164', '5001', '32', 'm', null, '69.5', 122, null, 37, 36, 18, 14, 76,  'post', '#'), (15, '2017-01-02 21:31:09', 'bfun', 'spring', 'tim',  'phed 1164', '5001', '32', 'm', null, '69.5', 129, null, 21, 20, 23,  14, 76, 'pre', '#'),

i figured out issue isn't query. input. input had post prepost value there no results showing. help.


Comments

Post a Comment

Popular posts from this blog

What is happening when Matlab is starting a "parallel pool"? -

running parallel cpu processes in matlab starts command parpool() according documentation , function: [creates] special job on pool of workers, , [connects] matlab client parallel pool. this function takes bit of time execute, on order of 30 seconds. in other multi-cpu paradigms openmp, parallel execution seems totally transparent -- i've never noticed behavior analogous matlab (granted i'm not experienced parallel programming). so, happening between time parpool() called , when finishes executing? takes long? parallel computing toolbox enables run matlab code in parallel using several different paradigms (e.g. jobs , tasks, parfor , spmd , parfeval , batch processing), , run either locally (parallelised across cores in local machine) or remotely (parallelised across machines in cluster - either 1 own, or 1 in cloud). in of these cases, code run on matlab workers , copies of matlab without interactive desktop. if you're intending run on remo...
Read more

angular - DownloadURL return null in below code -

when change file updated in firebase storage when try downloadurl show null. filechange(event: any) { const imagefolder: string = this.employee.id; const filelist: filelist = event.target.files; const file: file = filelist[0]; const storageref = firebase.storage().ref().child(`${imagefolder}/profile.jpg`).put(file); console.log(storageref.snapshot.downloadurl); } the put() asynchronous. if want url after file uploaded have this: firebase.storage().ref().child(`${imagefolder}/profile.jpg`).put(file).then((snapshot) => { storageref = snapshot.downloadurl: console.log(snapshot.downloadurl); });
Read more

php - Cannot override Laravel Spark authentication with own implementation -

during login process of laravel spark need request token of remote api. api stores exact same users , passwords laravel spark application. therefore need username , non hashed password of user during authentication process. i thought overriding authenticated method solution problem. in routes/web.php override post /login endpoint , pointing endpoint own logincontroller: <?php namespace app\http\controllers\auth; use illuminate\support\facades\log; use illuminate\http\request; use laravel\spark\http\controllers\auth\logincontroller sparklogincontroller; class logincontroller extends sparklogincontroller { /** * create new login controller instance. * * @return void */ public function __construct() { parent::__construct(); } /** * handle successful authentication attempt. * * @param request $request * @param \illuminate\contracts\auth\authenticatable $user * @return response */ public fu...
Read more