Search results for query: *

Hi I am trying to start phpMyAdmin, but so far witout success. I unzipped it into a directory(phpMyAdmin) inside my root directory(wwwroot) on Win XP Pro. I changed the variable in the configuration file to point to this directory (http://localhost/phpMyAdmin/). I never created any...

Hi, I want to create a website with a MySQL DB at the back end. And I am being told that I'd be better off using PHP rather than ASP for this purpose. So far, I only know some ASP, but no PHP. Are there any advantages to using ASP instead of PHP for the website? Thank you!

Hi I want to create a website with a MySQL DB. I need it to perform basic things like adding, deleting, modifying and seaching user records by means of web forms. Also, I want users to be able to anonimously email other users through a web form, and also keep a copy of all correspondence on the...

Hi I think I have installed PWS on Win XP. I even have the Inetpub folder and the wwwroot directory inside it. But I cannot find a way to start the server, and also, (or therefore?) IE does not display any .asp pages in the wwwroot directory. How can I run ASP on Win XP? Thaks a lot!

Hi, Is it possible to concatenate records into one? I mean, that if I have a table of software titles, is it possible to put them all into one record? Thank you.

Hi, I need to make one field unique in a table. The table description (show create table_name) already lists this field as being a KEY. I don't know what this means, but when I say: "alter table table_name add unique (field_name);" I get an error: "ERROR 1061: Duplicate key...

Hi, I cannot get a replace querie to replace data in one table with fields from another. Instead, it appends new rows. In both tables I made one field a UNIQUE KEY. This field is the common denominator in the two tables. But when I say: replace tbl1 (fld1, fld2) select fld1, fld2 from tbl2...

Hi, What is the syntax in SQL to change an existing column to be unique, but not create a new unique column?

Hi, I need to make an existing column unique im MySQL. When I say: alter table pr2_users_values -> add unique f_login; It gives me an error at line 2 near ''. Does that meean that something is missing from the statement? What is missing?

I am trying to run an UPDATE query in MySQL. This query was made and tested in Access, and it worked. Now I am trying to run it in MySQL and it gives errors. How is MySQL syntax different from Access SQL? Here are two versions of the same query which work in Access, but neither one works in...

Hi, I am trying to update certain columns within one table with data from another table. Eventually, this query is for MySQL, but I am first testing it in Access. The error message the I am getting is: "Operation must be an updateable query". What am I doing wrong?: Update...

Hi, I seem to have similar difficulties discussed here, and I still didn't get it working. I am trying to update certain columns within one table with data from another table. Eventually, this query is for MySQL, but I am first testing it in Access. The error message the I am getting is...

Hi, I was asked to make an icon appear in the links toolbar (instead of that 'e'), when you drag it to the links tolbar. It will also appear in the Faforites (instead of the 'e') etc. You could see an example of what I mean on this page: http://www.devguru.com/Does anyone have any idea where I...

Hi, I need MySQL DB to work with FoxPro (.dbf) tables. Ideally, I am looking for an option in MySQL to link FoxPro tables in order to run queries on them from MySQL. (This option is available in Access, but does it exist in MySQL?) If you know how, or have any ideas or suggesions, please let...

Hi, I need MySQL DB to work with FoxPro (.dbf) tables. Ideally, I am looking for an option in MySQL to link FoxPro tables in order to run queries on them from MySQL. (This option is available in Access, but does it exist in MySQL?) If you know how, or have any ideas or suggesions, please let...