10,946 Topics
 | |
| | 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] |
| | |
| | Ok, so i created a db, with the help of the MYSQL manual ;) and think i'm on the right track (well, i'm on a track at least). this db is for our members area (car club web site). I put 3 tables in there users auto_info auto_mods all 3 … |
| | Hi folks...... I'm a bit new to this... played with DB's on an off for years...... now getting back to programming and web design, learning to play with all the big boy's toys etc. LOL Yet I must admit that I have fallen for the simplicity of access's ability to … |
| | I would like to create a deployment project for my application. And my application need mysql as database, my deployment package will package the mysql installation. How to use VB.net to check whether mysql had been installed in the client PC and if not install, mysql installation will be initiated … |
| | I have a general user account which has all of thr rights and priveleges that I wan all of my users to have. Is there an easy way to copy this account to create new users with the same priveleges? Thanks, Chester  |
| | Hi MySQL Boffs, I have been given resposibility to adminster our my company's website. We use a Content Management System. I would like to add abilities to it such as a Meta Tag & Title field for new pages I create I have started self-teaching myself PHP & MySQL on … |
| | hello everyone.. i'm a newby in mysql but i'm trying hard. So i won't lose a minute, and i'll go straight into the heart of the problem. I have the following mysql dumps: DROP TABLE IF EXISTS location_tree; CREATE TABLE location_tree ( id int(11) NOT NULL auto_increment, pid int(11) NOT … |
| | Is there a way I could create a variable that belongs to a table much like a static variable belongs to a class? So it "thing=1, person=2" were variables belonging to the table structure (not each row), then I could do something like this: SELECT * FROM table WHERE type … |
| | Hallo, ich möchte in einer Tabelle die Zahlen einer Spalte nach Grösse sortieren. Das Problem ist, dass das die Zahlen aus bestimmten Gründen Kommazahlen sind, also z.B. 1,3 45,3 etc. Kann mir jemand sagen wie das möglich ist? Ich habe leider nicht so viel Erfahrung in mysql..... Grüsse Kathrina |
| | I am looking to setup a site that searches inventory. Something like AutoTrader (as far as the searching goes). Basically just enter vehicle make, year, etc and the results appear. What language would I write this in? As you already guessed I know nothing about databases, can someone give me … |
| | I have a dual xeon 2.4 with 2gb ram. My repair has been going for over 14 hours now. Is this normal? It's the post table from vB, so there is lots of data. if it is normal, how much longer do I have to wait? this real sucks. :mad: … |
| | Hello please help Total php beginner please help i am going crazy my home-page opens finishes loading but with error's on page and my hitcounter does not display on my site but it's still logging my site I looked through my site files and found this error below. Is this … |
| | I am getting the following error: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/champion/public_html/search.php on line 34 when doing a search for text in a description or product name. The error only happens when I do a search for multiple words. Here is the code: … |
| | Hello, I am trying to set up the phpbb forums on my site using MySql and I don't understand how to link MY site to the DATABASE. I also can't seem to figure out where my username, password, and the name of my database as I need them for the …  |
 | Hi there all, I'm about to develop a site with a DB backend & I want to know how one goes about doing organic SEO if most of the site is DB driven. There will be some text on the page, but certain things that are pulled from the DB, …  |
| | i want to generate a unique primary key, something similar to the auto increment feature, but i do not want it to be auto increment. The reasoning for this is: this table will have rows deleted by the hundreds every day, and maybe even thousands in a few years (I … |
| | Hi guys, can anybody help, plase. Is there an instrument to manage .edb file (as far as i know Oracle's Enterprise DB but under free licence)? |
| | please help me when i run my code by using Mysql_num_rows() Warning: Supplied argument is not a valid MySQL result resource in c:\inetpub\wwwroot\php\connect to database.php on line 13 this is my code <?php /* declar some relevant variables */ $Host = "localhost"; //location of mySQL on server $Table = "books"; … |
| | Okay, I have been working with MySql for quite a while on Windows and can generally do what I need. I use Navicat to do a lot of the work because it is a lot faster than working it from a prompt. Anyway, I got permission to set up a … |
| | Hi guys, Sorry to make my first post so elaborate, I hope to provide help to others soon... :lol: I'm looking at co-locating a web server, the purpose of which will be to host as many small scale websites as possible. Unfortunetely, I have very little knowledge of webserver hardware … |
| | This is going to sound crazy - but is there any way to to a search for a phrase of text within my SQL database? (I am obviously not very knowledgeable) except on how to get there! :) Thanks for the help! |
| | i have one table,which maintain daily transactions for each minitute,but i would like to know per day for each 15 minutes interval how many rows are entering into that table |
| | Hi, How can I delete from multiple tables? I'm using this query and its not working: "DELETE FROM table1,table2 WHERE $localTime > table1.Time OR $localTime > table2.Time"; What I hope to achieve is deleting rows from table1 and table2 where their Time Field is less than $localTime. Thanks very much. |
| | |
| | I am completely new to phpMyAdmin and relatively new to MySQL, so this may be a dumb question. Please forgive me if it is. I have MySQL running successfully, no problems that I am aware of. I have IIS running on the same server with PHP installed and am successfully … |
| | I am a student and am developing my knowledge of MySQL and am practicing using it as a backend for some of my apps. I can run MySql on my laptop (Windows XP Pro) and use my apps referring to the local host. We have a wireless network in our … |
| | Hey, I am having a really stupid yet annoying problem. I have a simple database stracture (I'll give an example below) and I want to do a query that will loop through it's elements trying to display the list amount of times each element (trying to make it the most … |
| | I have a form that should write to MyDQL Database but isn't I have been looking at it for hours and it is driving me crazy. [CODE]$sqlquery = "INSERT INTO $table VALUES '$id','$Name','$DoB_Day','$DoB_Month','$DoB_Year','$Address_1','$Address2','$Town','$Postcode','$Telephone','$Mobile','$Email','$6th_Form','$6th_Form_Year','$6th_Form_Institution','$6th_Form_Course_Title','$College','$College_Year','$College_Name','$College_Course','$E2E','$E2E_Provider','$Apprenticeship','$Apprenticeship_Level','$App_Employer_Name','$App_Work_Area','$Employment','$Employment_Basis','$Emp_Employer_Name','$Emp_Job_Title','$Emp_Training','$University','$University_Name','$Uni_Course_Title','$Gap_Year','$Unemployed','$Other')";[/CODE] I have used this method before and it worked fine but it just isn't playing nicely today. … |
| | I bought a book called PHP/MySQL Programming for the absolute beginner by Andy Harris, Premier Press. This book is great for a beginner. It walks you through a refresher on HTML and then goes step by step into PHP and MySQL. Great examples and VERY challenging "homework" assignments. Great for … |
 | When attempting to compile PHP 5.0.4 with MySQL 4.0, I received some strange errors from attempting to use --with-mysql and --with-mysqli. After getting it to configure correctly, where it finds mysql and mysqli support, when I run make I get these odd compile errors: == /usr/src/php-5.0.4/ext/mysqli/php_mysqli.h:48: error: syntax error before … |
| | I am doing an SQL statement that tries to get the [B]percentage[/B]..but i dont know how to do it in MySQL here is the sample of my code: SELECT count( * ) , rating, percentage.... FROM `acne_prod_rating` WHERE prod_id =5 GROUP BY rating the output should be like this: count(*) … |
| | I have a link per customer for mrtg graph and remote reboot access. I need to be able to integrate the login to be password protected, connected to ModernBill database where the client can use their MB login info to access the mrtg / remote reboot page as well. How … |
| | Hi. I want to escape any special characters in the input field before inserting the data into mysql tables in C++. Here is how I am using this function [QUOTE]// Escaping special characters in the Subject field char * S = new char[strlen(m_headerSubject.c_str())*3 +1]; mysql_real_escape_string(conn, S, m_headerSubject.c_str(), m_headerSubject.length()); m_headerSubject = … |
| | Please, please, help me out in rewriting my sub-query to some kind of JOIN for earlier MySQL version: The query should retrive any availble rooms from the database MY ATTEMPTED SUB-QUERY: Select * From Room R Where R.room_no NOT IN( Select B.room_no From R.room_no = B.room_no And R.room_type = ‘single’ … |
| | I installed PHPDev5 and can run my php files no problem on localhost. However, since I'm the only who can seem them, I wanted to setup IIS so that my site could be seen by others on the internet. (until i move to an actual dedicated server) I believe the …  |
| | MySQL Experts, I have a UBBThreads forum that uses MySQL for the database. Recently a user's posts were accidentally deleted. We have a backup of the database but unfortunately it's quite old. We urgently need someone who is versed in MySQL operations and preferably is also familiar with UBBThreads to … |
The End.