Reply to thread

Message

<blockquote data-quote="JayC" data-source="post: 337057" data-attributes="member: 36373">I'll show you how to write your own so you don't complain about not getting what you want.3 very easy steps.Step 1: Write the first query[CODE]mysql_query(&quot;SELECT * FROM table&quot;);* = Grabs All ColumnsYou can add things to the end like &quot;WHERE column = *value*&quot; to control your output or SORT BY desc/rand to make the values change order or randomize themSo after you get your query written out which should look something like this:UberCMS: mysql_query(&quot;SELECT * from USERS where USERNAME='&quot;.USER_NAME.&quot;'&quot;);RevCMS: mysql_query(&quot;SELECT * from USER where USERNAME='&quot;.$_SESSION['user']['username'].&quot;'&quot;);[/CODE]Step 2: Grab The Attributes[CODE]You can never just write a query and then say $query['value'] because you will get a resource ID error. So you grab the attributes of it so you can use it$UseMe = mysql_fetch_assoc($query);[/CODE]Great now the easy partStep 3: Display/Use the information[CODE]Display:echo $UseMe['column'];Use:'&quot;.$UseMe['column'].&quot;' --&gt; Use this in another query to grab more info[/CODE]And just to be noted you said you wanted a stats page, and he gave you all of the code for it. Stop being picky we are not here to spoon feed you we are here to HELP. We want to make retros more diverse and unique. We do not want to see the same things over and over.Best of Luck!</blockquote>

[QUOTE="JayC, post: 337057, member: 36373"] I'll show you how to write your own so you don't complain about not getting what you want. 3 very easy steps. [B]Step 1: Write the first query[/B] [CODE] mysql_query("SELECT * FROM table"); * = Grabs All Columns You can add things to the end like "WHERE column = *value*" to control your output or SORT BY desc/rand to make the values change order or randomize them So after you get your query written out which should look something like this: UberCMS: mysql_query("SELECT * from USERS where USERNAME='".USER_NAME."'"); RevCMS: mysql_query("SELECT * from USER where USERNAME='".$_SESSION['user']['username']."'"); [/CODE] [B]Step 2: Grab The Attributes[/B] [CODE] You can never just write a query and then say $query['value'] because you will get a resource ID error. So you grab the attributes of it so you can use it $UseMe = mysql_fetch_assoc($query); [/CODE] Great now the easy part [B]Step 3: Display/Use the information[/B] [CODE]Display: echo $UseMe['column']; Use: '".$UseMe['column']."' --> Use this in another query to grab more info[/CODE] And just to be noted you said you wanted a stats page, and he gave you all of the code for it. Stop being picky we are not here to spoon feed you we are here to HELP. We want to make retros more diverse and unique. We do not want to see the same things over and over. Best of Luck! [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members