10,940 Topics
 | |
| | am doing project in c++ using mysql api i have update query like that q2<<"UPDATE `dorder` set `ddown_status`= 1 WHERE `Machine ID`= "<<"'"<<xbx4.mid<<"'"; > but when i execute it , its says Unknown column 'ddown_status' in 'field list' but ddown_status coloumn already exisits in dorder table , so any idea … |
 | Hi would you please help my how to know my ( mysql host server)???? i used greengeeks to upload my website , i tried "local host" but it shows "couldn't find data base"...thanks <?php mysql_connect("localhost","ahmedhay_ahmed","Password") or die("couldnt connect to data base"); mysql_select_db("ahmedhay_hayman") or die ("couldnt find data base"); ?>  |
| | I have a form which is like a question paper. It has multiple text fields for entering a question and related information like marks allotted for that question, complexity level, tags in that question etc. I enter all this info into my db. **Tags are the keywords in that question**. … |
| | Basically my table Itinerary table where a record can have a parent record. so table cound have ID Parent ID which can be any ID from The same table. Other details Parent ID can be null if the record doesn't have child. and if i delete the parent record of …  |
 | Guys can I connect my vb.net program to my php website's database even if I already uploaded it in a web server, is the database that will be use by my PHP is the database that I made in my PC? please help me because this is the first time … |
