Database

Dear All Friends! I have create this topic for everyone who have some problem with query analyses.
You could post all your problem with database. We all would have and find a solution for you. Now
let me start my small problem. This i have fixed but i just think of the best way. I got 3 tables:
table_users ( user_id ,user_name,user_pass,user_group) table_group ( group_id ,group_name)
table_usersingroup ( ursingro_id , user_id , group_id ) I need output like this: username |
password | group test1 | ***** | (group1,group2,...

Please Help Me with this site's error http://gatewaybiz.x10hosting.com/surf/ ...

I'm learning php in class right now, but I'm still not that good at it, what I'm
wondering is when I write the php so that it can connect with a database, can I at the same time
have it that it is able to display back images that I choose. Like, I want a search feature, where
you can search for a keyword, and it will bring back a list of all the possible entries with that
keyword, but each of these entries will have a photo associated with it. Now, do I put these image
files directly into the database, or do I write the code to link them from my files to th...

I have installed XAMPP on my computer. Everything works fine, but when I enter PHPMyAdmin I get this
warning: "Your configuration file contains settings (root with no password) that correspond to the
default MySQL privileged account. Your MySQL server is running with this default, is open to
intrusion, and you really should fix this security hole." So I've changed the password to the
root account, but then I couldn't access the mysql databases anymore with PHPMyAdmin (I received
an error that the access was denied). I could change the structures only in php with ...

I found a nice program which allows you to put quizzes on your web site. You can design your own
questions, set the layout of your page, and there is also a possibility of having the results
emailed to you. It further offers a facility to store the results and all that, all you have to do
is put a link in the program, telling it which page takes care of that. However, when I look at the
HTML code the program generates, I see that most of it is written in Javascript. Obviously, it also
uses variable names, but as I don't know any Java, I was wondering if those variab...

After several tests, i think it's good enough to be released. Please report any problems in the
issues section at the project's page. (Follow the download link to go to the project's
page.) About the shoutbox: QUOTE It's supports many bbcodes that we're all used to.
Over 60 smileys. No database required for shout storage: All stored on flatfile. XHTML valid.
Installation is basically extract files, and chmod the files "shouts.log", "ipban.log",
"wordfilter.log" 666. Compatible with standard-compliant browsers, and Internet Explorer. Admin Cpa...

A SMALL INTRODUCTION TO DATABASE ============================= I have seen that many members have
problems with Database. Here is a small INFO which should give you the IDEA. mySQL is a DATABASE
server. You can access it using the link in Cpanel. Cpanel can be accessed by
"www.YOUR-SITE.com/Cpanel" There you have 4 Main Options :- 1> CREATE A DATABASE 2> CREATE A USER
3> ADD USER TO DATABASE 4> PHPMYADMIN CREATE : IT ALLOWS YOU TO CREATE A DATABASE CREATE USER
: IT ALLOWS YOU TO CREATE A USER. USING THIS, YOU CAN ACCESS THE DATABASE. A DATABASE CANNOT BE...

its the same as the cpanel password right?...

I tried restore a database as type : username_forumname.sql ! After restore , check in cpanel ,
feature mysql datase , I seen a new database is : username_usernameforumnamesql ! Have anything
wrong ?...

Hey all. Now i have a DB, an SQL DB, and i need to auto prune the data there to delete rows lder
than a certain time, lets say 2 months for now, the question is how do i do this? The obvious thing
is just to add a field which is the numerical representation of the month when the data is entered
and every time the DB is accessed it will check this number against the current month,in a numerical
format, and if the difference is two or greater that row is deleted, so if the month is January, it
would be O1 and if the current month is march then it would be O3 and the diff...

Hi I was wondering if anyone knows how to query a large SQL database from an Infopath Form? I am
able to connect to the SQL database from Infopath but it retrieves all the tables from SQL instead
of only connecting to SQL and retrieving the required information in the tables. I see there is an
option for a click function within a button but the code needs to be in C# , and I am only a
beginner with Delphi. Does anyone have some sample code that I could insert into this click
function to connect to my SQL database and retrieve the information from within multiple table...

hey....i have heard a lot about PHP and MySql, there are a lot of articles about it and every bit of
help is easily available...its a lot easier to set up PHP with MySql....but talking about VB...i
didn't get anything convincing... I know it can be done...if not as easy as Php. I have a
school project in which i have to connect VB application to a mysql database ...please tell me the
easiest way to do it... I have books which tell a lot about VB and oracle....about there
connectivity and database usage..but there is no mention of MySql...I think its not a popular ...

Hey im trying to add a file to my My SQL Database, Any idea how I can do this? Any help would be
appriciated. Thanks!...

First of all, to get the idea of what I am trying to achieve here, please have a look at my
idea thread, entitled Idea For Using A Cron Job To Grab Daily Travian Map.sql Updates . This gives
a prelude to the project, what it is for, what it is supposed to do, etc. Now, what I need is
specific advice on setting up the mySQL database(s) to implement this idea. There is a useful FAQ
file for how to make use of the map.sql data located on the help.travian.com website, which also
gives an example of the CREATE TABLE instruction that matches the data in the map.sql fi...

