Maq

Then the error makes sense, right? I don't see an 'id' variable in that URL. How is this URL being generated?

Hi and welcome to PHPF I personally like Eclipse and Netbeans. Here is an extensive list of IDEs: http://www.phpfreaks.com/forums/index.php?topic=277416.0 We all start somewhere and I'm sure you will learn a lot here. If you do a search in the Miscellaneous Section you will find people that have asked this question in the past. We also have a sticky with a list of suggested references & books: http://www.phpfreaks.com/forums/index.php?topic=58799.0

Can you post your my.cnf?

Obtaining variables via GET is essentially through HTTP. Show us the URL that is being called. i.e. Your GET is looking for a variable 'id', so your URL should looking something similar to: www.blah.com/index.php?id=17

Ken is saying the isset method should only be checking your POST variable, not the entire condition. But I think you might need another condition because if you use: isset($_POST['username']) == '***' then you're comparing the BOOL return value of isset to the string '***'. Try: if (isset($_POST['username']) && $_POST['username'] == '***' && $_POST['password'] == '***') {

Hi Kieth, welcome!

I have no clue what this means... Is the query broken? You can't connect? What happens? Please elaborate.

In the future, use tags around your code.

I've never used this before, but surely there's some sort of error log it writes to. I would check the documentation.

You bumped twice. Correct, you would want to use a join. Google some examples and give it a shot.

Please use tags when posting code in the future. Please be conscious of where you're posting. This doesn't seem to be a regex question (I moved it). What have you done to isolate the problem? There is a lot of code there.

This topic has been moved to PHP Coding Help. http://www.phpfreaks.com/forums/index.php?topic=328758.0

I would also suggest using some sort of framework such as JQuery, specifically - http://api.jquery.com/load/

Heh, I actually knew that, my buddy is Lebanese You're welcome.

If you want to exclude an exact value then use: AND code != 'something' EDIT: Also, I'm not sure what your default value is (assume it's NULL) but you may want to check for an empty string as well. AND user != ''

This topic has been moved to MySQL Help. http://www.phpfreaks.com/forums/index.php?topic=328753.0

(New topic link from hijacker - http://www.phpfreaks.com/forums/index.php?topic=328749.0)

@chicago, next time follow what ken posted. I split your topic this time, so you do not have to start a new thread, but please do in the future.

Hi Nudd, welcome to PHPF.

Hi aulus, welcome! I'm sure you will learn a lot here.

Yes, none of these variables are defined in update_ac.php: $user_name $user_lastname $email $user_id

I would imagine 'category' and 'sub_category' would be the column(s) you want to check for similar products.

There should be a type or family etc. column that you can extract the products from. You already have the information from the clicked product. Can you post some of the relevant table structures?

You mixed up the conditionals, try: $traderss1=mysql_query("SELECT * FROM `poke_owned` WHERE `box`='1' AND `traded`='0' AND`trainer`='" . $trading->username . "' ORDER BY `name` ASC");