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...

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...

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

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

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

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=...

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

Hi, I have a site in which I want to unable users from certain countries to access my site... or maybe re-direct them to another page. Is there any way to identify based on IP what country the user is comming from? and then you something like: If IP = IPrange then Request.Redirect...

Hi, I need to create a search page in my site using php. Is there any way to do it without the need of software? Thanks, sbayter

Hi, I have a website in which I seel phonecards online. Recently I had a problem with a guy that seems to have a credit card database and keeps buys cards like crazy from lebanon. I had to disable the site temporarily. FYI, When you go to the site you can buy as a guest or with your own...

Hi, I have mySQL db and a simple page with a query which displays the db. The page was working perfect but when I added dos more columns to the db it stoped working and now it doesn't display anything. When I run the query in phpMyadmin it show all the info. but when i upload it to the server...

Hi, I have this sql statement that will be inserted into a mySQL db. However it is giving me the following error: Parse error: parse error, unexpected T_STRING in c:\web\process\test.php on line 72 $sql = &quot;INSERT INTO request SET &quot; EMAIL = '$email', ---->line 72 PHONE = '$phone'...

Hi, I need to create a form which contains some information about the person and which can handle 5 file uploads. I need the files to be saved into a folder and the other information and the filenames get saved into a mySQL db. I did it in ASP using some software but now I need to convert it to...

Hi, I trying to build a site which has a database behind it. Everythig is working fine, I can see all the data in the tables from the webpage but I cannot update or insert any new data. This is the error I am getting: Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)...

Hi, I have a survey which have 2 tables, one with the results which has a the client reference number in front of each result. Somethign like this. __________________________________ |ID | QUESTION | RESULT | CLIENTREF | ---------------------------------------------- |1 | satisfied |...

Hi, Is there any way to display a html page in a flash frame or scrollbar? I'm converting my html site flash and want to display the files in my server within a frame or something. Any suggestions? thanks, sbayter

Hi, I'm creating a simple login page which goes into another page displaying the query for the user that logged in. The problem is that it doesn't show anything and when i take out &quot;WHERE EMAIL = '$email'&quot; it displays all the table in the DB and I only want it to show the row related...