10,940 Topics
 | |
| | 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: … |
| | 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  |
| | 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(), … |
The End.