11,093 Topics
 | |
 | 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 … |
| | Hello all. Thanks for the help! Two tables: Table `posts` holds 'p_id', 'post', 'u_id' Table `users_profile` holds 'u_id', 'profile_key', 'value' How do I return [U]one[/U] row for each 'p_id' that includes all the information in the `posts` table as well as the information in the `users_profile` table WHERE `posts`.`u_id` = … |
| | I am using Tomcat as a server to work on a servlet that need to access a database and I need to use CachedRowSet, but I cannot seem to connect to the database correctly. Currently I have [code] public class FaqListingServlet extends HttpServlet { private CachedRowSetImpl cachedRowSet; // set up … |
| | I'm a nubbie network administrator in my office, a couple of guys installed a mysql server, deployed a database(along with it) and also an application program that accesses data from the mysql server. I can ,using sqlog, log using a specific username, pwd, port number, servername(here i use localhost) . … |
| | Hi, I have finished creating interfaces for my site but I don't know to connect them to my database that I created using mysql. How can it be done to support: 1. Inserting data into the database 2. Deleting data from the database 3. Applying the login feature on the … |
 | Hi, freinds how do i create new database in mysql pls help me its important  |
 | hi guys, I want to create my own PHP, MySQL forum for my website. Please can anybody give me or direct me to a website where I could get the source code. Thanking you in advance |
| | I am trying to build a refine search like this one, [URL="http://www.k-tech.uk.com/store.php?category_id=5&offroad=1&manufacturer_id=&model_id=&Submit=Go"]http://www.k-tech.uk.com/store.php?category_id=5&offroad=1&manufacturer_id=&model_id=&Submit=Go[/URL] My search is smaller that the link above, i have only 3 products and each product has his own page, i ned to run a search for MAKE, MODEL, YEAR and depending on this values i need to … |
| | Hi, If you are interest in using MySQL as your back end database, here is one way to connect: By using ODBC: 'Declare ADODB variable Public ConnectData As New ADODB.Connection Set ConnectData = New ADODB.Connection ConnectData.Open "DSN=MySQL_ODBC" If you want to use MySQL ODBC 3.51 Driver , You can write …  |
| | Hello ALL The project we're working on is a document retrieval system I have 3 tables as follows. Table 1 contains words from a example doc. Table 2 contains words from documents in a database. Table3 contain only one column ‘DocID’. I would like to search the database to find … |
| | Hi to xperts here, I do not know how to update with the follwing requirement [code]$score_update_query = "UPDATE participation_score SET score_last_update = '$date' , score = (IFNULL((SELECT avg(score)*0.8 FROM entity_score WHERE entity_score.contributor_id = contributor.contributor_id) , 4) + IFNULL((select participation_score*2 from participation_score where participation_score.contributor_id = contributor.contributor_id), 1) ) WHERE participation_score.user_id is … |
| | hi everyone i think this is common problem among many, i'm getting this message when try to open ssh shell using cpanel "For security reasons, shell access is not enabled by default. In order to activate shell access on your account, you will have to contact your server administrator" i … |
 | Hi ppl! Im using a java servlet to access a mysql 5.x database, BUT when I run the servelt from my web browser I get this error : "No suitable driver found for jdbc:mysql://localhost:3306/spacemandb?User=root&Password=admin " I have intsalled all the necessary drivers viz mysql driver and it is working. here … |
| | I was under impression that declaration of [icode]char(4)[/icode] can store only values of [B]exact length[/B] of 4 characters. However I was able to insert empty string and strings of less characters than 4. Is there some datatype that will only accept string of declared length? Strings with less characters should … |
| | Im trying to connect from windows xp using my program using odbc connector and SQLyog to a mysql server which is installed in windows 2000 server.. i keep on getting the same error.. i tried to use wamp server also but i was not able to connect at all.. i … |
| | Hi all, THere is no intersect statement in MySQL. I figure out a workaround as shown below. However, I am not sure if it is correct or not. Please help. [code] SELECT * FROM ( SELECT DISTINCT col1 FROM t1 WHERE... UNION ALL SELECT DISTINCT col1 FROM t1 WHERE... ) … |
| | Hi everyone, how can i get the updated number of rows from MySQL? Because i need the syntax to do the calculations on the number of inputs, thanks.... |
| | I am taking a web design and development class and we have been thrown into MySQL along with java without much knowledge beforehand. Was wondering if anyone could help me with understanding how to query the database and update entries, as I am confused on how to accomplish this. I … |
| | Hi, I'm new to Perl but I'd like to know more. For this purpose I downloaded the ActivePerl-5.10.0.104-MsWin32 .msi package and installed it on my computer OS XP Home. Xitami, PHP, MySQL were already installed, and PHP can connect to MySQL. Now I run the following code from the command …  |
| | Hi All I was wondering if somebody could help me as this is driving me crazy. I am trying to send an array from a mysql_fetch_array result to a seporate table. I have the following code: [code=php] include("config.php"); $result7 = mysql_query("SELECT * from order_total"); while($row = mysql_fetch_array($result7)) { $test = … |
 | hi all, how to display last 10 record form a table.please help me. |
| | Hi there I was wondering if anybody knew how to change the below code (which currently defaults to a MS Access database) to a mysql database. The below code is apart of a Caller ID software [code=vb6] Private Sub OpenDataBase() Set fo = New FileSystemObject Set wrk = CreateWorkspace("", "admin", … |
| | hi i am using db layer foor all my quries.i want to know how to use mysql_num_rows in dblayer thanks in advance |
 | Hello all, greetings! I have been playing with DB, seom time ago and want to resume soon where i got stuck. I want to make MySQLdb to get working with wxpython GUI. I got stuck on how to attach the tuple I got from select command to series to the … |
| | cut a long story short I have 2 tables, one called orders_total and another called orders_complete. the total_oders table contains rows of what the customer has ordered to eat i.e. colum called 'item' contains the item description colum called 'cost' contains the item cost for example i can sucessfully display … |
| | I am attempting to write a shell script that executes a query on a mysql database. It seems to run fine in the mysql panel, but not in the script. The code is: mysql -u username -ppassword -e 'delete from table where forumid = 25 and replace (title, ' ', … |
| | Hello ALL, I did the following query. the EXPLAIN result showed 'NULL' in the 'key' colume, meaning that NONE of indexes have been used. However, indexes have been created on Name fields for both tb1 and tb2. I wonder why MySQL does not use the indexes to speed up the … |
| | i have done making a table in mysql database, i was also able to add data through jsp into the database, i can also delete it but i just don't know how to edit or update the data stored in the database, using jsp...can u please help? just codes or …  |
| | What I have done/tried: 1) Download JDBC driver from Centura/Gupta/Unify website. Called and confirmed the JDBC driver is backwards compatable with sqlbase 7.6 2) Put jdbc file into mysql migration toolkit lib directory: C:\Program Files\MySQL\MySQL Tools for 5.0\java\lib\SQLBaseJDBC.jar 3) Open MySQL Migration Manager, configure: - source database Database System: Generic … |
| | |
| | I am taking a web design and development class and we have been thrown into MySQL along with java without much knowledge beforehand. Was wondering if anyone could help me with understanding how to query the database and update entries, as I am confused on how to accomplish this. I … |
| | Hi, I need to find out the term for two different query types. I know that we name queries as PL/SQL stored in the database and called in web pages like view, str.proc. What do we call queries used in web pages as a string and send to dabase to … |
The End.