Indie-Resource.com

Hello again, I apologize if I am posting too much, I'm just getting stuck a bit more the deeper I get in to my game. Being a novice programmer I assumed this sort of stuff would happen. Anyways, here's my problem.

I am trying to display move names from a db. I have a $_GET['id'] stored in the variable $id. I am using this var to query a specific moveset from my moveset table. From there I need to output each move column (weak1,weak2,medium1,medium2,etc...) which has a moveid stored for its value and coresponds with the moveid in the moves table. Ultimately I want to just display the movename but have to pull the user profiles ID, get their moveset, then pull each moveid in their moveset, then match that moveid to the moveid in the moves table and in return pull the movename.

Here is my current code but it is only echoing the moveid:

So are you actually trying to echo the column names and then the corresponding Moveids?

BTW ther eis no such thing as posting too much. That is what these forums are for , ask away!

I am just trying to echo the move names, but I am using the moveid's(which are both in the moveset and moves table) to get them to join in my query and spit out just the move names. The code I listed above spits out the moveid's based on the wrestlerid(id) from a form on a previous page. I'm assuming this is going to come down to an advanced sql query that my newbie brain can't think of right now. Maybe joining a bunch of tables?

Tables:
moves - which has the moveid and movename
moveset - has 20 columns for each move slot and each move slot has a int representing the moveid in the moves table. this table also has a column for wrestlerid to link a specific wrestler to the moveset

I'm also using $_POST['id'] from a form on the previous page (wrestler select screen) to get the wrestlerid selected by the user. Hope this helps a bit!

Also, glad to hear the posting isn't a big deal. I appreciate it!

BTW NEVER EVER DO THAT!
"SELECT movesets.*, moves.* FROM movesets WHERE movesets.wrestlerid = '$id'";

Check out:
http://php.net/manual/en/mysqli-stmt.bind-param.php

Why? Because having values directly into your SQL opens the door to all kind of SQL injection hacks

Yep! Someone could DROP your whole database, or, even worse, inject their own values into it, making them an admin or worse.

And as Halls said, this is a free-for-all forum section. Normal rules of topic spamming do not apply here. People that want to help can come in and help, and people who would be annoyed by that can skip the section.

I am still trying to understand the entire setup but sounds like you could just build an array from a first query that is all the move names then when you query the ids you could cross reference the array versus trying to figure it out in sql.

I would highly recommend using a good ORM pattern like active record or something of the sort. You will get really complicated joins and a lot of duplicate SQL queries, which can be easily solved using a good ORM. My personal favorite is the native Kohana ORM, Yii's CActiveRecord is also a nice class. I could also vouch for this one: http://phpactiverecord.org/

If you want to go the hard SQL route: https://stackoverflow.com/questions/101 ... h-3-tables

I second at least using something like ActiveRecord. AR's learning curve is much smaller than an ORM and you can typically drop an AR library into any project, which isn't exactly true with most ORMs. Most ORMs require a fair bit of logic redesign if you are currently making queries directly in code.