10,946 Topics
 | |
| | first of all i'm a newbie to databases and particularly mysql. i downloaded and installled mysql community server and mysql gui tools. now i want to create a local database and access it through mysql gui tools. please, give me detailed guide for it. |
| | Hi all, Am having trouble trying to retrieve records using the following SQL statement: [code=SQL] SELECT distinct(dbS.tCline.mobile),dbS.tCline.msg,dbS.tCline.dest, dbS.tCline.reply,dbS.tCline.status FROM dbS.tCline,dbLaw.FORMER_GREY where dbS.tCline.msg LIKE '%'||dbLaw.FORMER_GREY.C||'%' and dbS.tCline.msg like '%ADMISSION%' [/code] My problem now is that, the resultset retrieved includes everything from dbLaw.FORMER_GREY.C instead of only those rows that match dbS.tCline.msg rows.Please … |
| | Hello to everyone, I'm new here - Great forum. I would like to update an entire database at once. I use Mysql database and PhP scripts. I explain : I have to update prices in one column of the DB by puting +10% This is what I have but it … |
| | Hi there everyone, Im looking for a solution regarding a project im involved with which needs to run a script that search's between dates. Im running a table like this example: ID - date_begin - date_end - price 1 01-01-2009 31-01-2009 1€ 2 01-02-2009 14-02-2009 2€ 3 15-02-2009 27-03-2009 3€ …  |
| | User fills out a web form containing about a dozen or so combo boxes. As each comboBox has its options filled from values contained in a database, this limits what the user can input. However, as we know this can be bypassed, hence the need for validation even on a … |
 | I am not a database person by far. I know how to efficiently use MS Access. I posted a topic earlier in the design forum and received good responses that have led me to want to use MySQL. The database I want will eventually be fairly expansive. To start with … |
| | Hi, I am facing a problem when i am trying to run the django server using python manage.py runserver.The problem is that the server is not starting because it gives the following error: Traceback (most recent call last): File "manage.py", line 12, in <module> execute_manager(settings) File "/usr/local/lib/python2.5/site-packages/django/core/management/__init__.py", line 340, in … |
| | Hello, I am having trouble converting my "MySQL" statement to a prepared statement. here is the part of the code that i need help with. How Do I make below statement a prepared statement and can actually read the result afterwards. this way everything works perfectly, except that its not … |
 | Hi all, Im new to php with mysql, i have connected sucessfuly to my database, But how do i go about creating a register script and login script? I already have 10 page website created by me in html/php But now i want to add a members area i have …  |
