Maq

You need to JOIN the tables by product_id and have a condition that specifies which order_id it is from the orders_table.

That looks correct. Are you sure this clause isn't effecting the result? WHERE sid='505'

That's what I thought. I took this out of the MySQL manual, so test it first but you can use a combination of UPPER and SUBSTRING functions to accomplish this: SELECT CONCAT(UPPER(SUBSTRING(firstName, 1, 1)), LOWER(SUBSTRING(firstName FROM 2))) AS properFirstName You would have to update the table and use REPLACE to actually change the values.

That's correct. I'm not sure what you're trying to do. What is happening now? What exactly do you want to happen?

If you're getting it via HTTP(phpquestion.php?qid=2) then you would want to use something like: $qid = mysql_real_escape_string($_GET['qid']);

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

Correct me if I'm mistaken, but isn't that the same thing? If not, could you clarify what you mean.

Some excellent reasons why: Taken from: http://webdesign.about.com/od/css/a/aa073106.htm

Does it display the alternative text, "concorde"? What does firebug say when you inspect it? Are you sure this is the correct directory? i.e. - Does "Pictures_Other" reside in the directory of the file where you call this piece of code:

You're using $qid before it is defined.

Coming along very nicely. The nav looks nice and the layout as a whole looks simple and clear. A couple things that catch my eye: - Seems very spacey. The left navigation has too much margin from the header and main content. - The header & footer are blank. I think this was mentioned before, but how about an image for the header and some more

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

Gotcha, glad it's solved.

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

Please, let's not take an ugly turn in this thread. CV has contributed a great deal to this community, not only posts (which the majority are helpful), but blogs, tutorials, policy write-ups, ideas, moderation, the list goes on. I'm sure if you do a search on Google, or even here on PHPF, you will find some good SEO tips and tricks to help you get started. If you have specific questions we will be sure to answer them. Here are some novice tips: http://sixrevisions.com/content-strategy/seo-tips-improve-web-design/

EDIT: What's the exact error message? I assumed you were referring to this line: echo "I'm sorry our database already contains that username please choose a new username to continue."; Echo out $query to make sure the username you expect is actually being queried with. If not, we would need to see your HTML form, maybe the name is different.

Yes, do not use raw POST, GET or any data that could possibly be manipulated by the user, directly in your query. For sanitation, you can use mysql_real_escape_string.

You're missing a ; at the end of your mysql_query call.

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

Please use tags.

I'm confused, I don't see any variable in your script named message. If I had to guess, you're on the right track here: by concatenating the data you can store it all in a single variable.

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

Use the value attribute.

This topic has been moved to mod_rewrite. http://www.phpfreaks.com/forums/index.php?topic=327302.0