Maq

Sure, I'm pretty sure my syntax is off, but I'm sure you'll figure that out soon enough. Post any more problems, if not mark as solved please. Good luck.

dflow, please post ALL the relevant code. We don't know how $row_RsPDetails['CountryID'] is created. Do you have debugging on for both PHP and your query statements? Like Yesideez said, we need more information or we're just guessing!

What error were you getting before? Could you also post your current code with ALL of the errors?

Something like (syntax may be off): SELECT part_num FROM table WHERE (part_num > 1999 AND part_num 7999 AND part_num You could use 2 between clauses as well.

You don't get an error for this? $insert = "INSERT INTO users (mygroups) WHERE username = '$username' VALUES ('$groupname')"; I think it should be: $insert = "INSERT INTO users (mygroups) VALUES ('$groupname') WHERE username = '$username'";

JS is case-sensitive, try onChange.

You need to update that table every time someone visits your site. UPDATE visitors_table SET visitors_visited = visitors_visited+1; You must utilize sessions if you don't want to add a visit each time that user goes to another page on your site, sort of like tracking them. This question could get messy when your specifications get involved. It's better that you read a tutorial about this. Try Googling "php tracking visitors".

Heh, I was just there... That's weird, maintenance maybe. Why don't you Google for "msyql what is join"? Have you tried the query I've provided (with minor modification)?

Can we see what you've been up all night working on? It's easier for us to modify your code and give you ideas rather than creating a whole new class and script for your data.

No. How do you think people get data from 2 different tables in 1 query? All join does is simply temporarily join these tables in one structure. Please read this.

Why can't you JOIN the tables together? Something like this: *not tested* SELECT * FROM table1 t1 LEFT JOIN table2 t2 ON t1.id=t2.id WHERE t1.stat_type = 1 AND t1.stat_code = 1 AND t2.banned = 0 ORDER BY " . $Order . " DESC LIMIT " . $start . " , 100

If you're using windows it's usually in, "C:\WINDOWS\system32\drivers\etc\hosts".

Please state exactly what you're trying to do or give a specific example.

Yes, look at subqueries.

ALTER TABLE visitors_table ADD visitors_visited INT(20);

You need to submit somewhere with the action variable. Since you're submitting to the same page use this: </pre> <form method="post" action="<?php%20echo%20%24_SERVER%5B'PHP_SELF'%5D;%20?>">< Your error usually mean there is some format issue, like missing a semi colon. Try replacing the line above and see if it works.

Listen om, please make a new thread in the security section. We already critiqued your site and you've gotten enough feedback. Every time I click on, "Show new replies to your posts." your thread is the first one to pop up and it's getting very annoying because for some reason I always have to reply. No, your site is insecure in more than PHP nor is it logical.

Pseudo: SELECT all your data. Use HTML and embed your SQL results in the links. Example: On your next page you need to use $_GET for these. And then: I don't know what this means...

Code please...

These questions you're asking are very broad. You should do research on forms first. Please come back with specific questions. There are plenty of tutorials, examples, topics etc... already out there that you can reference.

Look at array_merge.

Create an associative array just like what the query returns.

^--- Why do you have 2 tables? Is one for the headers and one for the data? You should just use tags...

-After you sign up it says... -Hard to navigate around. For example, after I activate my account there's no link to sign in. -What is the whole site about? I mean there's no description or instructions on what to do. -I like the layout it's simple, nice, and clean but I think it still needs to be a little more 'war-like', like nrg_alpha said.

Look at this line: This is what you're passing to flights.php (nothing). You want to have this: