10,946 Topics
 | |
| | Hi all, I using PHP & MySql. Here's the situation: 1. I have a website which is a meeting place for employees & employers. Employees can sign up for an account & select the skills they have. These skills list will be shown on their resume. I have an array … |
| | Hello, About a week ago, I created a new DB (e...), put it on the server and edited. [B]ALL FINE THERE [/B] However, certain tables with the [I]same names[/I] on a [I]different DB[/I] (f...), on the [I]same hosting account [/I]were over written with the information from DB e.. [LIST] [*]The … |
| | Hi, I have this problem to solve [quote]Create a set of tables to store data for an address book (contact) application. Bare in mind the following design criteria. * The application will be used by multiple people so the database should also store a list of users. * The people … |
| | Hello all, lets say i have a table like this which has 3 columns and 3 rows; -----------------------------------------------------------+ COLUMN_A.....|.....COLUMN_B.....|...COLUMN_C | .........X............|...........X............. |.........X...........| .........X............|...........-...............|.........X...........| ..........-............|...........-...............|.........X...........| -----------------------------------------------------------+ So, now i have an input like; (user submits a form) ----------------------------------------------------+ ......X............|...........X............|..........-.......| ----------------------------------------------------+ now; the first column of row#1 is X so it is … |
| | Hi I'm having trouble with a subquery and really need some help. I'm trying to count to count the number of beats sold by a particular producer. So the first thing I did was SELECT all the beats sold by that producer so I wrote the code [CODE] select name, …  |
 | Hello, i'm working on netbeans and want to access my database using this code: [CODE=java] import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; public class connect { /** * @param args */ public static void main(String[] args) { try { Class.forName("com.mysql.jdbc.Driver").newInstance(); } catch (Exception ex) { System.out.println("error \n"); … |
 | Hi! I've got a table of, let's say, widgets. Each has a unique id (primary key) and a few other attributes such as widgetid (unique, number) widget_name (string) widget_price (varchar) widget_color (string) BUT, for each widget, I also want to list other widgets (that are listed in the same table) … |