| | Hi everyone I have windows form application connected to mysql database. To menage this base I use mysql.net connector. After I make some changes in datatable in my app, I use rowChanged handler to store changes in mysql. Here is code I use in handler: cmdBuilder = New MySqlCommandBuilder(dataAdapter) dataAdapter.Update(datatable) … |
| | |
| | Hello, I would first like to explain my current setup. 1) Nginx Server (A) which is the front-end proxy 2) Apache/MySQL (B) Serves the normal traffic and holds the databse. 3) Apache servers (x) x-servers are used to help shed the load. (nginx will channel the apache load to both …  |
 | Hi there, I have a classified website, built with custom PHP code. The problem is that the title of the entire site is the same. Attach files **index.php** and **pOffers.php**. Please give ideas on how to call from database the title of the listing. Tell me if you need more …  |
| | Dear Friends. When i going to UPDATE data of the database using UPDATE function in PHP, following message displays, What should I do? 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 ':_If_Any_01='Test', History_/_Remarks=NULL, … |
| | there is no file zf.bat in zend frame work2 like in the previous version ............ please any one can tell how to install it easy way and in windows |
| | Hello All! I have a MySQL database with 4 items, id (numerical), group_name, employees, and surveys. I need to in my select calulate the percentage of 'employees' who my the number in 'surveys' have taken the survey. This is the statement I have now: SELECT group_name, employees, surveys, COUNT( surveys …  |
 | I'm working on a design for a calibration management system but, i'm stuck with designing a table or tables to accomodate this data as desscriped in the picture below.  all the numeric data in the picture should be entred by the user but, the correction is calsulated automatically … |
| | I'm trying to get to grips with this create view thingy, but can't see it. This creats my view mysql_query("CREATE VIEW list AS SELECT AlbumId,Title FROM album, LEFT JOIN artist ON album.artistId = artist.ArtistId ORDER BY album.Title")or die ("no dice pal ".mysql_error()); that works, and creats it fine. But when … |
 | Hope this is the correct place to put this question. i am new to linux and am runnning ubuntu 12.04. I just installed Netbeans 7.0.1 and xampp 1.8.1, both running on ubuntu. i would like to make a c++ program that uses the MySql database that comes with xampp. I … |
 | Hi Experts, I need your valuable suggestions for research topic in mysql. Topic should have practical implemenatation part. Thanks |
| | Hi, I'm having trouble getting the information I need from my mysql db. I need to write a query that gets me: 1. A list of all combinations of answers from 8 columns and the frequency of them. Every row contains answers from 1 person from a survey and I … |
 | <form name="form1" method="POST" action="#" onSubmit="return check();"> <?php $con = mysql_connect("localhost","root",""); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("shg", $con); $result = mysql_query("SELECT * FROM consumer"); $email=$_POST['myusername']; $password=$_POST['mypassword']; $query="select * from consumer where email='$email' and password='$password'"; $result=mysql_query($query); if(mysql_num_rows($result)==1) { $count=mysql_num_rows($result); // If result matched $myusername and $mypassword, table …  |
| | Hi everyone, I am having some trouble with a mysql select query not working correctly. The query I am trying to run is "SELECT * FROM cards2 WHERE cardid NOT LIKE '".$_SESSION['clubsId'][0]."' " I have also tried mysql_query(" SELECT * FROM cards2 WHERE NOT (cardid =".$_SESSION['clubsId'][0]." || ".$_SESSION['clubsId'][1]." Would appreciate … |
| | Hi all gud morning > I try in to implement table with pagination. Am using Jquery data table. In data table i have problem loading all data from database so time dealy more. so i want to implement in Ajax, jquery, Mysql. kindly gudience to me. |
| | what I am trying to do is use this php script to load the data being submitted in the html form into my database and then populate the database into an excel (csv) file and then e-mail it to my address. Everything works great it populates into the database and … |
| | i am still learning,pls i need help,i want each and everytime i submit to database all the html tables with value should relect in database,i mean all the table should show in the database this my posting only display one table ............help thanks $editFormAction = $_SERVER['PHP_SELF']; if (isset($_SERVER['QUERY_STRING'])) { $editFormAction … |
| | im trying to submit data from my form into a database. After validating everything the code to insert the data is: $qry = "insert into users(id, name, surname,email, password,date) values (id,'$name','$surname','$email','$password','$date')"; On testing the code i get an error that says:"error: unkown column 'geek' in field list". geek corresponds to …  |
| | This is what I am tring to do... I have a table with 4 items: id (primary key) group_name employees surveys What I need to do is display all the data on a html table in input boxes, and allow a end user to update each field. I have tried … |
 | $query = "SELECT encounter,amount1,amount2,posted1,posted2 FROM payments WHERE pid='$patient_id'"; $res = mysql_query($query); $max =25; $num_rows=mysql_num_rows($res); $x_count=0; while($row=sqlFetchArray($res)){ $encounter_id=$row['encounter']; //$method=$row['method']; $amount1=floatval($row['amount1']); $amount2=floatval($row['amount2']); $posted1=floatval($row['posted1']); $posted2=floatval($row['posted2']); $total_amount_paid=floatval($amount1+$amount2+$posted1+$posted2); for($x_count=0;$x_count<$num_rows;$x_count++){ //$encounter_id[$x_count]=$encounter_id; $query = "SELECT date,SUM(fee) AS totalcharges FROM billing WHERE pid='$patient_id' AND encounter=$encounter_id"; $res = mysql_query($query); while($row=sqlFetchArray($res)){ $date_fee=$row['date']; $total_charges=floatval($row['totalcharges']); $balance=floatval($total_charges-$total_amount_paid); $pdf->SetFillColor(254,254,254); $pdf->Ln(); $pdf->SetX(10); $pdf->Cell(50,4,$date_fee,1,0,'L',1); $pdf->Cell(40,4,$encounter_id,1,0,'L',1); $pdf->Cell(40,4,$total_charges,1,0,'L',1); … |
 | Hello to everyone, I´m having problems on retrieving data from mysql to a textfield in html, the data appears with queston marks inside of a "black diamond"! I researched and followed the steps like putting the database charset utf8, the table too! When I insert for example Alimentação its goes … |
| | Hi, Can you set auto increment in phpmyadmin to be 2? So that it goes 1, 3, 5, 7etc? Thanks............... |
| | I have written a code which used to send data that was saved in my mysql database, through ethernet using UDP protocol, everything worked fine until i sent fewer data(25 rows), when i started sending data in huge amount(100 rows) it used to display Java Result: -1073740791 and would stop … |
| | Hi friends! I got one puzzle. I wonder if there is a way I can create a table but get a table name from a value of the textbox/combo box control. Does anyone have an idea? I mean something like "CREATE TABLE (TextBox1.Text) (".....)" I wonder if that is really … |
| | Ok I am working something that I have seen others do and that is to echo out a form table and what I am trying to do is to get the data that is not assigned to a user and allow the admin to assign it to the user. I … |
The End.