[mysql] Forum Topics

Hi, I have 2 spreadsheets with say the following data: Spreadsheet 1: Column 1 Column 2 Eatables A Eatables B Apple Watermelom Orange Apple Banana Peach Apple Spreadsheet 2: Column 1 Column 2 Eatables Status Apple Eat Orange Don't Eat Banana Eat Peach Eat Watermelon Eat Tomatoes Don't Eat Avocado …

how to populate treeview from multiple columns of sql data table I have attached my sql table here.from that table,i have to populate a treeview of the below form; -outlook ---------overcast -----------------------------yes ---------rainy ----------------wind ----------------------strong ------------------------------no ----------------------weak -------------------------------yes ---------sunny ---------------humidity ------------------------high --------------------------------no -------------------------normal ---------------------------------yes. It is readable like this; if …

I have a script that reads all rows from a database, and prints it out to an html table. The html table has an extra column for "status".In this column there is a form that is supposed to submit the dropdown field to the mysql database. I've got the set …

Hi, I am trying to update data from a column in a database using a php script. But for some reason it doesn't update the database, but i get no error feedback. So first i select a random entry from the database and i add it as a parameter to …

The below line generates this error. Can anyone gives me a solution Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in C:\wamp\www\MySite\php files\approve_page.php on line 25 [CODE] $query = "UPDATE transaction SET approved_status='1' WHERE account_number='$account_number' AND tran_id='$_POST['tran_id']'"; [/CODE]

hello all how to count numbar of mysql tables programmatically (c#) thank you

hello all how to use mysqldump in my project I see an example : MySqlDump my_dump=new MySqlDump(); but it seem need some reference or something,and won't work without it what should I add to make it give no error' thank you denny

Hi all. So I have a site where I need to display uploaded images for properties. There could be anywhere from none to several images of one property. I have each image going to it's own folder based on address. Should I call on those images directly from the folders …

hi.. i m making a university project on a dental clinic i have two tables one containing information abt the visits in a dental clinic(tbl_daily_opd) and the other containing the details of the patient(tbl_patient).. tbl_daily_opd contains only the id of the patient.. i m printing tbl_daily_opd in the report with …

I have one select list, which is populated from the DB like this: [CODE] <select name="position" id="position" onChange='itemdisplay(this.value)'> <option value="<?php echo $til_subject; ?>"><?php echo $current_subject; ?></option> <?php while($row=mysqli_fetch_array($result)){ echo '<option value=' . $row['id'] . '>' . $row['linknavn'] . '</option>'; } echo "</select>"; ?> // Next to this list i have …

I have a table with entries for different accounts and each account has different products listed in it with a date next to each entry. An example of the structure is below. Account | Product | Holding | Date A1 | Car1 | 2 | 2010-12-31 A1 | Car2 | …

Hello all, I've a seemingly simple question, but it's kind of got me thinkin there might be a "proper" way to accomplish my goal. My goal is a simple MySQL database schema install. In PHPMyAdmin I export a database, any database. I then save the file to the root directory …

Hi everyone, My second time back to Daniweb looking for assistance with PHP. :) Okay, here's my PHP, and I'll explain what it does. [CODE]dbConnect(); if ($userclient == '2438') { dbOpenDatabase($GLOBALS['res_2438_contacts']); } else { dbOpenDatabase($GLOBALS['db_contacts']); } /************************************************ * THE IMPORTANT BITS - CHANGE BELOW * ************************************************/ //Product ID for Safety …

Hi all, [INDENT] i am facing a serious problem working with MySQL and Nhibernate 2.1.2.4.0 named queries. I have written a stored procedure and i am calling it in C# using a flat class to map the database fields. My problem is it seems to work fine with Mysql 5.1 …

I need a fresh start and some fresh ideas. I get some text from a MySQL database and present like below. Each row is divided into five columns with radio buttons. ---------------------------------- Text 1-Text 2-Text 3-Text 4-Text 5 Radio1-Radio2-Radio3-Radio4-Radio5 ---------------------------------- Text 1-Text 2-Text 3-Text 4-Text 5 Radio1-Radio2-Radio3-Radio4-Radio5 ---------------------------------- and so …

Hi people, I am working on a project and I would like to create a report whose data are retrieved from my sqlserver database. Can anyone explain to me how to do it or any link that can help me?

Good God, I've been stuck for like 2 hours, I suppose I can't think clearly anymore, but I just don't see why the statement below won't work, please help me out : [CODE]<?php session_start(); $username = $_GET['username']; $db = new PDO('mysql:host=localhost;dbname=subscribers', 'root', ''); $sql = "INSERTO INTO users (username) VALUES …

