TalkPHP - View Single Post

NathanH · 02-19-2008, 10:57 PM

Quote:

Originally Posted by Wildhoney

As for your little problem, you will be wanting to add a WHERE clause to your SQL query. The WHERE clause is synonymous with -- I want only these rows! The way you would do that is, as you have an ID in your table, every member has a unique member ID -- or at least should have if that row is the primary key, as well as unique and, optionally, auto_increment.

I hope this helps you! Incidentally, is this for a game? Do we good folks get a sneak preview?

I had tried the WHERE clause, but was missing the SESSION variable. I remember thinking about whether to use SESSIONs or not, but as I'm trying to get to grips with basic stuff I made the mistake of missing it out! :P

I will be going to bed now, but will definately read up on sprintf when I'm next back. Thank you for the help, the tips and the heads-up! :)

I told myself I would learn on the structure of a game, as it provides me with (what I hope) is mainly what I will be using with php & mysql. General register/login/logout, general account stuff and nothing too complicated (I say complicated after this embarrasment :P).

And as for a sneak preview- there really is nothing, my design is somewhat limited and because I'm new(ish) there's no functionality :)