PHP / MySQL - Query not fetching any data -


i have been trying set page lists prices of items table in database. here code:

<?php $querylist = mysql_query("select item_name,image,price,added_by values"); while($row = mysql_fetch_array($querylist)) {     echo '<div class="post rareitem" style="margin-right: 15px;float: left;">     <div class="rarename">     <strong>';      // shows item name     echo $row['item_name'];     echo '</strong>     </div>';      // shows item image     echo '<div class="rareimage" style="background-image: url(/app/tpl/skins/mango/images/values/rares/';     echo $row['image'];     echo ');"></div>';      // shows item price     echo '<div class="rarecontrols">         <div class="coinsbox"></div>                     <span>                     <b> <b>credits: </b> </b> ';     echo $row['price'];     echo '</span>';      // shows added item     echo '<div class="addedbox"></div><b><b><span><font color="#c93734"><font color="#c93734">added by: </font> </font>';     echo $row['added_by'];     echo '</span></b></b>     </div>      <div class="clear"></div> </div>'; }  ?>

there chunk of code (shown below) have based off of, , works fine. can't seem work though. believe has sql, syntax, or something. no matter do, produces absolutely no results, yet code below results planned. know fact not connection issue because below code can placed on same exact page above 1 , works fine, above not.

<?php $querylist = mysql_query("select id,username,motto,country,look,rank,account_created,role,account_created,online,last_online users rank='9' order id limit 20"); while($row = mysql_fetch_array($querylist)) {     echo '     <div class="team">';      // showing avatar     echo '<div style="float: left; margin-top:-1px;height: 60px; width: 64px; background: url(http://www.habbo.nl/habbo-imaging/avatarimage?figure=';     echo $row['look'];echo "&amp;action=wav&amp;direction=3&amp;head_direction=3&amp;gesture=sml&amp;size=m) no-repeat 0px -10px";     echo "\"/>";      echo "<img alt=\"badge\" src=\"/app/tpl/skins/habbo/images/icons/";     echo $row['online'];echo ".gif\"></div>";      // flags     echo "<br/><img src=\"/app/tpl/skins/habbo/images/icons/flags/";     echo $row['country'];echo ".png";     echo '" style="float:right;" /> <b><uf>';     echo $row['username'];echo "</u></b>";      // bans & ticket count     $bans = mysql_query("select * `bans` `added_by` = '" . $row['username'] . "'");     $bancount = mysql_num_rows($bans);     $tickets = mysql_query("select * `moderation_tickets` `moderator_id` = '" . $row['id'] . "'");     $ticketcount = mysql_num_rows($tickets);      //role     echo "<br/><gb>role: </b><fi> ";     echo $row['role'];echo "";     echo "</i>";      // echoing bans & tickets     echo "<br/><gb>bans: </b><fi> ";     ; echo $bancount;     echo "</i>";      echo " &nbsp; <gb>tickets: </b><if>";     ; echo $ticketcount;     echo "</i>";     echo "</div>"; } ?>

thanks in advanced, assistance appreciated!

values reserved words in mysql should on backtick

select item_name,image,price,added_by `values`

and stop using mysql deprecated. instead use mysqli or pdo


-

Comments

Post a Comment

Popular posts from this blog

java - UnknownEntityTypeException: Unable to locate persister (Hibernate 5.0) -

Image
in code below when try execute main.java getting exception: exception in thread "main" org.hibernate.unknownentitytypeexception: unable locate persister: com.np.vta.test.pojo.users @ org.hibernate.internal.sessionfactoryimpl.locateentitypersister(sessionfactoryimpl.java:792) @ org.hibernate.internal.sessionimpl.locateentitypersister(sessionimpl.java:2637) @ org.hibernate.internal.sessionimpl.access$2500(sessionimpl.java:164) @ org.hibernate.internal.sessionimpl$identifierloadaccessimpl.<init>(sessionimpl.java:2575) @ org.hibernate.internal.sessionimpl$identifierloadaccessimpl.<init>(sessionimpl.java:2562) @ org.hibernate.internal.sessionimpl.byid(sessionimpl.java:1044) @ org.hibernate.internal.sessionimpl.get(sessionimpl.java:955) @ com.app.test.main.main(main.java:20) but if uncomment cfg.addclass( users.class ).addresource( "com/np/vta/test/pojo/users.hbm.xml" ); code works fine. why not reading <mapping...
Read more

python - ValueError: empty vocabulary; perhaps the documents only contain stop words -

i'm using (for first time) scikit library , got error: valueerror: empty vocabulary; perhaps documents contain stop words file "c:\users\a605563\desktop\velibprojetpreso\traitementtwitterdico.py", line 33, in <module> x_train_counts = count_vect.fit_transform(filetweets) file "c:\python27\lib\site-packages\sklearn\feature_extraction\text.py", line 804, in fit_transform self.fixed_vocabulary_) file "c:\python27\lib\site-packages\sklearn\feature_extraction\text.py", line 751, in _count_vocab raise valueerror("empty vocabulary; perhaps documents contain stop words but don't understand why that's happening. import sklearn sklearn.feature_extraction.text import countvectorizer import pandas pd import numpy import unicodedata import nltk tweetsfile = open('tweets2015-08-13.csv', 'r+') f2 = open('analyzer.txt', 'a') print tweetsfile.readline() count_vect = countvectorizer(strip_accents='ascii...
Read more

ubuntu - collect2: fatal error: ld terminated with signal 9 [Killed] -

Image
i'm trying build precimonious on ubuntu 16.04.3 x64. allocated 1gb memory it. file structure looks like ~ |--- llvm/ |--- precimonious/ where llvm on version 3.0 mentioned @ https://github.com/corvette-berkeley/precimonious#requirement . followed steps on readme command make ended with ... llvm[1]: linking debug shared library libllvm-3.0.so collect2: fatal error: ld terminated signal 9 [killed] compilation terminated. ... i went through answers online , might because there's not enough memory perform link. memory usage the gcc version on machine gcc version 5.4.0 20160609 (ubuntu 5.4.0-6ubuntu1~16.04.4) , installed via apt-get install build-essential . fresh droplet created on digitalocean btw. appreciated. it memory exhaustion. sampling interval memory measurement not small enough covers exact point oom killer kicks in. depending on container/vm technology, may able set vm.overcommit_memory=2 before build, process not killed (but doing requires m...
Read more