php - Selecting array of unique results from database and using them foreach -

-

i'm trying array of unique rows database , use them in foreach dropdown menu, have never ever touched arrays or foreach function. thought getting it, code doesn't seem work. couldn't find on site or web on subject turn help. in advance.

<select name='item'> <?php $getitems = $data->query('select * items id != "'.$sellid.'"');  while($row = $getitems->fetch_assoc()) {     $getitems_2 = $data->query('select * inventory itemid = "'.$row['id'].'"');     $raw = $getitems_2->fetch_assoc();     $raw = array_unique($raw['itemid']));     foreach ($raw $value) {         echo "<option value='".$value."'>".$row['name']."</option>";     } }  ?>


Comments

Post a Comment

Popular posts from this blog

.net - Generate assembly with Roslyn -

-
Image
is possible build .net core or better .net standard library roslyn can referenced project? my goal build assembly on server , have people download can reference , use in own visual studio projects. i'm using roslyn generate c# code , compile it. seems work ok when "emit" compilation result memory stream, load assembly , execute code using reflection. using (var ms = new memorystream()) { var compilationresult = compilation.emit(ms); if (compilationresult.success) { ms.position = 0; var assembly = assemblyloadcontext.default.loadfromstream(ms); .. .. is can "save" assembly proving path emit method. results in .dll file on disk. var compilationresult2 = compilation.emit(@"d:\testassembly.dll"); i wonder kind of format .dll file is. doesn't seem "normal" assembly. i searched internet couldn't find doing this. misunderstand something? so questions are: what kind of format file create emit? full...
Read more

ZeroMQ on Windows, with Qt Creator -

-
i have installed zmq link given below on windows 7. http://zeromq.org/distro:microsoft-windows 1) have c++ project in qt-creator , i'm using zmq c++ binding (zhelpers.hpp etc). 2) have added .lib installed zmq folder qtcreator 3) while compiling, compiler looks _imp__zmq_verion, in .dll files present in .lib have __imp_zmq_version. 4) causing undefined reference zmq_version. anyone else faced problem , has solution ?
Read more

batch file - filebot superstrict script: need tiny video sample or other solution -

-
seeing how filebot can make massive mistakes (even in strict mode) when renaming videos created script make sure there's no mistakes , lets me check suspicious ones manually. it uses dummy 0-size copy of video in dedicated folder figure out new name renamed , doesn't tagged video , audio info since it's not real video. it simpler , more accurate have variable tags in place need tiny part of video (with tracks) instead of 0-size dummy. what's easy way this? all unknown variables see extrapolated video filename in other script, should not relevant here ask away if need be. @echo off /f "tokens=*" %%f in ("%full%") ( set "fullpath=%%~dpf" set "file=%%~nxf" ) :: prep fake temp file set tempdir=%temp%\%date:~3,2%%date:~6,2%%date:~11,2%%time:~1,1%%time:~3,2%%time:~6,2% mkdir "%tempdir%" && copy /y nul "%tempdir%\%file%" >nul :: filebot string (to shorten lines) if "%type%"...
Read more