gple

If a user is on your website through aol. Is there any code that can be created to take that screen name and store it in a db.

I have created a Shopping Cart system for my website but I am very concerned regarding the checkout page in which the customer will enter their home address and credit card information. Does anyone have any good suggestions as to how this should be approached. I am in the process of setting up Payments Pro with Paypal which I know is secure. I just dont want this sensitive information to be placed on my website. Any suggestions.

Now it is only outputting the first set of characters before the "+"

I am passing this variable to a text box in the new page but between each word is "+". How do you get rid of that.

I have a link like this: $descr="I love New York"; a href=add_prod.php?descr=$descr; This only passes I and not the whole string of words.

But I want to select 1 selection from the drop down and pass two values. I dont want to choose two selections.

how do I pass two values (cat_id and Id1) else if ($action=="sub_cat") { $result=mysql_query("SELECT * FROM subcat, type where subcat.cat_id=type.id"); $num=mysql_numrows($result); echo "<form action=add_prod.php?action=change_cat&id=".$id."&var=".$var." method=post enctype=multipart/form-data>"; echo "Category: <select name=price id=price>"; echo "<option selected>--Change--</option>"; for($j=0;$j<$num;$j++) { $scat=mysql_result($result,$j,"subcat"); $cat=mysql_result($result,$j,"type"); $cat_id=mysql_result($result,$j,"cat_id"); $id1=mysql_result($result,$j,"id"); echo "<option value=".$id1.">".$cat."-".$scat."</option>"; } echo "<input type=submit name=submit value=Change Price></form>";

I have a form which enters information to the DB and one of the fields is to upload an image. The image is a decent size (lets say (800x400). Is there anything I can write so that the image gets uploaded (800x400) and a smaller image gets uploaded as well (100X50). So one image is uploaded but two get put into the directory at different sizes.

Anyone know of way to take the current date (today) and get the date for the previous Thursday.

I have a column that has sizes and I want to sort (42 Regular, 42 Long and 42 Short). How would I sort this to be (42 Short, 42 Regular, 42 Long)? There are other sizes (44, 50) so I want to sort by the size number first and then sort by another column afterwards.

how do i create a sql statement that orders only the first three characters of a particular column. ie if I have a column called products and I only want to sort by the first two characters of each product. how do i write that?

I have two tables (stats, years) stats has two categories (ID, TID, text) year has two categories (Year, TID) If I want to update the text by in STATS by year, does this look right. mysql_query("UPDATE stats, year SET text="hello" where year.tid=stats.tid and year.year='2007'");

I still dont see the .00. If it is .97 it gets rounded up to the next dollar

I want to take a variable and make sure that I output to the browser in dollar format ie if I set $price=100. I want to make sure that $price appears as 100.00. in turn make sure that when $price=100.97 is outputted as 100.97

I am developing a shopping cart and I just want to know how I would define two or more distinct sessions at the same time. Ie if one user comes in, how do I define one session with one name and another session with another name.

This is what the situation is: I am building a page that reads how many columns are in a table. Depending on how many columns, a form is created to input data into each of those columns. Then I pass the data to another page which inserts it into the table. But the question is this: I need to create an insert statement dynamically depending on how many columns there are.

I have a bunch of information that I want to insert into a table insert into TABLE values ('hello','I','am','lost'); pretend that the words that are being inserted are coming from a form for another page. In he case I above I have declared that the table has four columns to insert into. What if I do not know how many columns there are?

How do i pass all the values onto another page that I have gathered. If I have a form and place info into the array, how do I pass the value in that array over to a new page.

How can I search through a table and output the name of each column?

OK. I figured that the checkout was done in the Https:// section. I am confused by all of this. Is there a website or something I can look into on how this all done safely and securely.

I guess what I am trying to get at is this: I have a website created for online shopping (tables with products and customer information). How can I guarantee that the credit card information that they put into the system is not going to be hacked into. Should I create a customer table with all the information except the credit card info and have them put the credit card information in every time they want to purchase a product?

I get: You have attempted to establish a connection with "DOMAIN.COM". However, the security certificate presented belongs to "Web Host.com". It is possible, though unlikely, that someone may be trying to intercept your communication with website. If you suspect the certificate shown does not belong to "Domain.com", please cancel the connections and notify the site administrator. What does this all mean.

I believe the server I am using has this. How can I test to see if it does support?

I am building an online store. How do I go about making the checkout pages secure (it https://). Any hints on where to start looking into this.

No I am getting an error message: supplied argument is not a valid MySQL result resource