10,946 Topics
 | |
| | 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 … |
| | i have made a script that adds to a tabel in mysql, one problem is, even though it echos that it worked. it doesnt add them :( [php] <?php $dbhost = 'localhost'; $dbuser = 'tezzana_cams'; $dbpass = '**********'; $conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql'); echo … |
| | 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, I have a Windows 2003 server running Plesk 7.5.5 Recently MySQL is shutting itself down and I really dont know why it would be doing this. I restart the server and it runs again but I get one of those Microsoft reports asking if I want to send it … |
| | I was wondering if any of you knew of any optimization techniques? Or any other sly tricks to help lay off constantly using the database.... A friend wants me to help design a high-traffic forum site (for her organization) and the only thing I can come up with is precaching …  |
| | is there an site for asp mysql tutorials.using mysql database with php is very eazy but i am having problem with asp.which database comnly used with asp.i hope sombody help me in learning asp  |
| | Hey people, hoping to find some answers here to a problem I'm stuck with. :sad: I have recently installed Windows server 2003 onto a machine and are trying to get a phpbb forum set up. I installed apache and the webserver is all working perfectly without any issues. THIS IS …  |
| | i m getting the error as Error Type: Microsoft VBScript compilation (0x800A0401) Expected end of statement /myweb/updat.asp, line 18, column 181 my code is <% if session("bvuser")="true" then struser=request("usercode") stremail=request("email") strfname=request("fname") strlname=request("lname") straddress=request("address") straddress1=request("address2") straddress2=request("address3") strcity=request("city") strcountry=request("country") strpassword=request("password") struser=session("usercode") dim rsupdat,Conn,sql Set Conn = Server.CreateObject("ADODB.Connection") Conn.Open "Driver={MySql ODBC 3.51 Driver}; … |
| | hi really this issue is troubling: I exported the database structure using the phpmyadmin as harry.sql from my local system.now I went to company server/cpanel /mysql database.created a user with username and password. I would like to import this file and I tried the same way that I used to … |
 | 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. |
| | Hello, I created this page. it contains textareas and checkboxes. when user enters information or check any of the checkboxes. this translates to a conditioned query.i achieve this using javascript. u can find the url @ [url]www.laterallinks.com\search.htm[/url] try entering gibberish and any of the fields and click on the fetch …  |
| | 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 … |
| | 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 … |
| | |
| | heres the complete error that i am getting. You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'A (A) )' at line 1 does anyone else get these errors at all? [php]<?php $host = … |
| | 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 … |
| | Am using nokia Internet toolkit 4.0 and phpdev4.3 I am getting this error;WML Encoder:Root element not declared. Can somebody please help me. Thank you in advance |
| | 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 … |
| | Hello, So I want to have an online store. Well, so far, I purchased a MySQL hosting service with Yahoo, and a perl shopping cart software with [url]www.upowershop.com[/url]. I had the cart installed, but it came with a pretty bad template ([url]http://www.chicago-bm.com/cgi-bin/cart/cp-app.cgi)[/url], so I purchased another one (which I attached). … |
| | have a ver big problem, im new to mysql...and i been thinking of ways of solving it....but dont know how.... i have an excel list with 200 people, so what i do is convert the excel file to mysql, using a $24.90 sofware.....once i have the mysql databse i add … |
| | Hello, I'm having a problem w/ the LIMIT clause when I'm using this CASE statement. This is working like a dream: SELECT * FROM table ORDER BY CASE table_id WHEN 54 THEN 0 ELSE 1 END, table_id LIMIT 50 Only problem is I would like to do a limit start, … |
| | i wud like to select records which userStatus' values is sth. ive gt a tbl with a userStatus column, dis column is stored with statusID and the values in dis column, userStatus, are either numbers or nothing inside. now i wud like to retrieve the userStatus which values are sth … |
| | I found the test 70-228 to contain a wide variety as far as question difficulty. About 1/3 of them were very easy, about 10 (of the 45) questions were quite hard and had me second guessing myself a little, and the rest fell somewhere in between. I passed on my … |
| | Take this situation: A Hospital Database containing information on over 800 employees. Which database software would you use? Is Access just as good as mysql? |
| | Hey there, i have a table in MySQL that is updated about every 5 minutes with about a hundred new records. For an application i am building, i only need the info from the most recent entry for each specific unit. But, i need all of the info in that … |
| | This sql command is for PHP but this is what happen to it after php had made chenges: [CODE]UPDATE Catalog SET Table='Harrow_VH' WHERE Name='Variable Action Harrow'[/CODE] I get this error both places php and mysql client it self: MySQL said: You have an error in your SQL syntax near 'TABLE … |
 | I work with a server admin. He created an account on MySQL and it works just fine. I created another account to access a different database, but it will not work. Can anyone tell me why? I've done "FLUSH PRIVILEGES" about a million times now. Here is the MySQL user … |
| | Hello everyone, I am new to mySQL. I want to know how to use mySQL with c#, and if there is any difference between MS SQL and mySQL. Also any links to tutorials would be great. Thanks |
| | Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in _____________________________________________________ I have seen a lot of this around the internet lately, both in forums and on some production websites (WHOOPS!) :cheesy: I am currently developing a small site which uses MySQL as it's data repository, and I … |
| | Hi All, Wondering on how to convert excel spreadsheet to MYSQL database easily without incurring any cost? Visit this web site [url]http://excel2mysql.f2g.net[/url] for a tutorial. By following simple and intuitive steps, you will be able to get a mysql database. But, get a free copy of phpMyadmin from the internet … |
| | Hi, Iam a MySQL user and Iam currently having some error messages in my code.I use TYPO3 as the frontend. I get these 2 warning messages [COLOR=DarkRed]Warning: Supplied argument is not a valid MySQL result resource in /var/www/typo3/lib/t3lib/class.t3lib_db.php on line 677 Warning: Cannot add header information - headers already sent … |
| | hi all, i want to migrate from SQLSerevr 2000 to MySQL 5.0.4. i've got a column type varchar(8000) in my source db. the reason of selecting varchar(8000) instead of text type is: we can't compare two text fields in SQLserver and i need to compare them some times. i don't … |
| | I'd like to suppress MySQL errors being printed in the header, so that errors can be passed back into the PHP page... My current code is as follows: [PHP]if ( ! mysql_connect($server, $database_username, $database_password) ) { $error = "There was error when attempting to connect to the specified database server: … |
The End.