CREATE TABLE `employee`(`employee_no` CHAR(4) NOT NULL,`emp_name` TEXT,`employee_sal` INT NOT NULL,primary key (employee_no); << I typed this and it says there is an error (see below).I can't see what is it.000webhost.com Mysql server [CODE]Error SQL query: CREATE TABLE `employee` ( `employee_no` CHAR( 4 ) NOT NULL , `emp_name` TEXT, `employee_sal` INT …

I am making a request form with a uniqe FORM NO. in order to recall the data faster. The FORM NO. is formated as follows, yyyyMMdd-000 the 000 will be incremented for every transaction made that's easy... but the problem is how to reset it back to 000 the following …

This is my blogic.php file. The problem is i have created a patient login form and a database name"gmd" so as soon as i fill in d username n password in patient login form it should retrieve the whole information from "gmd" database bt it is showing an error in …

I don't know what's wrong with this code. I think this code should work. I'm about to store number of each query in array [CODE] $antecedent=array(); for($i=0;$i<=$index;$i++){ if(isset($period[$i])|| isset($gpa[$i]) || isset($antecedent[$i])){ echo $period[$i]."&nbsp;"; echo $gpa[$i]."<br/>"; $queryAntecedent=mysql_query("SELECT * FROM mytable WHERE study_period='$period[$i]' AND ipk='$gpa[$i]'") or die (mysql_error()); $antecedent[$i]=mysql_num_rows($queryAntecedent); }//endif }//endfor print_r …

Of course, Yesterday I ask for help for my google map route creator. And of coure, I made my google maps route creator source. [code] <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Google Maps</title> <script type="text/javascript" src="jquery.js"></script> <script src="http://maps.googleapis.com/maps/api/js?sensor=false"></script> <script type="text/javascript"> …

Hi, i need help , i wanted images to be for instance 4 in row, before it goes on to the next row, and below the images i wanted a title there. This are my work so far, but i just cant get to what I wanted, i've been searching …

hi folks, Here i face problem in my webpage [servlet + mysql] Connection are working fine. But when running time it get download the page instead of display the content in the browser. I try myself so many time, cant sove it.. plz guys help me to overcome this problem. …

Hi everyone, I have setup a cron job to delete users from my site if they are not verified within 24 hours of registration. The field [b]registration_timestamp[/b] is stored as a timestamp and I also have a field called [b]verified[/b] which is stored as a 1 or a 0. Here …

So I have a text box in a form. The test box needs to take the value entered and insert it into a column within a row in MySQL. I know it's connecting to the MySQL online, I have a message box telling me so upon a successful connection. I'm …

it doesn't have any error but also i does not update in my database? [CODE]<head> </head> <?php include('connect.php');?> <body> <?php mysql_select_db("dbusers",$connection); $result=mysql_query("UPDATE tblinfo SET idno='$idno', name='$name', address='$address', birthdate='$birthdate', contact='$contact', email='$email' WHERE 'index'='$id'"); $result = mysql_query($update) ?> </body> </html> [/CODE]

[CODE]<script type="text/javascript"> function populateHarga() { var x=document.getElementById("barang").value; document.getElementById("harga").value=x; var y=document.getElementById('barang')[document.getElementById('barang').selectedIndex].innerHTML; document.getElementById('nama_brg').value=y; } function populateTotal() { var y=document.getElementById("jumlah").value; var x=document.getElementById("harga").value; document.getElementById("totalnya").value=x*y; } </script> <body> &nbsp;<p> <?php mysql_connect("localhost","root",""); mysql_select_db("stageco"); ?> <table border="1" cellpadding="0" cellspacing="0"> <?php $nama_b=$_GET['nama_brg']; $harga_b=$_GET['harga']; $jumlah_b=$_GET['jumlah']; $total_b=$_GET['totalnya']; if($nama_b!="") { mysql_query("INSERT INTO temp('t_nama','t_harga','t_jumlah','t_total') VALUES('$nama_b','$harga_b','$jumlah_b','$total_b')"); } $result=mysql_query("SELECT * FROM temp"); $i = …

I'm a bit new to this so excuse my noobness. For the website I'm working on - I'm wondering about whether information like images, uploaded files, date of birth, edited details etc. can all be displayed on the same page (specific to the user who has logged in, not everyone …

Im in need of big help... (sorry bout the size of the post :$) Im just getting started in databases and need some magic.... Im running on the server; * Apache/2.2.17 (Win32) mod_ssl/2.2.17 OpenSSL/0.9.8o PHP/5.3.4 mod_perl/2.0.4 Perl/v5.10.1 * MySQL client version: mysqlnd 5.0.7-dev - 091210 - $Revision: 304625 $ * …

My java application has been running smoothly for the last 2 years in one linux server. Recently, we moved it to another linux server and it's then that it started giving the error as shown below: [CODE] java.sql.SQLException: Prepared statement needs to be re-prepared at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573) …

hello everyone , I'm facing a problem in inserting data in TEMPORARY table. i can do it by simple query easily. but i want to do through [CODE] for Ex. i have bunch of query which i'm executing through SET @QueryText="Select ID from employees limit 5"; //it contains bunch of …

here is my code for message i want to show message with avatar .i'm unable to create it any one help me for displaying message with avatar my message system [CODE] <?php require "database.php"; $userfinal=$_SESSION['MM_Username']; // get the messages from the table. $get_messages = mysql_query("SELECT message_id FROM messages WHERE to_user='$userfinal' …

Wow this code is driving me insane. My problem is getting two arrays into a multiple INSERT query. I can't seem to find a way for the loop to insert both arrays. [CODE]$sql_data = array(); $sql_prefix = "INSERT INTO student_score(course_uid, student_uid, question_uid, answer) VALUES"; foreach($_POST['answer'] as $id => $answer){ // …

hello: I'm trying to modify the following query so that it only select rows where [code]90 - DATEDIFF(CURDATE(),date) as days_remaining[/code] is greater than negative 15. (days_remaining > -15) [code]$query="select servicearea, date, customerid, clientID, 90 - DATEDIFF(CURDATE(),date) as days_remaining from servicesrendered where servicearea=' Oil Change ' and DATEDIFF(CURDATE(),date) > 79 group …

Hi, I have a table with 10,000 records but I only want to read 250 at a time. I know the row number of the 250 records that I have to read and so I want to avoid reading all 100,000 records each time. For example, if I want to …

Hello All Developeres, Please Read Below Senario. I have one table Supposed "Emp(EmpID,EmpName)" Now There is data with Name "testName1" and "testName2" in EmpName Field Now I need query which fetch all record in asceding order for EmpName Field and Record with "testName1" and "testName2" will must display at [B]last[/B]. …

Hello boys.. I'm here for an advice.. I have table 'users' with : ID , USER.. And 'activities' with : USER_ID , activity.. I want to select the USER_ID from 'activities' to find the user ID in the 'users' table.. I am using the VB database.. On php i know …

Hi... I've been doing ASP.Net for years, but I am very new at PHP. I need to redirect a user to a specific page based on the refereeing page. There's no way to calculate what the page should be so I figure I would have to use MySQL and look …

I want a database that should fetch images from a URL.How can I do that?

Hi, I have a problem adding the values of an array into a mysql database. The thing is I have two loops and if I add the INSERT in one of the then the other one gives the wrong value. But if I echo inside each loop it gives the …

Hi All, If someone can help me with this I would be eternally grateful here. I have created a form on one page with php validation. Once cleared through the validation I have Sessioned the inputted data to catch them on the "insert data page" on the "insert data page" …

Following is my error free code, it has no syntactical error but when I run it it executes the else part, which means my databse has not been updated.What is the problem? <html> <body> <?php $connect=mysql_connect("localhost","root","ila"); $query="create database if it not exists demo"; $db=mysql_select_db("demo",$connect); $query= "create table jlt(id int not …

Hi all, am using eclipse IDE.I want to connect mysql database with jsp/servlet for that i want to add mysql j/ connector. I added properties -> Java build path-> Add External jar file but still it calls the exception Driver not found "com.mysql.jdbc.Driver". Am not filmier with Eclipse any one …

I feel like a total muppet for not being able to do what is likely a stupidly easy task. I have downloaded the MySQLdb.zip, unzipped it to my desktop and am trying to get it to work with my python 2.7 (its compliant). Can anyone give me a step by …

hi, I need a query to get the start date and end date of a month when given the month name. For eg., When given month='august' it must display 01-08-2011 to 31-08-2011 Thanks.

Just started learning MySQL, more specifically using Python and MySQLdb and everything is up and running fine. I have an interface where i generate buttons: 1) Firstly the main catagories are generated. 2) on clicking these buttons, sub-catagories of these catagories have thier buttons generated. 3) once again on clicking …

I'm trying to make a postback script which works with a CPALead widget, however it does not seem to work. I do not think my code is wrong (which I have attached at the bottom) so I was beginning to think this was not possible due to the fact that …

Recently I have been working with Mysql and PhpMyAdmin a lot on Ubuntu, and I have stumbled across a very annoying error, or set of errors. I keep on getting a bunch of random loosely related error messages. These are the errors I get. When I try to log in …

[B]Hi guys, Well I just reinstalled vBulletin 3.8.6, on top of the other. I tried to make a new THREAD, after posting it says:[/B] ___________________________________________________________________ Database error in vBulletin 3.8.6: Invalid SQL: UPDATE session SET newposts = newposts+1 WHERE NOT ISNULL(newposts); MySQL Error : Unknown column 'newposts' in 'where clause' …