Hey gang, long time no see, my bad! Anyway, I got me a question. Does anybody know how to connect
to a remote oracle database using toad? When I read the docs for toad I get the impression that I
have to have a local oracle installation in order to use toad, but that just seems silly. I guess
I'm stuck at the point of trying to figure out how to tell toad where to look for all of the
configuration information it needs for the connection if I don't have any "Oracle Home"
directories. :crosses fingers: Peace!...

Question's in the title!...

hi all! this is my first post /biggrin.gif' border='0' style='vertical-align:middle'
alt='biggrin.gif' /> and i have a doubt, how much mysql space i am allowed to use... i mean how
much is available for my free account...

For those of you... who really reall Ok... I am sharing to trap17 an easy to use image file to
brush up your understanding of database normalization. Everytime I have to understand the concepts,
I have to go through the complete text and its a little hard to do that... Had some requirement
recently, and I thought I will prepare something like this and refer to, when there are future
requirements. This is not exhaustive and very detailed. Helps to get some basic understanding. Prior
knowledge about the databases, structure will help in understanding the complete concepts...

Hi, I'm running a website for our chess club. Recently we decided to add a feature for members
to simply enter their tourney results there but I do not exactly know how to do it. The first
problem is how to create form for people to enter their game results. I just have an idea that
working with drop down menus is faster, esaier and more precise than typing the information. The
second problem is how to make these results search-able? Let me tell you the final problem which is
the worst of all that is I do not know how to build a member area. Because Qupis does no...

well i'm getting an error message(a databass connection warning) for all of the parts of my site
that connects to a mysql database i check my database users pertmissions and i try to do the repair
database thing and it's still not woeking. am i the only person having this or is it an overall
trap17 issue and how do i fix it....

CODE Access denied for user 'skyed211_central'@'localhost' to database
'skyed211_centralgaming' I get this error message when trying to install my IPB. It will
not accept localhost, nor mysql. Can I get any help please? I've tried many times to get past
this part, but it's not happening /sad.gif" style="vertical-align:middle" emoid=":(" border="0"
alt="sad.gif" />...

i can not make a sql for diff srcipt, but the sricpt i have is php, DJ-cpanel.. all tho i can not
install it the error is like this Creating Database Tables No database selected there a mysql
database is made, but i can not use it for othere stuff... plz note that this is Free script and not
for paid.. is there a way that the myqsul can not use sql other scripts? or it maybe not working...
but i am not sure if the script not working or it can be the server may be down on mysql...? ...

Hi all, I am not sure if this is the right place to post but I'm sure you'll tell
me if it's not. My problem is this: I have a website where I sell books and it's one of
those simpleton sites where I don't need to know code, I just click icons etc Anyway, I can
upload images to the server and need to have them in different resolutions and link from a thumbnail
to the larger picture. What I am trying to say is I have about 6000 books to display on my
website which is impractical as it takes me about 10 mins to load 1 copy. What is the ...

This is the situation: I have a database where you can add bands ( theire albums, genre other
info) For the album part they can add for each album the songs. So what do i want: When i show
the results there only shoul display the bandname which should be a link to the more detailed info
like albums biography etc. How do I do that. Is there a name for this and are there any
tutorials. thx in advance...

I wonder if there is a problem with the PHPMyAdmin system again? When trying to get into it, I once
again get the following: QUOTE Warning: session_write_close() : SQLite: session write query
failed: database is full in /usr/local/cpanel/base/3rdparty/phpMyAdmin/index.php on line 42
Warning: session_write_close() : Failed to write session data (sqlite). Please verify that the
current setting of session.save_path is correct
(/var/cpanel/userhomes/cpanelphpmyadmin/sessions/phpsess.sdb) in
/usr/local/cpanel/base/3rdparty/phpMyAdmin/index.php on line 42 Warning: Ca...

I host a Forum on my Trap17 Account, and it went down last month during the DB issue, and it came
back as the Accounts got sorted out, however, these last three days, it has been up and down at
apparently random intervals. It was fine last evening, but is down again this morning and tonight.
Any information? or suggestions?...

Hi, I'm trying to build an online game and figured the easiest way to do the server list would
be to make a mySQL database for it; however, I use the con() command on the IP i get from pinging my
website and I always get an abnormal program termination; however, it will work with the mySQL on my
own machine. The code is below: CODE #include #include #include #include "pass.h"//holds
my password (i program at school) int main(void) {     Connection
con("t3jem3_test","64.69.46.210","t3jem3_t3jem",pass);     Query query = con.query();     query
    Re...

I wanna know how to manage the database for website of e-books with forum in it, n the database is
in mysql. PLZ HELP ME!...