10,938 Topics
 | |
| | [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. |
| |
The End.