10,940 Topics
 | |
| | Hello guys, i have been away in the last few days, because of work, so i am on again. I am trying to ping a series of hosts and then add info about the ping in a row. I have a DB called ad, with a table called ping with … |
 | hi how can i fetch data from the database and stroe it into session variable. my code: $sql = "SELECT password, fullname, username, active FROM ".$mysql_table." WHERE (username = :username OR email = :username) AND password = :password"; $statement = $pdo->prepare($sql); $statement->bindValue(':username', $_POST['username']); $statement->bindValue(':password', md5($_POST['password'])); $statement->execute(); $result = $statement->fetchAll(PDO::FETCH_ASSOC); if … |
| | |
| | Hi guys, I have a table called "goodsbalance" qtyBalanceID | k8goodsID | goodsIn | goodsOut | qtyBalance ---------------------------------------------------------------------------- Can I do some calculation like this? $query_recgoodsbalance = "SELECT * FROM goodsbalance"; $rs_recgoodsbalance = mysql_query($query_recgoodsbalance); $rec_goodsbalance = mysql_num_rows($rs_recgoodsbalance); while (($reck9goodsout = mysql_fetch_array($rs_recgoodsbalance) )!= false) { $query_UgoodsOut = $rec_goodsbalance['goodsOut'] - $_POST['k9goodsQty']; $rs_UgoodsOut … |
| | We have ERP application that store the data to ORACLE database and also we have a lot of another web applications that use the ERP database. We got the performance issues when ERP and another application use the same database. We are planning to do mirroring of oracle database into … |
| | Is it required to use index when the MySQL table has only 100 rows? Justify your answer.  |
| | |
| | I have a question about how to set up a faceted search function in PHP and SQL. I wonder how the result set should be filtered based on the selected facet values. For example if I have a facet menu with 5 filter options how should I filter the results. … |
| | this is my search.php , however once user has view one data user will want to update one location / status . I can not do the Edit.php . Can someone please help me ? Search.php <html> <head> <title>::Home</title> </head> <body> <div id="header"> <img src='banner.png' align='middle' width='101%' height='110%'> </div> <div … |
| | I have created a table in mysql database table(tblmysq) with id(autoincrement),name(string),branch(string),sex(string),and dat(datetime).The following error occurs when i try to insert a record:check the manual that corresponds to your mysql server version for the right syntax near line 1. My lines of code are : Try conn = New MySqlConnection(conStr) conn.Open() … |
| | So im not too sure if im posting this in the right forum. please dont be angry! new at daniweb so basically what i wanna know is how to save real time date into database. what i have is a page with tabs of month and in each tab the …  |
| | So I have the following MySQL query, which works fine: select year(created_at) as year, month(created_at) as month, day(created_at) as day, item_sdb_id, price_per_unit from (select l.item_sdb_id, l.list_price / l.quantity as price_per_unit, l.created_at from listings as l inner join purchases as p on l.purchase_id = p.id where l.item_sdb_id in (12345) and p.created_at … |
| | Hi all, I am trying output the following 1 user after validating data from a database and I have no output to the screen. I am not sure what is missing from query? Any help would be appreciated Thanks in advance David ------- Index.php ------ <?php session_start(); ob_start(); include_once ("includes/settings.php"); … |
| | Hello, When i try to insert some datas with python to MySQL database where the fourth column is a variable , (it depends on the variable "e0") , i get a message error here is the query syntax : `cur.execute('insert into suiviactuelms (modelsa,date,heure,%s) values (%s,%s,%s,%s);',(e0, modelidvar, cur_date, t, quantitevar))` and … |
| | hi, can anyone point out why is this script not working?? it does not inserting data into mysql.. here is the script: if ($_SERVER['REQUEST_METHOD'] == 'POST' && $_POST['form_name'] == 'signupform') { $newpassword = $_POST['password']; $confirmpassword = $_POST['confirmpassword']; $code = 'NA'; $active = '1'; if ($newpassword != $confirmpassword) { $error_message = … |
 | Is there a program for mac that i can use to connect to my mysql Database instead of opening Fire fox and going in and logging in??  |
| | I am trying display a link from my mysql database. I cannot get it done, It shows like this, for example **www.mywebsite.com/www.google.com** How can I get rid of my website url from this. this is my actual code in display.php <tr> <td> </td><td> </td><td align="right" valign="top"><b>Full Text Link :</b></td> <td align="left" valign="top"><?php …  |
| | I am trying to copy data from one database table to another. Below is the MySQL syntax I am working with: $array = []; $q1 = DB::inst()->select( "stu_term" ); foreach($q1 as $r1) { $array[] = $r1; } $bind = [ ":stuID" => $r1['stuID'],"termID" => $r1['termID'],":level" => $r1['level'] ]; $q3 = … |
 | I am using datepicker in my form for booking date field. when i pick a date it shown like this 11/13/2013 (MM/DD/YYYY). In mysql database i am using datetime Type. in mysql db always shows 0000-00-00 00:00:00. i want to change the date format. for example if i am choose … |
 | Hi I have a code that's been working for me when my server is Cpanel. but due to ceratin issues i need to transfer to godaddy. i'm using this code before. but now it's not working. i have run a test connection and im sure i have a connection to … |
| | Hi all, I am working on the following code. In the SQL query, I am currently calling all the data from the DB using * and all works fine. I would like to be selective and call the coloumns required i.e UserID, UserFullName, UserEmail, UserLastPassword, but when I do this … |
| | [CODE] SELECT count(*) FROM information_schema.`COLUMNS` C WHERE table_name = 'your_table_name' AND TABLE_SCHEMA = "your_db_name" [/CODE] TABLE_SCHEMA is required only if table name exists in more than one db |
| | I have the following sql query in vb.net and ms access , how do I create a table from the query result ? `SELECT 'Table1' AS [Table], SUM(a) - SUM(b) AS Result FROM table1 union all union all SELECT 'Table2' AS [Table], SUM(a) - SUM(b) AS Result FROM table2 I … |
| | Dear Sir, HTML file has following codes <!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=iso-8859-1" /> <title>Connection Checking</title> </head> <body> <center> <h1>Connection Checker</h1> <fieldset style=width:300px;background-color:#E0FFFF> <legend sytle=font-size:12;>Click Connect</legend> <form name="form1" action="connect.php" method="post"> <table> <tr><td></td><td align="center"><input type="submit" name="button1" value="Connect"> </td></tr> </table> </form> </fieldset> </center> …  |
| | i have this ajax script <script type="text/javascript"> var url = "GetAutoData.php?svreg="; // The server-side script function handleHttpResponse() { if (http.readyState == 4) { if(http.status==200) { var results=http.responseText; document.getElementById('divAutoInfo').innerHTML = results; } } } function requestAutoInfo() { var svreg = document.getElementById("getautomobile").value; http.open("GET", url + escape(svreg), true); http.onreadystatechange = handleHttpResponse; http.send(null); } … |
 | I have a search script that searches my database for a particular property address, but I have a problem displaying all the records ... my script is displaying only one record no matter how many records exist in the database with the same property address. I have two tables in … |
| | Hello, I have a little problem. This is what I want to achive: I have 2 mysql tables (categories, channels), the channel table has a cat_id in it. I want to update/edit a product and place it in another category but the code that I've made shows just one catedory … |
| | Hi hope somebody can help me. I was changing around some tables in a DB that was working fine.I don't know what I did but I deleted a table and wanted to recreate it a little different.Now I cannot do it, I get a message that the table already exists.So … |
 | I'm working on my capstone project. I really having a bad time thinking for the correct query for the search button function. VB.Net 2008 is my front end while I'm using MySQL as my back end database. Private Sub BtnSearch_Material_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BtnSearch_Material.Click Try … |
| | Hello, so I was trying few relations between tables and I noted an unexpected behaviour when using `group_concat()`. Let say I have three tables: fruits, fruitstock and fruitprices. These are the structures: create table fruits ( id tinyint unsigned not null auto_increment primary key, name varchar(50) not null, quality varchar(50) … |
The End.