Search results for query: *

Hi, I have access db and I'm trying to display a distinct item_ID, the primaryKey, and price for the corresponding record. This is the query I'm using. SELECT DISTINCT item_ID, primaryKey, min(price) FROM products WHERE status = 'NEW' GROUP BY item_ID The problem is that is gives me a huge...

Great thanks! It worked!!!! But why isn't it showing the date? It just gives an empty field. sbayter

Thanks!!! I tried that and it worked but I tried to add a "WHERE" and gave me this error: You have an error in your SQL syntax near 'WHERE Doc_Name = 'DOC1' LIMIT 0, 100' at line 1 I've never use GROUP BY. I think I once read using GROUP BY and WHERE created some conflict and that...

I'm running mySQL sbayter

Hi, I have this page that is displaying 2 columns, one is the date in which the document was downloaded and the other the email of the user. I need to show only unique emails but if I use DISTINCT it also looks for unique dates. This is what I have: SELECT DISTINCT EMAIL, DATE FROM logs If I...

Hi, I need to create a airfare website for a travel agency. I need the site to connect to the flights db but I don't what kind of laguage I could use and what kind of db I would be connecting to. I assume it could be done with php. Any help or information would be very appreciated. The site will...

Thank you very much, I think I can handle building my own cart. Do your have any samples or websites that could help me with this. Would you give a general idea of how it would work. Like what happens when a user adds something to the cart, does it get stored in temporary table and after the...

Hi, I'm trying to create a shopping cart for my site. I'm not sure what's better. If to do my own shopping cart in access with asp or to get software for it like cart32 ,miva, etc. Need recommendations. Thanks, sbayter

Thanks for the tip. If I do that the query would give me a list all all the available licences. How cart I make it so it gives me only one? sbayter

Hi, I'm trying to create an e-commerce site and have almost completed it but I need to figure out one last thing. This site is to sell software licenses. The user would go it and download the free trial and then for a full version they would have to enter a license number. There and only two...

Hi, I'm trying to create a search page that has 2 different drop downs. The first one of would pull the values form an access db and the second one would also pull the values but they depend on what was selected in first dropdown. thanks in advance, sbayter

The data insertion is in PHP. What is not in php is the CGI program that sends the email. With the class you mentioned before, is there any server configuration that needs to be done? sbayter

any other suggestions? sbayter

Hi, I have a form that when submitted saves the values into the db. I need add another action to email me that somebody has fill it out. I'm using a script I have in the CGI-BIN. I tried using the mail() function but I can't cahnge the php.ini of the server. Any suggestions? Thanks, sbayter

Hi, I have a table that record the history of visits in a page. It saves the email address stored in the cookie everytime the user goes there. I want to create a page that displays all the unique emails, no duplicates. Thanks, sbayter

that worked! thanks! sbayter

Hi, i'm trying to create a page were users can go and upload their information. This is my recordset: <% Dim myRs Dim myRs_numRows Set myRs = Server.CreateObject(&quot;ADODB.Recordset&quot;) myRs.ActiveConnection = MM_myConn_STRING myRs.Source = &quot;SELECT * FROM users WHERE ID=...

Yes, I tried that but it is also empty this is why i think the data is getting corrupted on the upload. Any other suggestions? Thanks, sbayter

Hi, I have a page with a form and all the info typed is saved into a mySQL db, however there is large text area and the format is getting all messed up. is there any way to capture all the hard returns so the format is at the user typed it? Thanks, sbayter

Yes! You really deserve it! thanks! sbayter