10,932 Topics
![]() | |
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(), … | |
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.