• Registered: 2006-02-18
  • Posts: 7

Topic: Data Query???

I do not know much about how to query SQL data with these class things these forums use. I was wondering how to because I need to make data show up for equipped items on a user's posts.

2 Reply by Cajual (edited by Cajual 2006-02-18 08:26)

  • Registered: 2005-12-02
  • Posts: 28

Re: Data Query???

$data = 'SELECT * FROM weapons WHERE u.user='.$id.' AS u.group IS g.id'; Let's pretend we pull all the weapons from the specific user(s).
$this_array = $db->fetch_assoc($data); Use the inherant shorthand to pull the info into the array.
echo $this_array['username'];
echo $this_array['level'];
echo $this_array['weapon'];

I hope I didn't misunderstand you.

The class list for the mysql shorthand is pretty simple:
$db->query/fetch_array/fetch_assoc/num_affected

  • Registered: 2006-02-18
  • Posts: 7

Re: Data Query???

Thanks this is exactly what I needed to know.