10,938 Topics
 | |
| | I am tring to import a database from another server that is 10gb in size the database came to me as 10 files xaa xab xac xad etc. I ran a command to dump the 10 files to 1 10gb file mydatabase.sql When I first tried to import via command … |
| | So I'm using Mysql to make a text-to-speech engine. Basically any given phrase by the database is returned to my script, which has to say every word and number, if any, by way of voice . For the voices I'm using Asterisk, but that's another problem of my own lol …  |
| | Hello everybody. I'd like some help with a query. I have a database named 'base1' which contains many tables. Some of the tables have names like 'track1' , 'track2' etc... which have identical columns. I would like to select all the tables beginning with track and show the data of … |
| | [code] <?php session_cache_limiter('private,must-revalidate'); session_start(); require_once("config.php"); include ("classes/db_functions.php"); include ("classes/display.php"); $dbf=new db_functions(SM_DB_HOST,SM_DB_USER,SM_DB_PASS,SM_DB_NAME); ?> <link href="style/report.css" rel="stylesheet" type="text/css" /> <?php if (@$_POST['Submit']=="Save Report") { $sql = "select * from customreport order by id desc"; $linkID=mysql_connect(SM_DB_HOST,SM_DB_USER,SM_DB_PASS); mysql_select_db(SM_DB_NAME, $linkID); $result = mysql_query($sql)or die(mysql_error()); $nume = mysql_num_rows($result); $row=mysql_fetch_array($result); if (!empty($nume)) $nume = $row['id'] + 1; …  |
| | I am having trouble with a page where i need to insert data into a SQL field. It comes up with this error 7 times: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in / i would post the actual php page but its over 1000 lines … |
| | Hi guys, Hope i'm putting this in the right place. Apologies if i'm not! I'm making a website for a sports suppliments supplier. I'm having some trouble with how to layout the database. I have a navigation menu which has all the categories listed. But some of my products are … |
| | How can I do a constraint/trigger to check a value from another table for example CHECK tblAcademic.role = 1 and [currentable].post = 1 Please help |
| | Hi All! I'm setting up a very small DB to be used for customer based product reviews. There are two tables: [code]product_tbl: id int unsigned auto_increment reviews int unsigned // number of times product reviewed product varchar(45) [/code] [code]review_tbl: id unsigned int product_id int unsigned // id from product_tbl price … |
| | I am trying to create a trigger that updates one field in a table different from the one being updated/inserted. My create trigger code looks like this: [code]CREATE TRIGGER before_insert_ddsw BEFORE INSERT ON `ddsw` FOR EACH ROW SET products.count - products.count +1; [/code] When I try to create this I … |
| | Hi all. I've been making a site for my gymnastics group. I've got some background on both programming, mysql and PHP, mainly from university classes. However, all the projects where done in localhost, and now that I'm getting in the "real world" I'm having a few problems... The two main … |
| | I have a database in which my parent_id same for many rows. So I wanted to write a code which groups all similar images in a paragraph. How can I do this. |
| | Hi, When i try to restore a database, I get this error [CODE] ubuntu@ubuntu:~$ mysql -u root Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 44 Server version: 5.0.75-0ubuntu10.2 (Ubuntu) Type 'help;' or '\h' for help. Type '\c' to clear the buffer. … |
| | 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 … |
The End.