.josh

You can setup a condition to check which button was pressed, but PHP is a server side language. Each button would have to be a submit button, and the user would have to press the button, and the client would make another request to the server. In other words, the page would have to be reloaded every single time. It's more secure, if that's what you need, but if security is not all that important (as in, you're not gonna lose sleep over whether some dude rightclick > source's it to see the price, the more efficient method would be to do this with javascript. Or you could mix it up with ajax. It's a middle road in that you use javascript to handle the event (the clicking) and it makes a (smaller) request to the server for the price. That way, the user cannot right click > source for the price..but it's not as secure as straight php because ajax can be disabled just like javascript, making your page unworkable.

If you have no control over the refering site, then I'm afraid you're out of luck; that's the only thing offered. Your only consolation is that even though it's fairly easy to spoof (all you really have to do is edit a file on your computer), most people barely know how to turn on their computer. Now, if you DO have control over the refering sites (as in, you can insist certain pieces of code be transmitted from them, look into token passing.

Make a script to update your table, in it's own file. Setup a cron job to run it every x time/day that you want it. If you do not have the server access to start a cron job, you're going to have to basically make a script that's called on every page load to check the date/time and run it if it's the appropriate date/time. This isn't as accurate though, as it is dependent on pages being requested by people. Also it uses more resources and generally slows down everything.

you could make your language link a submit button instead and have the text area carry over as a posted value. setup a condition in your script to check whether it was the language "post" button pushed or the real submit button.

so..are you asking how to setup sub-categories in your database? write code to show drop downs? You're being kind of vague.

repost your code as it stands right now with the changes

okay, so on paper (not in the code, but rather, what you expect it to do) what is the difference between clicking on the first page and clicking on page 2,3, 4, ...? Because I'm still kind of leaning towards that if statement not really being necessary, for what your trying to say. That is, according to my best interpretation of what you're saying, you should get rid of the if...else statement and 2nd query altogether and just use the first query straight up.... ...unless there was some reason you needed to check whether the person was on page 1 or not (other than say, the pagination link generation part, where you have to figure out if user is on page one, don't generate a page 0 link, sort of thing). So, back to my first question: why is this if..else statement here? What's the plan for it on paper?

pagination is the act of breaking down a list into separate pages. Yes, it is most commonly used with databases, but it doesn't matter where the data comes from. Glad you got it all sorted out.

umm..well, if you are wanting the query in the if $SearchSelect == 1 to be ran every single time, then...remove the condition altogether, and just have it run every time? I'm going to assume that's not what you're asking though, as that's kind of a given...so I guess if you could rephrase and/or be more specific, I'll take another stab at it.

I'm not seeing where $searchselect is being defined, so it's always going to execute the query in the else statement. Also, where is your query that actually pulls the 10 rows?

How is this thread any different from the other one you posted earlier asking for pretty much the same help? I'm going to assume since your other thread was marked as solved, that this is a different problem, but it's the same kind of problem. I'm moving it to where I moved your other one, I have noted your apology for posting in the wrong place, but come on, we've already been through this...

so...you're saying that not a single piece of that code works? What have you done to try and fix it, other than just post it here and hope for a magic wand to be waved? What have you done for debugging? Have you inserted echoes inside your conditions to see if they are ever being met? Have you echoed variables to see if they are being passed and/or are holding what you expect them to be holding? You need to tell us what you have done and what happened, because we obviously don't have access to your files/dbs/etc.. people offer some help and you respond by saying "it" doesn't work. Well, what didn't work about it? Start over from square one, checking the variables, etc.. because that magic wand just doesn't exist. I'm not trying to be an arse, but you can't just post code and say "It doesn't work, fix it."

Can you please elaborate on that "It's not working" ? Because according to your code, if the session variable doesn't exits OR it does exist but (time-var) is more than 15..it just sets a session variable...and that's it. Is that the "it" you're trying to do, only it's not working, or is "it" something else?

whole sticky dedicated to this. thread closed.

What you have there is perfectly legitimate, however, depending on what your goal is, you could conceivably use something like JOIN to streamline your results. Offhand, it looks like you have two separate tables, one for account info and one for "game" or "content" info and the info from each table for the user has the common denominator of if rider_id and id (it looks like each table holds the same information). So, you could possibly use something like JOIN, INNER JOIN, LEFT JOIN, etc.. (lookup relational databases) to streamline. I'm going to go ahead and move this to the sql forum though, as those guys over there are much more knowledgeable in that area.

^ right. PHP is parsed on the server and then sent to the client, so you need a client-side script to do something like that. Alternatively, depending on what exactly you're trying to accomplish (in relation to your content), you could possibly setup a condition or something to check something or other and run the query at the beginning of the destination page(s).

well then I suggest alternatively you could pass a token from page to page via sessions and check for the token upon each page load. So..if user were to manually enter in the address from the url...no token is generated/passed.

$max = 100; // some random number to be counted to $counter = 0; // initialize counter for ($x = 1; $x < $max; $x++) { // loop to count to whatever // % is called modulus it divides $x by 4 and returns a remainder if ($x % 4 == 0) { // if the remainder is 0.... $counter++; // add 1 to the counter } // end if } // end for

I would also suggest scrapping the whole idea of passing your variables through the url. Rather, maintain what areas the users have access to in your database. Have one "display" or "control" page that queries your database based on user's info. Have your query select relevant info and display a single page based on the user's level etc... In short, passing variables through the url should never ever ever be used unless it is completely harmless...like for pagination.

the keyword you are looking for is "pagination"

LoL I have dabbled in flash quite a bit, myself.

hrmm..okay, so you already have a database, and you are wanting to phrase a query to pull specific information based on your criteria? I mean, I could help you on some php code to sort through it all if you do a query for everything first, but that's not really efficient. I think you'll probably find the sql forum more useful so I'm going to go ahead and move your thread over there. One of the resident database experts should be able to help you out there.

Okay I'm not quite sure I'm understanding this 100% but it seems to me that what you are saying is that for each row of your table, you want it to look like this, right? Group1FirstNameLastNameBusinessNameGroup2 BobSmithBobSmithCrayolaCrayola JohnDoeJohnDoeBubbleGumBubbleGum BobSmithBobSmithBubbleGumBubbleGum If that is the case, first off, I don't really see why you would need the Group2 column, as it is virtually identical to the businessname column...2nd, Group1 would be made simply by concatonating your Firstname and Lastname variables. I don't really know how you have anything else setup, but it seems you would do that in the information entering process, in the part of your script that creates the new entry; just make a new temp var $group1 = $firstname . $lastname; etc... if that's not what you're saying then..uh, please elaborate further.

yes. But if there is a file in that directory with the same name, it will overwrite it.

If I do anything officially official I usually cross all my t's and dot all my i's, but I have hundreds of little script projects/messing arounds/hobbies that I don't really bother with "formal" things on.