11,093 Topics
 | |
| | 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 … |
| | |
 | Here's a thread I posted on previous forum regarding the three: I've used PHP, ASP, and ColdFusion, and out of the three, ColdFusion is probably the most fun to play with. Of course, this is a very biased question to begin with. If you ask a C++ programmer what the … |
| | 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 … |
| | Not sure if it's a virus or a problem with my disk, but it does sound similar to some previous problems in the forum (no desktop, no start menu, explorer and iexplore wont load) I can run programs via task mananger / run and cmd, etc, disk doe churn quite … |
| | 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 … |
| | Hi friends, I have very little knowledge of JOINs. Please, help me out in rewriting my sub-query to some kind of JOIN for earlier MySQL version TABLES IN MY DATABASE: Room (room_ no, room_ type, price) Guest (guest_ no, Fname, Sname, address) Booking (room_no, guest_no, Fname, Sname, arrival_date, departure_date, emp_no, … |
| | 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: … |
| | Hi When I am trying to connect to mySQL from PHP, I am getting the error "Client does not support authentication protocol requested by server; consider upgrading mySQL client" . I am using PHP 4, mySQL 4.1 and Win XP Pro. The error is occuring both for Apache & IIS. … |
| | Hello everyone. Thanks in advance for any help. I have two tables, a groups table and a members table. The groups table contains the main groups, such as group1, group2, group3. [B] id | name | description[/B] The members table contains user''s ids and the group id. [B]id | userid … |
| | I found this book extremely useful in learning and using php, mysql and apache together. it's great  |
| | Hi. A virus appeared on my computer a few days ago and I've not been able to get rid of it, yet. In fact, I think it's expanded and let in a lot of other viruses, dyfuca and elite toolbar among them. AVG, Adware and Spybot Search and Destroy all …  |
| | hey all, i've worked with sql server 2000 before and configured the odbc driver to connect to it, using tcp/ip, named pipes, sql admin (sa), and so on....now we're starting to get involved with mysql and are trying to configure myodbc to talk to mysql so queries and tables and … |
| | Hi all First thing is that i am new to php and i could get stuck on one semicolen. OK here is the code that i have problem with and the problem is that results given to both the query are same for some reason and i cant figure it … |
| | Hi there, I was trying to get a script working that will fire me an email when my database cannot be connected to. This is what I have and I'm wondering if it looks right to you php experts. :) $conn = mysql_connect ($server,$user,$pass) or die(mail("$SendToEmail", "$yoursubject", $emailtext . mysql_error(), … |
| | Hi all. I am having a problem I've not encountered before. When using mysql_fetch_assoc() in while(), I am getting the following error: [INDENT][B]Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in archives.php on line 81[/B][/INDENT] However, when taking it out of the while(), it works fine. The … |
 | I am pretty good with mysql but I haven’t done much full text searching. I have this problem though with getting results. I learned how to do the fulltext searching at the mysql.com site. I plugged their exact example into my database with phpmyadmin and everything good. Then when I … |
| | [CODE]#!bin/bash mysql -u user --password=password << eof use mydatabase; SELECT version FROM versions WHERE versionid = 'LIST'; eof[/CODE] I'd like to get the value from the query into a variable. Any ideas how I could do that? |
 | i got this message plz help :: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/baje/public_html/Templates Management/index.php on line 17 Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/baje/public_html/Templates Management/index.php on line 19 its like this plz point out session_start(); include_once('common/common.php'); // … |
| | Hello, I'm running 3.25.54 on a linux RedHat server. Here is my scenario and what I'd like to do. I have two databases d1 d2 d1 has some tables in it that I want to be in d2 instead of being in d1. My task is to get some of … |
 | Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/user/public_html/im2db/image.php on line 14 This is the error I am getting Here is the code: Image.php Am I supposed to add a exit(); after $result = mysql_query ($sql, $conn); line? [PHP]<?php // database connection $conn = mysql_connect("localhost", "user", … |
| | Hey there all, i have a question about how to point my python install to my sql database. when i enter this:[CODE] db = MySQLdb.connect(user="user", passwd="pass", db="myDB")[/CODE] i get this: [CODE]Traceback (most recent call last): File "<pyshell#1>", line 1, in -toplevel- db = MySQLdb.connect(user="user", passwd="pass", db="MyDB") File "/usr/lib/python2.4/site-packages/MySQLdb/__init__.py", line 66, … |
| | How can i display result of a single cell query? my query is [code]$author=$_POST["authorname"]; $q="Select authorid from authors where AuthorName=$author"; $resultauthor=mysql_query($q,$connect); $num=mysql_num_fields($resultauthor); [B]<<Error coming here![/B] :( mysql_num_fields(): supplied argument is not a valid MySQL result resource in[/code] |
| |
The End.