11,093 Topics
 | |
| | Dear all, I get the following problem: My users register on my website and enter a date of birth into the database (Mysql, DATETIME field). Now I would like to create a query that shows the upcoming birthdays within X days. For example: name [varchar(25)] :Tim birthday [DATETIME] : 1984-01-23 …  |
| | Hi, Can anyone help? I have 2 table each over 2M records and it is taking ages retrieving records. 1. A 'product' table that contains all products in store. 2. The second table is the 'offer' table which contains all offers related to the products (e.g price,store,product condition). 1. 'product' … |
| | im new to python, been working in php largely in the past, but wanted to learn something new and different. as such, i want to use python to create webpages, but have been tinkering in the IDLE until now... when using php, I use a local install of WAMP... is … |
 | Hi and I have a database with over 32 million entries and whenever I try the below mysql query or simular it crashes the sql server unless I use phpmyadmin. I have 4 columns all indexed and all are the char() type with a fixed length. Below is an example … |
| | 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 … |
| | 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  |
The End.