| | i get an excel report each month, There are two columns (person`s name and Salary) in this month report there was 99 persons. my question is , if in next month excel report there are less persons...say 75, and also 23 persons raised their salary.. how can i updatae this … |
| | Any one help me. How do i insert Image in to MYSQL5.0 By use of vb.net2005 ? |
| | Hello everyone, I am setting up a section of coding in which I need to add and subtract certain values to a mysql field. However ...the code only seems to add negative numbers (-13.0) as a postive number to the database and its really confusing me now! :( What I … |
| | Hi, This is urgent if any one could please help me resolve the stated issue....... I know how to create cursors in ProC* and how to manipulate them. But I have to do it with a combination of C and MySql. Can any one guide me as to how the …  |
| | Hello all, For creating dynamic title tags, I tried using [code=php] <title>welcome<?php echo '$pagetitle';?></title> </head> <body> : : <?php : $pagetitle = '$row[2]'; ?> //closing rest of the tags. [/code] I get nothing displayed on title ! So i changed the code to, [code=php] <html> <head> </head> <body> : : … |
| | I need to get the 'customers_info_date_account_created' from the 'customers_info' table where the field 'customers_info_id' matches with the field 'customers_id' in the following query: [code=sql]SELECT * FROM customers WHERE customers_id NOT IN( SELECT customers_id FROM orders )[/code] I basically have all the information in columns from the query and need an … |
| | I have a PHP script I am trying to convert to PERL and need some help. Here is the code in PHP [code] $store_list_name = $prod[10]; $category = $prod[11]; $sub_category = $prod[12]; $searchfor = $store_list_name . "->" . $category . "->" . $sub_category; $getcat = mysql_query("SELECT * FROM categories WHERE … |
| | hi all how to run the multiple sql statements same time in mysql querybrowser? for example i am write two sql statements, i want run the second statements in mysql query browser, how to terminate the first statement thanks |
| | Hello everyone. I've just signed up to 1 years hosting with Uk based Fasthosts. They provide support for Python scripting and a free 150MB MySQL database on their Linux package. My problem is that they don't seem to have the MySQLdb module installed. Is there any way I can get … |
| | What i want to do is display all the customers data which is in the 'customers' table where their 'customers_id' is NOT IN the 'customers_id' field in the 'orders' table. I hope i made sense! Thanks, Billy  |
| | Hello.. I couldnt find anything for this topic. I know how to connect to a mysql database and close the connection.But that means that for every script a connection should be established and closed. Is this right and ok for big projects? About 200 concurrent users for example; Having a … |
| | I'm quite knowledgeable with T-SQL and know a little VFP. I would like to code what I think would be a very simple program. I have an excel spreadsheet that has two columns, a date column and a system code column. One of the applications that I use on a … |
| | Hi all, I am using MS Windows SP2. I should like to share my positive and negative experience with the PPM (Perl Package Manager) with the community. For a reason I uninstalled Perl from my computer and installed again. After installation only DBI was present, and for Mysql the DBD::mysql … |
| | Hi, I was wondering how I would enter something like a paragraph in MySQL if you declared it as type TEXT. So how would I enter something like: [COLOR="Red"] John 3:16 (New International Version) 16" For God so loved the world that he gave his one and only Son,[a] that … |
| | Hi, For 2 lakh records, this works well but when the total number of queries is more than 5 lakh it does not . Actually i have 64 lakh records to work with and this gets forever. [code=sql]UPDATE tmp_yk_contributor set score_last_update = '$date' , ykscore = (IFNULL((select avg(score)*0.8 from yk_entity_score … |
| | hi experts, Is it possible that i could get the 3 queries made into one single query.Any help could make me understand and correct myelf in better queries. Each query is taking long time and sometimes the first query crashes , with > show processlist showing status as 'copying to … |
| | hi all, i have a auto suggestion box which displays countries when we type [B]a[/B] it will display all countries starting with letter [B]a[/B] like alaska,australia etc...,but i want to display every name which has letter [B]a[/B] in names like [B]a[/B]ustr[B]a[/B]li[B]a[/B],indi[B]a[/B], etc... |
| | OK .. I was migrating an application from a staging server where the MySQL version is 4.1.10a to a live server where the MySQL version is 5.0.45. There apparently is quite a difference between query syntax on one versus the other. For example, in version 4, this worked: [CODE]SELECT uas.usr_id_users, … |
| | I am attempting to input data from a log file into a database with tables for each network device. The table name is set via a parameter for the function. The script crashes after running stating the table name does not exist. If the actual table name (routerA) is listed … |
| | hi friends, i want to get backup from MySQL DB by use php code. |
| | I have 2 tables with the basic structure town, latitude, longitude postcode, latitude, longitude where latitude and longitude are both floats, and the town and postcode are just descriptive text. I want a query that will display the closest postcode to each town, is it possible? |
| | I was wondering how do you countdown to a given date, like for and enevnt or something. Let's say you know the target date is let's say Christmas and you have the current date, how do I calculate how many days are between them? |
| | Hi , Wishes! I am doing a iterative calculation and in the last iteration, i update few of my tables. What i am trying to do is , make this update more perfect. Is it possible for me to do updates in small steps with using LIMIT. i do not … |
| | OK, now that I managed to insert data properly into a relational database using a linking table, I am now faced with pulling the data properly out of the database, a displaying it so it makes sense. As a recap, I have inserted user data into a data base that … |
 | I'm working on a web app in which each user will have their own account. Each account would have its own data (duh) and this data needs to be kept separate from everyone else (either by putting it in another database JUST for that user or combining all data into …  |
| | Hi, Thanks in advance for any help someone could offer. I'm trying to display a list of stories submitted to my site from a table titled stories, the name of the person who submitted the story and how many comments about the story have been posted. I'm working with three … |
| | Sorry all, this is probably an asked question already, but can't seem to find it. I have designed and uploaded a website for a company. Static pages (3) with a simple form using php to direct the form to one of the companies e-mails. I now need a members log-in … |
| | hello guys, i know all of you are gurus at this as for i am a rookie, i am currently using MySQL 2000 and i would like to retreive information from the database from a certain table via an HTML website what are the scripts that i could run to … |
 | [B][U]Question:[/U][/B] How to replace %20 characters in URL with a dash (-) when the information is coming from a MySQL db? Code:[B][COLOR="Red"] href='details.php?listid=$record[listingid]&title=$record[title][/COLOR][/B] It currently reads: [B][COLOR="Green"]http://www.mysite.com/details.php?listid=800&title=970%20South%20Bald%20Head%20Wynd[/COLOR][/B] It should read: [COLOR="green"][B][url]http://www.mysite.com/details.php?listid=800&title=970-South-Bald-Head-Wynd[/url][/B][/COLOR] I want to keep the title words for SEO purpose unless you think it is useless?? Thank you - …  |
| | I am new to MySQL and did not notice this before. In order to get the query to work I have to use two different quote marks. Notice that the single quotes on the left where I list the column names are from the keyboard key with the tilde `~ … |
| | I am using the following PHP redirect script for a non-profit website, but because the blocked IP list keeps getting longer and longer, I want to pull the IP information from a simple mysql database that lists only IP addresses that have been blocked. I have tried several different combinations … |
| | Hi, I wanted to make use of a algorithm script for computing scores nd though i started doing it with a single database, i after testing script, decided to get a master and score databases both having same tables and data. I imported 2.5 GB of data dump to both … |
| | I am trying to create an authentication script. I am trying to use the PASSWORD function within Mysql but it wont work. Any ideas [CODE] #!/usr/bin/python # e begoli, python connector for mysql # import MySQL module import MySQLdb import cgi print "Content-type: text/html\n" # connection db = MySQLdb.connect(host = … |
| | First off i'm not sure if this post goes in mysql or php so if this is the wrong place please move this post for me. I am setting up a page with a list of commands that are pulled from a mysql database. I have the page that displays …  |
| | hi guys! i am enim, i usually post thread in PHP and i guess its my first time here in mysql.. i have problem regarding the total count of the terminatecause.. i need the count of ANSWERED calls only and the total count of all calls.. can i do this … |
| | Good morning everyone, Is there a way to find out [B]how many MySQL connections are on a particular page[/B]? I am limited to 50 db connections (MySQL+Linux shared server). It seems that my site cannot handle more than two people at once. I have been told by my hosting provider … |
| | Ok ... after receiving some great help and education as to how to design a relational database, I went on to try and create the front end for one. I am learning here so bear with me. To put this into context, so you know, I am using DreamWeaver and … |
| | hi guys, is it possible to distribute a mysql database and java application together without need the server to run the database from, is there's a way around to make this happen?? Thanks in advance |
| | Hi there, please can someone help me with this. I have a VARchar field for NAMES and I need it order numbers correcly and I cant seem to work out the right SQL systax. My sql is this [CODE] SQL = SQL & " Select Distinct" & vbCrLf SQL = … |
| | Hello, I have a master/detail table, in the detail I have a filed payment and another field sum_payment, all I want is when a new record is inserting the values of the field payment to displayed in the field sum_payment. I tried default value but nothing supports this, also tried … |
| | Hi I am trying to get my dreamweaver cs3 to get connected to mysql. But I got this error "your php server doesn't have the mysql module loaded or you can't use the mysql(p)connect functions" I have configure php.ini and the environment setting. extension....mysql.dll extension...mysqli.dll Previously I have install xampp … |
| | Greetings, I have the following code [CODE] <? include("conn.php"); $sn=$_GET["sn"]; $sql="select * from kpi where no='$sn'"; $result=mysql_query($sql,$connection) or die(mysql_error()); while($row=mysql_fetch_array($result)) { $sn=$row['id']; $no=$row['no']; $pdetails=$row['pdetails']; $kpistatus=$row['kpistatus']; $status=$row['status']; $cols=$row['cols']; $rows=$row['rows']; } ?> <form name="form1" method="post" action="formsubmit.php?mode=addtable"> <table width="100%" border="1" align="center" cellpadding="2" cellspacing="2"> <tr> <td colspan="2"><strong>Add Table</strong></td> </td> </tr> <tr> <td>NO</td> <td><input name="no" … |
| | Hi all, I've been given a project to design/build a distributed database on a small parallel cluster. I have plenty of experience with mysql but none with distributed databases. I've been searching information all over the net, but haven't located much on actually building a distributed DB. Can somebody point … |
The End.