Help with mysql select and array
Okay, so what I'm trying to do here is have a table underneath the member.php (memberinfo template) page with game statistics that are stored in a db. I've got a profile field set up where the users put in their username for the game -- that's how their stats are pulled from the table. So, table configuration: I've got around 9 or 10 fields, with things like kills, deaths, headshots, etc. What I'm trying to do is run a select query like: "SELECT * FROM table_name WHERE name = '$post[field5]'" And from this, I want to generate an array so I can use $stat[kills] or w/e in a template to post the row data from the kills field. Does that make sense? Anyway -- thanks in advance for any help. It's much appreciated.
I've tried a bunch of codes that people have posted with similar problems -- but none of them yield any results.
|