[mysql] Forum Topics

sorry to post it here.. i really need your attention.. thanx 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 …

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 …

Dear Members, I found a thread named 'Execute an sql script in jdbc' it was very much useful to me. However i have my routines(ie. stored procedures and functions) also with the backup.sql file. This is the link which i looked for: [url]http://www.daniweb.com/forums/thread153923.html[/url] But i have to execute my script …

Hi i have made a stupid mistake in my code which i cannot find,and i am getting this error Parse error: parse error, unexpected T_STRING in /home/content/d/r/a/dragun/html/vote.php on line 107 According to my eye sight it should be o.k. but apparently not. Can anyone give a helping hand. As far …

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 …

Hai I am sathya, i create a database, i convert the databse in datagrid manner via php. now i want to create that dastabase in form of editable in the same grid. some body told me that it will made through the ajax......... is it possible ............... if it possible …

I'm interested in the limit parameter. When ever I try to use that I get this error: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(0,5)' at line 5" this is the line …

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

I am writing a page for work that uses php and mysql to store and view a list of common commands used on our servers. I want to make it fully dynamic. By this I mean the command field names are pulled from the database. This is so the managers …

I am about to start my thesis this January 2008. I pick java as my PL but I don't know any database right now.. is there any database than i could learn easily and also fit to java? please help me..

can any one tell me how to write the query to find out first 6 highest salary from table note: not 6 th highest salary ....

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 …

Ok, I have this dilemma reguarding the building of querries. I have a website that browses hotels. The user can select the region and the quality of the hotel via some dropdown boxes and then he is offered weather the search results should include certain options that the hotels should …

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

At the moment I have a normal ajax example that refers to an xml file. This xml file is a conversion of a mysql database file I have. Now I wish to cut out the middle man (xml) and refer straight to the database. Any Ideas on how I would …

hi all i have one employee table ..it contains 2 coloums like employee name and manager... every employee have manager ...that manager also one of the employee...some employee dosnt have manager on that table... i want to write the query who dosent have manager on that table?

can any one telll me the answer soon 1.i dint get clear idea about abstract class and interfaces in c#? when we go for abstract class and interface in c# .net? explain with coding example 2.explain about staic mathoda with example... 3.i have 1000 records in my database...want to dispaly …

i have set up a mysql db for storing news articles to be displayed within a flash website. i have now been asked if i could add an image upload function to this section. i have created the upload page and i can upload the images to the db fine. …

Hello, all: I have a general question on SEO and database-driven site integration... I am starting to convert a company site from static, to dynamic driven site (php/mysql) with a basic admin section, so that owner can make changes himself thru the browser. I have read about issues related to …

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 hv a chk box item field and the bound field . and one separate drodown llist i hv added in my code.based on the selection of the chkbox , it will giv me the index and the selection of the calue from the dropdoen list , both the values …

Job Specifications/ Requirements: To manage a small team of web developers and Sys Network Admin people. Must have advanced programming and web development skills with PHP Mysql, and some Sys Network Admin skills. Excellent communication skills Will be working with overseas clients. Can start As Soon As Possible Starting salary …

Hi.. I am creating one table has huge data. creating one input text & search button. when put some string i.e. anything we want as input in text field [COLOR="Green"]when click on search button..... [/COLOR] [B]I want to show that the content match with string the rows in database are …

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 …

Good day everyone from beautiful California, I have been able to limit the number of listings showing per page ($per_page=10) [COLOR="red"]But how do I limit the number of pages so I do not have rows after rows of pages.[/COLOR] [B][COLOR="Green"]The way it looks now:[/COLOR][/B] 1 | 2 | 3 | …

Hi all, First poster here - have been reading through many of the posts but need someone to break something down for me. Have been given an assignment in college to create a Login / Register page using sql and jsp. I have done a page like this before but …

hi, if i have a db: person> pID (not null, auto_increment), lastname, firstname phone>pID (not null), phoneNum, pID(foreign key points to "person") assume connection is established and pointing to the right database already////// //assume $ln and $fn have value for user input [code=sql]mysql_query("INSERT INTO person( ' ', '$_POST[$ln]', '$_POST[$fn]' )"); …

If I run this query in the PHP Admin it displays 2 records [code=php] SELECT staff.emp_no, staff.fName, staff.lName, event.event_date, event.timeStart, event.timeEnd, event.emp_no, event.agenda FROM staff, event WHERE staff.emp_no = event.emp_no AND event.emp_no =201 AND event.event_date = "27-01-2008" AND timeStart = "1020" [/code] The above query gives Results emp_no fName lName …

I suppose this is easy for a lot of the people who are familiar with PHP/MySQL. I'm relatively new to the whole thing...so please bear with me. I have a single table entitled "events" with two fields. One field is the "date" field and the other is the "event" field. …

Hi, I will be attempting to learn PHP very shortly. I am going to create a MySQL database to hold records of students, especially attendance. I would like to know if it is possible to do the following with PHP.... [LIST=1] [*]Connect the database with PHP [*]Add new details to …

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

i want to retrieve last record in database with out doing ascending or decending order...can anyone tell me what query for this?

hello there, this is my simple php code which inserts a row into the db. the problem is that it doesnt work 'nothing happens no row is being insert and i dont get any error. I have no idea whats wrong. hope to get any solution. thanks. db structure: Id …

[CODE]#!/usr/bin/python # e begoli, python connector for mysql # import MySQL module import MySQLdb # connect db = MySQLdb.connect(host = "localhost", user = "adamplo1", passwd = "U7RJM5HQ", db = "adamplo1_UniProject") # create a database cursor cursor = db.cursor() # execute SQL select statement cursor.execute("SELECT * FROM User") # get the …

Hi all, I would appreciate any help on the following problem: I have a one-to-one-to-one ternary relationship where [B]Supervisor[/B] “chooses” [B]Student[/B] for [B]Project[/B] A supervisor chooses one student for one project (This is going to be the case when there are many students applying for the same project with a …

Alright this is my first program in python, so be gentle. I have 2 files I need to basically combine to create a record in mysql. Features.txt has around 1300 records and property.txt has about 25,000 records. I can read in property.txt fine and get my insert statements. My problem …

Hi, In my webpage i created student details in that if i click view then i want to display all student name and their details one by one but in my code i typed everything but it displays first data only.Can anyone tell me how change this code. this my …

hi all, i am fetching recods from mysql in a combobox.but only one record display .... i want all record display in combobox ......................i write query below and need help how to sote fetch row in array i declered "$va[]" [CODE] <?php // echo "Connected MySql"; $res1 = mysql_query("SELECT gp …

hi friends How to set application path using VB.Net using MySQL..... The same function using VB 6.0 as Public AttnPath As String AttnPath = App.Path & "\Data" this type, i need vb.net help me plz... Regards Anandh

Help Spent HOURS on this and cannot see the problem. It will display the country but not the number of clients that are within that country??? [code=php] <?php //Retrieve the "count" for the number of people in the specified country $country= $_POST['totalbycountry']; //Connect to the server...$connect will contain the connection …

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 …