benanamen

Didnt fix it. There is no blank line before post is submitted.

Yes, exactly.

19 Posts and I still can't figure out what your doing.

Personally, I don't know why the site was "Upgraded". I never had any problems. Only issue I had was the annoying double space when you did a quote.

Completely senseless thread.

You are improperly storing the datetime. Format should be YYYY-MM-DD HH:MM:SS

Are you really advocating using the actual word value instead of doing as Psycho suggested " I would have a separate table with the status descriptions". I am sure you must be aware of the numerous issues with using enum.

Depending on the name of a button to be submitted for your script to work will completely fail in certain circumstances. You need to use if ($_SERVER['REQUEST_METHOD'] == 'POST')

Yes and yes. I didn't say yours was wrong. And yes, it is the field name, not the field value which I think is what the OP needs since he uses TD and not TH I use that very type of code on my table row list pages to create dynamic tables. Pulled from one of my pages... foreach ($result as $row) { echo " <tr> \n"; foreach ($row as $name => $value) { echo " <td>$value</td> \n"; } echo " </tr> \n"; }

<table> <?php $row = mysqli_fetch_assoc($result); foreach ($row as $field) { echo "<tr><td>$field['field_name']</td></tr>"; } ?> </table>

You could just search and replace the ( with a ,( which will give you a comma separated list as long as that format is consistent in your data meaning numbers followed by a left ellipses. That would give you 9780735585157,(pbk.;teacher's manual) Then you could do whatever you want with the properly formatted data.

Example: <?php $sql = "SELECT id, name FROM table"; $stmt = $pdo->prepare($sql); $stmt->execute(); $result = $stmt->fetchAll(); ?> <form action="<?= $_SERVER['SCRIPT_NAME'] ?>" method="post"> <select name="id"> <?php foreach ($result as $row) :?> <option value="<?= $row['id']; ?>"><?= $row['name']; ?></option> <?php endforeach; ?> </select> <button name="submit" class="btn btn-primary">Submit</button> </form>

Why in the world are they having someone with no experience build an application? That's because they know even less than you do. In that format you can pretty much end up with any output you want. Since you have no experience, it is probably not something you should be attempting for use in a real business scenario. I could not PM you. I am available for hire.

How about it OP? What exactly do you have going on?

Still no need for a second table even in that case.

You should have one table, not two. What if the children have children, then they are also parents. This is no different than products and "Sub Categories." id - name - parent_id See the The Adjacency List Model here: http://mikehillyer.com/articles/managing-hierarchical-data-in-mysql/

OP, you need to Romeo Tango Foxtrot Mike.

OP, You were already given numerous replies to this on the other forum. Why are you again posting the same exact question here? As you said the other day on the other forum

Admittedly, I am far from clear on what he is doing with the limited information he has provided in this thread. Looking at the image in post #22 it just doesn't look right for a DB design. The comment was in direct response to the 3 tables at the bottom of the image. Admin, Master, and Franchisee which all have a single column with an ID from who knows where or what it is supposed to mean. You're not really saying that is correct are you? Additionally, the OP's sql dump from post #24 has no keys tying any of the data together and then there is the negative values in table Master_Reqruitment. What in heaven's name does that mean? I have no idea what information was given in some unlinked thread. Could you, @Jaques1, build a proper DB application based on this thread?

Whatever your doing, inserting an id into individual tables is just wrong. You don't seem to grasp how to provide the information needed for someone to help you with this, so I am going back to passing on this. Good luck.

Does each level only recruit the level directly below them or all levels below them? Example: Can a boss recruit a franch or only a master and admin? What happens if a recruit does not get all the confirmations? This is what I mean by rules and details.

Not upset at all. Lets try this again. Forget that you have any code or database and you were hiring someone to build the application. Provide a detailed explanation of the project and requirements. All I know so far is it is some sort of "recruiting" app. Recruiting who for what? Who is recruiting who? What rules or restrictions are their on the recruiters and the same for those being recruited and so on. What are ALL the parameters for this app?

What exactly is the overall thing/purpose you are doing with this "program"?. (I dont mean how you think whatever should be done)

I am going to leave this to someone else. Do you really think someone could build a database application from the information you provided in this thread? And I don't think the DB is wrong, It just is. * A flow chart is not business rules. * The picture is NOT a blueprint. It is your incorrect attempt to do whatever it is you're trying to do which you have far from made clear. * "simple recruitee - recruit application." Who the heck knows what that involves. You clearly have not said. * "The rules are simple as I told you that it's hierarchical in nature." - Completely meaningless. No one could build anything from what you have said and provided. I have no desire to continually have to drag information out of you.