kenshintomoe225

hmm... Well..there is a pointer associated with mysql_fetch_assoc. Each time you call it, the pointer moves up to the next row. In your code, you call it once to populate $rsSilkrobestyle, and then again each time your while loop runs. Does that query return one row? If it does, thats probably the reason for your error. For example, your code could look like this $silkrobestyle = "SELECT * FROM styles WHERE categoryID=13 ORDER BY styleID"; $silkrobestyle_query = mysql_query($silkrobestyle) or die(mysql_error()); The dropdown menu code is: <select name="style" class="dropdownboxstyles" id="style"> <?php while ($rsSilkrobestyle = mysql_fetch_assoc($silkrobestyle_query)) { ?> <option value="<?php echo $rsSilkrobestyle['styleID']; ?>"><?php echo $rsSilkrobestyle['style']; ?></option> <?php } ?> <?php mysql_data_seek($silkrobestyle_query, 0); ?> </select>

not quite sure what you're asking here with your second post. After a player logs in, pull the team id out? SELECT player_name, team_id FROM players_table WHERE player_id='some_variable_you_set_via_form' is that what you're looking for?

I would go with get_browser(), you might as well!

Can you post the form as well please? This only shows how $_SESSION is being set, not $_GET

Plan for expansion. Try to keep future changes to the structure of the database as cheap as possible by thinking of as many possible fields and tables early on, even if those tables end up empty or only have a few items in them. It's much more expensive to later go in and add columns and tables, and then relate them, after tons of data is already in place. Databases for a website will usually have some sort of 'user' table that is used as some sort of ACL, controlling what a certain user has access to. After that, it depends on what you want you site to do. I would designate one server as your database server, one as your web and application server, and have the web/app server connect to the database server. There are a number of things you can do. Namely, the way you write code is going to have an effect here, also the design of the database can play a part, and even the queries you write for that database. You might want to study relational databases in depth a little if efficiency is a big thing for you, as its a topic that would quickly fill one of these threads!! hope this helps!!

I'm the "rather do it myself" type of person, so I don't mind the model implementations being done the way they are in CI. The only thing I need my framework to do at this point in time is implement MVC and give my applications a bit of structure that they otherwise might not have. The libraries and helpers that do come with CI are decently helpful as well!

I would recommend checking out some generalized OOP books that look at the topic in depth. If a language is calling itself OO, the techniques and features you learn about in one of these books will apply. It's definitely worth looking into as you can then apply what you learn to tons of other languages and platforms. Here are some suggestions: http://www.amazon.com/Object-oriented-Programming-Brad-Cox/dp/0201103931 http://www.desy.de/gna/html/cc/Tutorial/tutorial.html and a google search for Object Oriented Programming will get you tons of results.

I"m happy you're content with Zend I'd really like to start using it, but I'm still relatively new to PHP as well as frameworks. While I won't argue who is more feature rich, as Zend clearly wins that battle, it's like using a ballistic missile when you only need a fly swatter. The documentation on Zend is pretty good, I still had trouble getting it setup. I found CI"s doc's more helpful in that regard.

That sounds like a great idea!

he changed the if statement to $num = mysql_numrows($result); if($num != 0){ Makes a lot of sense actually If it returns 0 rows, then it fount nothing in the database.

One potential problem I see right off the bat is your submit button and your text field have the same name. Please name them different things and try again.

you know what total brain fart Forgot about submit buttons having values

Could you please provide an explanation of what you changed? Copy and pasting code rarely helps someone learn

i'm not quite sure I understand the question. Could you please rephrase?

sure thing! And just as a quick tip, for something like keeping track of a logged in user, you want to set those session variables only once, like right after they login. Don't keep clobbering them with data, or else you run a very high risk of corrupting the values inside and breaking your page. if( $login == TRUE;) { $_SESSION['user'] = $username; $_SESSION['pass'] = $password; $login = FALSE; //don't touch any of these anymore. Its just an example, I'l leave it to your good sense to put it to work }