7,368 Topics
 | |
| | I cannot get MySQL working. Can someone please help? I have changed permissions on the /var/lib/msql directory and I still can't get it started. Running Suse Linux Enterprise Server 9 # mysql -V mysql Ver 12.22 Distrib 4.0.18, for suse-linux (i686) # mysql start ERROR 2002: Can't connect to local … |
| | Hey all What is with this query $query = mysql_query("UPDATE `namitposts` SET `title` = '$topic' , `date` = '$date' ', `postee` = '$postee', `post` = '$post_text' , `ip` = '$ip' WHERE `id` = '$del'") . mysql_error(); Its not passing the variables am getting this error message Notice: Query error You … |
| | Hi all, Does anyone have an example of how to synchronize two databases on different servers? Thanks, Ron |
| | I have a databse in mysql and am looking to select the last 5 values in the database and there contence. How would i do this. Will be using php to do this. Thanks There is an incramenting variable called Id and could use that if possible. |
| | Is there a SQL query to check to see if an index (by name) exists on a table? I have this for SQL Server and for Oracle, and need to be able to query to see if an index exists before I try to create it. In some cases, I … |
| | hi, i need to create a database of images. does anybody know where i can get a database of sample images? any help will be greatly appreciated, tristan |
| | This is what I need [url]http://www.vital-ic.com/index.php?page=part&PHPSESSID=6b1baaeb7d9e4d26bdda4faa5265b7f6[/url] in the field enter xc2v and click on the arrow image for search once result comes back you will see part# links If you click any of the links it will enter the part# in to a form field How can I make mysq … |
| | Hi there ,I am working on my web site and I need some help with my search result query's If you look here [url]http://www.sensitivetechnology.com/search.php[/url] and in the top search field enter 74AC86SC the resilt will show Product ID and Description ,but it won't show quantity and price And also I … |
| | I'm trying to complete an assignment for a Certificate IV WebDesign. I'm finding it all really hard and have heaps of questions. I have installed IIS, PHP 4.3.8 and MySQL 4.0.20 on my home computer. The reason for putting myself through all this agony is i need to learn how … |
| | Hello, I have a software package for monitoring warehouse transactions. I have a need to share information across many users in several different locations.I don't want to network the pc's i can't afford that. i however notice that putting the information online saves a lot of cost for me. I … |
 | Hi All, I'm messing around with different PHP scripts on my server. I can't seem to setup MySQL. I have installed and configured it. But I have now idea what to do with it. Is it like PHP where all you have to do is install it and its done? …  |
| | MySQL 5.0 vs. PostgreSQL 8.1 what is main diference? advantage? disadvantages? |
| | hi, I have started programming (learning) to free myself from depencies.I do not know how to do the below. [COLOR=Navy]i made a form that has a input box for emai and two passord inputboxexs.on submit i have to pass the same email inputbox value as the hidden value for username.In … |
| | I have three tables, table1 store records which may have next level ID(child), table2 lists corresponding child ID, and table3 stores the possible message for that particular ID. table1: [CODE]------------------------------------------ ID | group | tochild ------------------------------------------ 1 A y 2 A n 3 B y 4 A y 5 A … |
| | I know it's possible, but I'm not sure how. I need several services to use one database. For instance, I need blogs,chat, and a forum to share a database so that when you sign up at one place, you are automatically signed up at all of them. |
| | Hi, got another problem. I have an interface that uses javascript to generate the Mysql WHERE condition of a query it posts to the a PHP page that retrieves values from the database. it works fine as usual on my local pc. but i when i uploaded it to my … |
| | I have two tables: [CODE] table1: ---------------------- id name member ---------------------- 1 user1 2 user2 3 user3 table2: ------------ id group 1 A 1 B 2 A [/CODE] Now I want to update table1 and set member field to "Y" if this userID belongs to table2, how should I write … |
| | |
| | Team of Web developers is looking for customers/partners for development of Web programs, regardless of task complexity. A wide experience in development enables us to develop different projects: we can fulfill simple tasks such as Web site development and up to the difficult one such as the development of complex … |
| | In database I have three tables: t1,t2,t3 all three tables contain the same field (username) t1(username) ------- user1 user2 user3 user4 user5 t2(username) ------- user3 user4 t3(username) ------- user2 Now how can I write SELECT statment to retrieve all username from table1(t1) which is NOT included in table2(t2) and table3(t3)? … |
| | Hi there, i have question on arranging columns whereby the datatype is date and time how should i arrange them so that the latest date & time entry will be in the first row? i have a table displaying records and these records' columns are retrieved from 3 different tables … |
| | hello everybody, i'm new to this forum. i've a small problem after migration process of my sql server sample database to mysql server. if anybody are aware of this problem please let me know the appropriate solution. i have downloaded the MySQL migration tool kit from the mirror site and …  |
| | Hello New here, so don't know if doing this right, I am getting an error message that goes like this: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/www/target/geo/index.php on line 48 (here is the line in question) $count_result = mysql_num_rows($result); Warning: mysql_num_rows(): supplied argument is … |
| | I have three tables. table1: |-------|-----------| | Name | Studyarea | |------|-----------| | Joe | 1 | | Joe | 2 | | Chris | 1 | | Mike | 3 | |-------|----------| table2: |-----------|-----------| | Studyarea | CourseID | |-----------|-----------| | 1 | 1,2 | | 2 | 2 … |
 | This could be a stupid question but I’ll ask it anyways. I used “MySQL Migration Toolkit 1.0 |
| | Hello friends Actually i need a small help. I have 2 enviornment with 2 different databases .one is development and one is testing. All development and design work is done in Development work and once in a week we take database dump from development to testing enviornment Actually the procedure … |
| | I have a MySQL database design which consists of several tables that are identical in structure, but contain different sets of data (each table is assigned to a specific group of people). This is because each table might grow to several tens of thousands entries, and with a prospect of … |
| | Hi, I am VERY new to SQL and I do not know if I am word this question correctly, so forgive me. I would like to create a new table that does calculations on some of the same fields. • IPA number (from the IPA_Num field) • Total number of … |
| | Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/mandarin/public_html/wyandotte/includes/flash_functions/events.php on line 7 I have no idea how to fix this. Here is the code I use <?php //calls on the database to display the results of my Events query. This will show us what's happening lately … |
| | Hi everybody Hope I will get some help here. I have been using mysql database for quite sometime and had no problem till now. This database is either upgraded nor any change in the indexing, its been as it was from past one year. But recently we have observed that … |
The End.