[mysql] Forum 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. + …

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.

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 …

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 …

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 …

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'> …

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 …

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 …

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 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 …

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 …