11,093 Topics
 | |
| | Hi Guys, I willing to hear your suggestions and advice regarding a problem of DB design in MySQL. The situation is that I need to develop a DB design which brings High Performance under the following conditions: + There will be 10000 users that will consump and generate data. + …  |
| | lastlogin is getting saved as time() in my mysql table and it is varchar mode. querying the database to send out emails to remind my users that they have not logged in from past 30 days SELECT * FROM members WHERE lastlogin = DATE_SUB(CURDATE(), INTERVAL 30 DAY) i tried with … |
| | Hi friend, I want to use connector for mysql data base. I am follow this page [url]http://dev.mysql.com/tech-resources/articles/mysql-connector-cpp.html[/url] But it seems hard . Is there any other tutorial present. Please let me know.  |
| | This is something I can't find any data on. I've got two database. Database one has a list in it. Database 2 has a list in it as well. I am needing to delete all the entries from database 1 that database 2 also contains. So if database one had … |
| | Hello again I have two questions regarding the REPLACE command. The first query I am running is [CODE]update phpbb_posts set post_text = replace(post_text, '[del]', '[ b][ i]') update phpbb_posts set post_text = replace(post_text, '[/del]', '[/i][/b]')[/CODE] Note - in the above code I have had to add a space before the … |
| | Heyy guys, need some help here...the thing i'm suppose to do is, update a value for a single row, but currently its updating the value for all the row... [CODE] <?php session_start(); $host="localhost"; // Host name $username=""; // Mysql username $password=""; // Mysql password $db_name="test"; // Database name $tbl_name="testing3"; // … |
| | why is it sometimes i get an error? it doesn't highlight the error [B]CODE[/B] [CODE]Dim SqlQuery As String = "Select UserName from Login" Dim SqlAdapter As New MySqlDataAdapter Dim SqlCommand As New MySqlCommand Dim Ds As New DataSet Dim i As Integer With SqlCommand .CommandText = SqlQuery .Connection = sConnect … |
| | Hi, I am trying to transfer values in one table to a new table with a different structure. The current table has 3 fields id, content_id and value and for each content_id there are several records. I would like to transfer the values for each content_id to just 1 record … |
| | Hello, is there any way to show what the size of the records is? I mean, i have a database that almost 500Mb and I want to see what records are causing it.  |
| | I m trying to select data from a drop down and retrieve & display the values corresponding to it into textboxes.. the data to be displayed into the textboxes is taken from database(mysql database).. The scripting is done in JSP which is as follows: issue_from.jsp [code] function showDataIssue(){ xmlHttp=GetXmlHttpObject() var … |
 | Hello guys I am having a problem regarding queries in PHP because I not very familiar with queries especially inner join function, I need to make a profile page wherein it will display records from tblpatient_pass and tblpatient_info connected by (PK)MR_no from tblpatient_info and (FK)RelationMR_no from tblpatient_pass here is my … |
| | Hi, i am beginner in java. I doing my final year project in Java Swing. So far, somehow through some online tutorials and articles, i learned to finish 30$ of my project. Now, i need to know how to insert the data from my database into Jtable and display it.... …  |
| | The query below is correct. It returns the rows `paul` and `rick` because they have the highest rating of the child rows. This was solved for me with the below link. I am having trouble understanding the query. I understand joins, what i don't understand is `t2.rating is null`? [URL="http://sqlfiddle.com/#!2/97e60/2"]http://sqlfiddle.com/#!2/97e60/2[/URL] … |
| | i have a page for user registration where i a form with a image tag to it. i want the user to fill the form but as soon as he uploads the image i want the image uploaded to be displayed on the image tag. Then i want all these … |
| | Hi, I want to know. How to filter data. I have two mysql table as follow name: task_id task my_id 22 aaa 1 22 bbb 1 23 ccc 3 23 ddd 4 24 fff 5 subname:: task_id task my_id 24 fff 1 now my id is 1. I want to … |
| | Ok. I am building a program for a small office and I have a little problem with the code so I thought it's better to post a topic before continiue.. I have search into google and a lot of forums about database connectivity and my problem is simillar to other …  |
| | Hi, I am making a website for a car database. I made a table called Cars with fields Name,Make,Model,Color,Doors. I have also made a search function: [CODE]SELECT * FROM Cars WHERE Name LIKE '%$search%'[/CODE] This is a general search that will search the whole table, but what if I wanted … |
| | I set up a MySQL databse following this tutorial: [URL="http://www.saltycrane.com/blog/2008/07/how-set-django-mysql-ubuntu-hardy/"]http://www.saltycrane.com/blog/2008/07/how-set-django-mysql-ubuntu-hardy/[/URL] Here is what I did: [CODE]$ mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.0.51a-3ubuntu5.1 (Ubuntu) Type 'help;' or '\h' for help. Type … |
| | Basically my app obtains data from a mysql server and displays it in a list view. What I want is for data from different columns (but the same row) to be as different items in a Dialog Box. I followed a tutorial on how to connect to a mysql server … |
| | This is my first post on Daniweb. I am developing a social networking site and the register form isn't quite working as expected. Here is the PHP code : [CODE]<? $title = 'Register' ?> <?require ('scripts/top.php'); ?> <link rel='stylesheet' type='text/css' href='scripts/form.css'/> <div id='content'> <h1> Register an account </h1> <div id='form'> … |
| | Guys I installed mySQLdb in Ubuntu with: [CODE]mydeskt@mydeskt-desktop:~$ sudo apt-get install python-mysqldb[/CODE] but when I go to the python interpreter and type: [CODE]>>> import mySQLdb [/CODE]I get: [CODE] Traceback (most recent call last): File "<stdin>", line 1, in <module> ImportError: No module named mySQLdb [/CODE]It is installed though, because when … |
| | Hi thought i'd try here see if anyone can help solve this quicker. First off we have a email database. The main table is the email data, all unique rows per email address with a unique id. eg. emailid,email 1,email@example.com 2,email@example.co.uk Next we have another table which logs the data … |
| | I have bought a legal copy of SQL Server 2000 to put on one of my websites but can't seem to get it to load. Any ideas? |
| | I would think that this wouldn't be a complex thing, but I guess I'm wrong. I want to create tables in a database based upon a string created by input variables including a parent ID. My Code: -- create table named the value in @newname SELECT CONCAT('Entity_', @@IDENTITY) into @newname; …  |
| | hey people please tell me what to do , when ever i use mysql_fetch_array(data) i get this error : [CODE] Warning: mysql_fetch_array() expects parameter 1 to be resource, null given in C:\xampp\htdocs\awah.biz2\classes\class_lib.php on line 34 [/CODE] please tell me what to do , here is the class_lib.php: [CODE] <?php class … |
| | Hi, I am making a website for a car database. I made a table called Cars with fields Name,Make,Model,Color,Doors. I have also made a search function: [CODE]SELECT * FROM Cars WHERE Name LIKE '%$search%'[/CODE] This is a general search that will search the whole table, but what if I wanted … |
| | Hello everyone. First, a little about me. I started off web development in .Net (C#) and found it to be not suiting my style. Then I moved on to PHP and instantly fell in love with it. I've been practicing it for the last 40-45 days and have covered up … |
| | I use dreamweaver, PHP and MYSQL. I need some help and any is appreciated, I have alot of knowledge in html learnt from some college, little in php and none in mysql, I am self teaching php and mysql, so forgive me if the question is too easy. :) Ok … |
| | is it possible to have a script that when i run that script it will log into a database and delete all the entries from specific database tables? if it is how would that look for database name "test" and "table 1, table 2, table 3, table 4 and table … |
| | I wanna to know the difference between mysql_fetch_Assoc and mysql_fetch_Array..I am a little bit confused at its usage..Kindly provide with a sample example also...Any help would be appreciated |
| | How to connect mysql with difference server If my all file is in 192.168.0.100 and mysql server is 192.168.0.200 I got Error "sorry, could not load your data, please try again later" when try it. If bote all file and database is in same server , It run correct. [CODE]<?php … |
| | I have a LAN connection with my project and I need to display a running time and date of with labels anyone have an idea? is it curdate and curtime?  |
| | I need helping thinking though something. I am pulling dates, Year, Month of that year and an amount. I then want to go to the next year. So, 2010 then 12 rows of the months with amounts, then 2011 then 12 rows of the months printed out with amounts... Ex: … |
| | I am using Doctrine as my ORM and it only reads XML/YMAL files and I was given a schema in form of MySQL script. Is their anyway to dump a MySQL db to a ymal file? |
| | Hi.. I am trying to write a k nearest neighbor and BART bayesian additive regression tree algorithm for identifying Spam emails in php Can any1 guide me on how to implement these algorithm ? This is for my thesis..im just learning php.. If some one could give me sample code … |
| | I want to retrieve email from database and send message to all the email address. I have written code for that but it is not working. I want someone to help me look at the code below and point out where am making mistakes and the correction. The first page … |
| | Good Morning... First let me start by thanking those of you that respond with great education information in here.. You have made my learning curve (time invested) much shorter than it would have been with just a reference manual. I know I still have a lot to learn, but this … |
| | Hey everyone, The query i'm trying to perform shows a list of auctions that a user has bid on, name, id, date ended, current price etc. But also the number of bids that the user has placed on the time. [CODE] SELECT id, name, count(*) AS bid_count FROM wp_wpa_bids WHERE … |
| | Ok, as easiest as i can explain. - There are many child.sid to parent.id - There are many child.nid to child.sid - There are many child.id to child.nid child.id is just the id of a child row. And each row has rating column. In the query i'm grouping by child.nid. … |
| | Greetings! I have a website [url]www.lanceronlinejobs.com/our_franchises.php[/url] I have a franchise images. I want to display each franchise record from database whenever a user click on franchise link. Here is my code. ourfranchises.php code: [CODE]<?php include('fconnection.php'); $sql = mysql_query("SELECT * FROM tbl_franchise ORDER BY id DESC") or die(mysql_error()); $row3 = mysql_fetch_array($sql); …  |
| | Hi all, I'm sure this is a simple problem, but hopefully someone will be able to help. I'm trying to connect to mysql through perl, however when I use the command [CODE]use Mysql;[/CODE] it is giving me an error. I am assuming it is probably something to do with the …  |
| | |
| | Well this is my register form, it all worked fine before but for some reason it isn't inserting anything into the table, all of my other scripts that insert items into a table. A quick reply would be nice :) thank you. Here is the Register Script: [CODE]<?php $title = … |
| | Hi everyone, I am wanting to know if there is such a thing like the mySQL SELECT WHERE but in array's. I have this array: [CODE]<?php $array = array( [1] = array( ['test'] = '1', ['test2'] = '2' ); [2] = array( ['test'] = '4', ['test2'] = '2' ); ); … |
| | hi everyone.. can anyone help me please.. i have a datagridview with 4 columns (id, name, ticket_number, destination), i just want that datagridview on column "ticket_number" to display ticket_number from mysql database and another 3 columns for user input. thanks in advance.. |
| | Hi, I store images in my MYSQL database. I need to retrieve that image to my jsp along with datas.Response.write() function only displays the picture and not the data. How to do that? |
| | Hello,i have the following html page. [CODE]<html> <head> </head> <body> <div class="container"> <div class="8"> <?php $firstname['1']; ?> </div> <div class="8"> <?php $firstname['2']; ?> </div> <div class="8 last"> <?php $firstname['3']; ?> </div> <div class="8"> <?php $firstname['4']; ?> </div> <div class="8"> <?php $firstname['5']; ?> </div> <div class="8 last"> <?php $firstname['6']; ?> </div> … |
| | Hi, I'm trying to sort out the names from the database based on the first letter by using (addr WHERE LIKE 'A%'). This gives me the following error message: [B]Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in...[/B] Does anyone know what’s wrong here? Everything works great when … |
| | Hello to all, before begin i must say that I'm sorry for my bud english and hope that it not be a problem for understanding whit you. I'm looking for a solution to create a simple background server application that running and live over infinite loop cicle, whit have the … |
| | Hi about 7 days am experiencing this problem if you can help me out this is the code; it's not updating at all it's just redirecting me to the page this is my code [CODE] function editcat($cid,$catname,$catdesc,$ok=false) { global $db; $id = intval($cid); $result = $db->query("SELECT * FROM category WHERE …  |
The End.