Jessica

Well yeah, I did. I figured out of the number of people replying here, it was likely that someone was getting it wrong. *shrug*

Are you still confused about why when you visit that page, $_GET['AccountID'] is empty?

Must be something else within the code somewhere.

Run this on a page: $flag_lookup = mysql_query("SELECT username, flag FROM users"); while($flag = mysql_fetch_assoc($flag_lookup)){ print_r($flag); } What do you get?

That doesn't answer the first question.

Are you sure the data is correct in the database? And $username has the right value?

No, the URL on the page that you are on. Look at your browser. What does THAT url say. The one that is running this code.

Because mysql_fetch_assoc returns an array. print_r($flag) and you'll see what it contains.

So... why is that? We're talking about the URL of the page you are on, not the links. Why do you think that URL doesn't have the AccountID?

Where's the problem in the code?

If it's a business expense, it's not even covered under his HOME owner's insurance. You need separate insurance for business property.

You start the loops at 1 when assigning, then start at 0 when reading. So, clearly, nothing is set at the index of 0.

Try re-reading the first post. And? I read it. It says he wants to strip anything other than alphanumeric and 5 special characters, which is what josh left in the string. Alphanumeric and those characters.

Uhm, you know who could answer this? Your insurance company

What do you mean should? Does it or doesn't it?

And so what does your URL look like? If you add print_r($_GET); to the top of the program, what is echod?

Wow, not quite what I meant. What do you WANT to do if your query succeeds? What is the URL query string?

The first error is being cause by your query failing. Look at the examples on mysql_query, and you'll want to print the error and the SQL so you can debug what's wrong with your query. Edit: On preview, what pikachu said. I'm just going to leave this here for the link to the examples.

See my point #5.

My crystal ball says .... "People who want help with a problem post their code"

You cannot have a do while block actually within a string. You are trying to concat a control structure to a string, rather than a string to a string. You can concat the contents of the block WITHIN it. $x = 1; $str = "test"; do{ $str .= $x; $x++; }while($x<10);

Holy moly. 1. Right away you try to use $AccountID without defining it. If it's coming from the original URL, you need to use $AccountID = $_GET['AccountID']; 2. Next, read about sanitizing user input and SQL injection. 3. All this: "$_REQUEST["Pool01Name"]; $_REQUEST["Pool02Name"];" Stuff? You don't do anything with them the first time, those lines do nothing. Secondly, you should be using an array for this data. $_Pool01Name = $_REQUEST["Pool01Name"]; $_Pool02Name = $_REQUEST["Pool02Name"]; Should be an array. 4. Your update uses $ContactID, which is also never defined. 5. if ($query) { exit; } This is the opposite of what you want. You also aren't capturing any MySQL errors to help you. 6. Turn on error reporting!!

Are you just trying to get the URL without the query string?

".} while ($row_AllWine = mysql_fetch_assoc($AllWine));." //this is the end of the repeat region. You can't do that. You got a syntax error, in the future you need to post your errors (after reading them)