| | I created code for my TV guide web site, as mentioned in a previous thread ([url]http://www.daniweb.com/forums/thread247517.html[/url]). I solved the problem, in the code below. This is the new code, which works well: [CODE] <? //connect to mysql //change user and password to your mySQL name and password mysql_connect("localhost","root","PASSWORD"); //select which … |
| | hi all, Im desperatly looking for a .db format rhyming dictionary and have managed to get hold of three database files which I think will be VERY useful to me but I cannot open them. Can anybody help me to get them open? I have attached the files in a … |
| | I want to use MySQLDB to connect MySQL but I got a problem. the problem is: --------------------------------------------------------------------------------- cs6201:/home/lamwaiman/python/data # python dm.py Traceback (most recent call last): File "dm.py", line 11, in <module> import MySQLdb File "build/bdist.linux-i686/egg/MySQLdb/__init__.py", line 19, in <module> File "build/bdist.linux-i686/egg/_mysql.py", line 7, in <module> File "build/bdist.linux-i686/egg/_mysql.py", line 6, …  |
 | i have a website for properties (rent, sell, etc), using php and mysql. i allow the admin to manage existing properties by selecting the property id from a dropdown that lists all properties ids from the database, or by directly entering the property id in a textbox and submitting a … |
| | Hello all. im new to mySQL database so dont know very much so sorry if its a daft question. I have a mySQL database with a company called 5quidhosting but my hosting is with heart internet. Can i get a web page hosted with heart to access the database on … |
| | HI Guys I have an issue, I would like to know if anyone can suggest how I can achieve what I want. I have two tables, a user table and a media table. The media table has a FK, User_id , referenced to User.User_id. Table structure User: user_id username password …  |
| | need tutorial how to display multiple tables from database. i have table (price) that holds various pricing data related to table (acc_establishments). how do i link tables together to display data (price) that corresponds to (acc_establishments). need a simple example how to do this. thanks  |
| | i am trying to run this code but i am not getting anything from the mysql_fetch_assoc($result) it is just blank can anyone help me thanks in advance [CODE]<html> <body> <?php $host="localhost"; // Host name $username="root"; // Mysql username $password="hayden"; // Mysql password $db_name="ecng3020"; // Database name $tbl_name="students"; // Table name … |
| | I have a query that looks good to me but MySQL does not agree. I am using the DATE_FORMAT function and I do not see what is incorrect so I am hoping some one can point it out. [code] SELECT title, DATE_FORMAT(event_date '%Y-%c-%e') AS event_date FROM event WHERE event_date LIKE … |
| | Hi, Is it possible to put 2 where closes in your mysql select query. I need it because some people appear to be available twice, so I need to add from which team I want the information, so I need a where for the name and a where for team. … |
| | i asked some one a question about the databasei am using and this is the answers i got.. Apache needs write permission for /home/httpd/vhosts/knowittv.com/mason Just set it up and you should be good to go. i dont understand what this means or how to do that... any thoughts? |
| | So the following command is working great for me but I want to pull and parse data twice in one query with the sustring command. I have a good bit of syslog data being dumped into one field and I need to run multiple substring commands to print it correctly. … |
| | Hi Everybody, I am writing a simple program which connect MySQL reads each line of a table content and writing to an Excel file line by line. I want the procedure start onClick of a start button. I am quite new to c# and NOT good with the classes etc. … |
| | Hi all, I would like to learn how I can read a MySQL table and move the records to an Excel file. While replying, please consider that I am at the very beginning of c# and write everything "Idiot proof" Thanks telmessos |
| | What is the best way to create a banner ad in .gif or .png from information in database? I just want to display how many members or or info enter from a user on the ad. Is this a fairly simple this to do? |
| | i am using APACHE 2.0.55 web server i have configured apache and php ( i get the phpinfo() page correct) altough after installing apache i do not get the 'http:\\localhost' page i have installed mysql_administrator1.1.9 and mysql-essential-4.1.12 on my PC. i have uncommented 'php_mysql.dll' in php.ini after restarting apache server … |
| | I am going to use the LOAD DATA INFILE from PHP to allow users to bring a csv file into the database. I need to add an userId field to the stuff going into the database that's not in the csv file, is there any way I can just add … |
| | Hi, I'm new to PHP.If i execute this code. It shows the warning as "Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in c:\wamp\www\login_action.php on line 15 Name Address Telephone company" I don't know how to solve this.[code]<?php include 'connection.php'; $uname = $_REQUEST['uname'];//extract($_POST); $uname $pword = $_REQUEST['pword']; … |
| | Its a scenario of message and the reply post for articles and the posted messages are stored in the database. This message as a parameter is passed to the script (lets call is 'insert.php') doing this insertion is called from the js function onclick of the submit. Inside this 'insert.php', … |
| | I m working on a MLM project in which i have to store member automatically in binary tree form like 1 is root 2 is child of 1 3 is child of 1 Then 4 is child of 2 5 is child of 2 6 is child of 3 7 … |
| | Hi everyone, Im pretty new here. Also realy new to PHP and MySql. In my current company they separate the html, php, css, classes codes to different different files. I just want to know, how to create a checkbox list that are create based on datas from database. Basically its … |
| | Hi folks, I have a mysql database and I have written some PHP to view records, add records, delete records and update records. The problem I have is updating checkbox fields of a record. Everyhting was working fine and updating correctly. Then I tried to automatically populate the form fields … |
| | Hello everyone I am quite new here and have a very tricky issue that bothers since days. I posted the question on the PHP forum together with a sample of my embarrassing code. If this is wrong that I raise the issue here in MySQL forum, too, please forgive me, … |
| | I'm using mysql database..I have forms setup main form has datagrid..you can add to this datagrid and save to datbase with my add form and it works fine. I can delete from the datagrid and it works fine...when I select an account to edit is when I have my issue...form … |
| | what is the code  |
| | Today went to use GD within PHP and a simple check of phpinfo() showed it wasn't installed, but running php -m show that both (pdo_mysql and gd) where installed. Does anyone know how to sort this? [INDENT] [CODE] - PHP Modules ctype curl date dom exif filter ftp gd <-- … |
| | i am trying to use a flatfile database just for a basic webpage. i have no mySQL and need a login file to keep certaian things private from guests, and to also have members view a personal page each time they login. i have been trying to use this code …  |
| | Okay, I am creating a simple forum for my Grade 12 Summative Project, and am having a hard time searching the forum. I have two tables which i would like to search, setup like so: table1 --------- post_id - AI primary poster_username post_subject post_text post_time - stored as time() would … |
| | Just posted this in the PHP forum, but thought it was the wrong place: [URL="http://www.daniweb.com/forums/post1092005.html#post1092005"]pdo_mysql and gd recognised/enabled in terminal but not on phpinfo()[/URL] which is basically: I've got GD and pdo-mysql enabled on my version on php (ran php -m to check and they are both there) but when … |
| | Hi guys, I'm a newbie in Visual Basic and I need some assistance. I have 2 tables in mysql: 1. stats (stats_id,statsno,statsName) 2.stats_det (stats_det_ID,stats_id,stat_DateAdd,stat_UserAdd,stat_DateModif,stat_UserModif) I have a form named status and from here I want to add a new record in the first table (stats). I've created the insert statement … |
| | Hi all I'm trying to make up records of publications, in the following format: [author1] [author2] [author3] [title] [journal] So I've created 3 tables: [B]Papers[/B] paper_id (PK) title journal [B]Authors[/B] author_id (PK) surname [B]Paper_Author[/B] paper_id (PK) author_id (PK) rank When I run the query [CODE]SELECT surname, title, journal FROM authors … |
| | Its a Request. I have been told from my work that I have to learn using asp with mysql to do certain task straight away, but I have no idea how to start, where to start and what to download, to do the application. I have bit knowledge about java, … |
 | I'm trying to do a delete on two tables at once. sucessfully does it with update, [code] UPDATE table1 INNER JOIN table2 ON table2.table1_id = table1.ID SET table1.whatever = Whatever, table2.whateveer = Whatever [/code] is there a way to do this with the DELETE function [code] DELETE table1 INNER JOIN … |
| | Hello, I am currenty using MySQL 5.1 community server and trying to import the data of the comma delimited text file into the table using python 2.6 scripts. I have installed Mysqldb 1.2.2. follwoing is my script: [CODE] import MySQLdb, csv, sys conn = MySQLdb.connect (host = "localhost",user = "usr", … |
| | Hi, i want to know if asp can detect connection to MySQL Server. i have hosting (not dedicated server) but sometimes my website have error like this : "[MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on '<MySQL SERVER place>' (10061) can someone help me for some asp code to redirect … |
| | Hi everyone. I am putting together a site made out of 2 scripts, with users. So i wonder what's the difference betwen merge or syncronize mysql DB ? The 2 scripts have info about the members , they will act as one site so i need the users info to … |
| | I need some help with this small php search script, I have a small HTML form... [CODE] <form action="search.php" method="post"> <input type="text" name="search"><br> <input type="submit" value="Search"> </form>[/CODE] What they will do is enter a username and what I am trying to get is information based on that username displayed in … |
| | hi.. i am newbie on learning web dev and still find the best resource for my study .. can anybody give a mysql manual that contains all mysql syntax and the syntax usability :) thanks all, please reply |
| | Hi Everyone I'm hoping someone could help me out please. I have a database of names and email addreses with the following columns: user_id (auto increments) user_name user_email user_email_sent Basically I have a form (for myself) that returns all the rows in the database and next to each row I … |
| | I use wamp as my server. I used mysql-connector-java-5.1.5-bin.jar It worked ok/ But I set up same in another computer it gives an error saying ([I]In Jcreator[/I]) [B]Error: Error reading C:/Program Files/java.../ mysql-connector-java-5.1.5-bin.jar ; Error in opening zip file[/B] What is this error & what can I do? Plz help. … |
| | Hi folks, I'm wanting to add tables to my current database that will be based on a CRM idea but tailored to my specific needs. Are there tutorials or places I can look online that go into building database structures for different needs? I'm a newbie, so some of the … |
The End.