Reply to thread

Message

<blockquote data-quote="Kristopher" data-source="post: 388953" data-attributes="member: 1958">I'm currently trying to get the script created below to show information from 2 tables, users and users_settings and so far its not displaying either. I know for a fact this script created works when you are just calling for one table in the database just not sure how to join both tables in one query if that makes sense.&nbsp;&nbsp; [Spoiler]&nbsp;&nbsp; &lt;?php&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $query = &quot;SELECT username, respects_received, look FROM users AND users_settings WHERE rank &lt; 7 ORDER BY respects_received DESC LIMIT 10&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $result = mysql_query($query);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; while($row = mysql_fetch_array($result)){&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ?&gt;To call it &lt;?php echo $row['respects_received']; ?&gt;[/spoiler]</blockquote>

[QUOTE="Kristopher, post: 388953, member: 1958"] I'm currently trying to get the script created below to show information from 2 tables, users and users_settings and so far its not displaying either. I know for a fact this script created works when you are just calling for one table in the database just not sure how to join both tables in one query if that makes sense. [Spoiler] <?php $query = "SELECT username, respects_received, look FROM users AND users_settings WHERE rank < 7 ORDER BY respects_received DESC LIMIT 10"; $result = mysql_query($query); while($row = mysql_fetch_array($result)){ ?> To call it <?php echo $row['respects_received']; ?>[/spoiler] [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members