10,940 Topics

Member Avatar for
Member Avatar for silverfox

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 …

Member Avatar for hellangel
0
183
Member Avatar for michael123

I have three tables. table1: |-------|-----------| | Name | Studyarea | |------|-----------| | Joe | 1 | | Joe | 2 | | Chris | 1 | | Mike | 3 | |-------|----------| table2: |-----------|-----------| | Studyarea | CourseID | |-----------|-----------| | 1 | 1,2 | | 2 | 2 …

Member Avatar for chrisbliss18
0
113
Member Avatar for Walyer

This could be a stupid question but I’ll ask it anyways. I used “MySQL Migration Toolkit 1.0

Member Avatar for ujvala
0
244
Member Avatar for haria_kishore

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 …

Member Avatar for chrisbliss18
0
71
Member Avatar for mugash

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

0
81
Member Avatar for jaguarcy

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 …

0
89
Member Avatar for HasanaMonique

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 …

0
98
Member Avatar for MandarinMark

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 …

Member Avatar for Gary King
0
145
Member Avatar for cqd

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 …

Member Avatar for cqd
0
90
Member Avatar for DonutBanana

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). …

0
70
Member Avatar for escolta

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 …

Member Avatar for proghelper
0
121
Member Avatar for clem_c_rock

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, …

0
97
Member Avatar for ohgosh

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 …

Member Avatar for ohgosh
0
267
Member Avatar for Kennedy_f

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 …

Member Avatar for Troy
0
86
Member Avatar for server_crash

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?

Member Avatar for freesoft_2000
0
194
Member Avatar for nephish

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 …

Member Avatar for nephish
0
158
Member Avatar for ashneet

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 …

Member Avatar for ashneet
0
150
Member Avatar for aboyd

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 …

0
115
Member Avatar for Dark_Omen

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

Member Avatar for Dark_Omen
0
261
Member Avatar for SpittingSctsman

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 …

Member Avatar for SpittingSctsman
0
137
Member Avatar for klyau23

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 …

Member Avatar for klyau23
0
145
Member Avatar for madhusuri

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 …

Member Avatar for onewebsite
0
119
Member Avatar for Chagh

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 …

Member Avatar for filip_scm
0
345
Member Avatar for bgharper

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: …

Member Avatar for bgharper
0
147
Member Avatar for aparnesh

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. …

Member Avatar for aparnesh
0
127
Member Avatar for jbkielis

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 …

Member Avatar for Kate Albany
0
97
Member Avatar for chrisxkelley

I found this book extremely useful in learning and using php, mysql and apache together. it's great

Member Avatar for hollystyles
0
165
Member Avatar for jime0726

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 …

Member Avatar for techniner
0
171
Member Avatar for ashneet

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 …

Member Avatar for ashneet
0
125
Member Avatar for Koldar

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(), …

Member Avatar for Gary King
0
173

The End.