10,946 Topics
 | |
| | Right now Im having trouble getting data from a MySQL table and creating a new datatable to store this. I have a TreeView control that I am trying to dynamically add nodes to. The query that I have is returning the Attachments column of all rows where Owner = (parameter), … |
| | Hello, Please, if anyone knows how to pass a Javascript integer variable as a parameter into php mysql_query. Below gg1 is successfully converted to an integer (i checked it using some maths additions), and now i need to pass this value to BirdID. The last line with innerHTML works fine …  |
| | hi everyone, I am trying to create an inventory using php/mysql. However, I am using a webpage such that the viewer or user indicates or picks their choice by making continous selections on the spry menu. For example, if the first choice is "x", another menu appears with several options … |
| | |
| | i've anothe question, in here. I've made a registration form which 've region and zone with selection type. Main thing is wheni select the region, the zone list must come out as selection method from the DB. i've got the problem in php codes... help me outt...  |
| | i was just doing a simple thing in C#, just trying to put the values feeded in the text boxes in sql database. i am giving the code below the code executed perfectly but when i went to look into the table data there was no data inserted...... pls HELP...!!! … |
| | Would anybody happen to know which of these ways is the better way to run your queries?? Would it be better to have all your SELECT queries before the actual <html> code starts, or would it be just fine throughout the page in the <body> tags?? Is one slower than …  |
| | i want to insert new row in second table and this table connected to first table. How can i do that? |
| | I having a requirement to store the image in mysql and also retrive the image and display in the browser. Please help me. how to do |
| | hi how to combine three tables in a single query.please send a sample code thanks |
| | Bit of a php and sql issue, so thought I'd try here... for a registration form, I have created an sql file such as... [icode]firstname varchar(30) not null[/icode] ...etc...for all the fields, which I then import to the database. But then the form also has 15 checkboxes where the user … |
| | hi i want to join four tables.i used left join.thougn value are there in my db all the datas from seekers_qualification, seeker_target tables are getting displayed as Null.but there is no Sql error [code=sql]SELECT seekers.firstname, seekers.middlename, seekers.lastname, seekers.totalexperience, seekers.mobile, seekers_qualification.qualification, seeker_target.jobtitle, seeker_target.ann_salary, seeker_target.state, seeker_target.relocate FROM seekers LEFT JOIN ( SELECT … |
| | Dear JSP friend, I'm new in JSP. I would appreciate if someone can help me in creating inner joint 2 table from MySQL DB and display the result in JSP as report. Please help me.... |
| | I have the code below but how do I submit the form to a table? [CODE=php]<?php ////////////////////////////////////////// //// MySQL Database Connection /////////// ////////////////////////////////////////// $host = "localhost"; $user = "theflick_divx"; $db_name= "theflick_divx"; $pass= "password"; $conn = mysql_connect($host, $user, $pass) or die(mysql_error()); mysql_select_db($db_name, $conn) or die(mysql_error()); //DivX Table echo "<form id=\"divx\" name=\"divxsubmit\" … |
| | I have an invoice type of system and am having troubles trying to update an item.. I have 3 tables that deal with the orders.. Here they are: [code] CREATE TABLE `dw_orders` ( `order_id` INTEGER unsigned NOT NULL auto_increment, `customer_id` INTEGER unsigned NOT NULL, `order_date` DATETIME NOT NULL DEFAULT '0000-00-00 … |
| | I'm trying to figure out a way to get this if statement to work.. [code] $array = $_POST['field']; foreach ($array as $key => $value) { if ($value does not exist in database) { $query = "INSERT INTO..."; elseif ($value >= 1) { $query = "UPDATE... "; } else { $query … |
| | I'm looking to have people register times (like 2:34, 2:35.04, etc.) into my database. Do you use integers values or something else? Thanks! |
| | Hi Friends, I need your help. Whenever I do a query on localhost it retrieves a value, but when I try on live it shows an error? What could be the problem? |
| | Hi All, I need a hlp how to connect Mysql wit outlookexpress, so that i hav to retrive data from mysql to outlook express. Regards, Sugan |
| | You need a column type which will be able to store time and date in the range 1900-01-01 - 2199-12-31. Which column should we choose for this range ? |
| | Which keyword should be used in a SELECT statement to retrieve only parts of the result set? |
| | How upload file to mysql db in server and show to link in next page the uploaded files .. |
| | Your operating system and/or filesystem places a limit on the size of files. You need to create a table that is greater than the maximum file size. How can we resolve the problem ?  |
| | |
| | Hello Everybody In Php iam using the checkbox and it has been one month i can not solve it; when i select one checkbox from several ones , and i click send e-mail= it is sending to all e-mails; it is not sending to the selected checkbox ; I need … |
| | I am currently working on a small game, and couldn't get my head around if this could be done within mysql easily or even at all. Within the map there can be creatures in different areas, and to limit them, I used a pool to seed the creatures that could … |
| | Hi, I just started using phpMyAdmin. I need to create a table with all the dates of the year. The date will be the primary key and for each date there will be five time fields. Is there any way to do that with one SQL query? Thanks in advance. |
| | Hi, I have one query. Can we use empty resultset objetct for checking any condition. supose in my query: [B]rs= st.ExecuteQuery("select * from user where userid=1 and eventid =4");[/B] which result in [B]empty resultset [/B]. so can i use [B]rs[/B] for following use as: if(rs==null){ do some operation }else{ do … |
| | Hi, I get this error on red coloured line. "Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\wamp\www\.....". I use PHP 5.25, MySQL 5.51. [code] $sql="SELECT * FROM customer"; $run = mysql_query($sql); [COLOR="Red"] if (mysql_num_rows($run) > 0) {[/COLOR] .... } [/code] When there is record it …  |
| | On of my database stooped working. [QUOTE] mysql> check table invoice; +-------------------------------+-------+----------+----------------------------------------------------------------------+ | Table | Op | Msg_type | Msg_text | +-------------------------------+-------+----------+----------------------------------------------------------------------+ | billing_db.invoice | check | Error | Incorrect information in file: './billing_db/invoice.frm' | | billing_db.invoice | check | error | Corrupt | +-------------------------------+-------+----------+----------------------------------------------------------------------+ 2 rows in set (0.00 … |
| | i have just had to go into the backend of an old site to fix the mysql db as some had deleted the wrong db. i have got most of it working again now but did not know what this line of code is doing. [CODE]$sql = "SELECT id,thumb,image,designer,title,(total/freq) AS … |
| | [code=php] <?php $result = mysql_query("INSERT INTO ".UPREFIX."items` VALUES ( '', '".$item_name."', '".$item_descr."', '".$item_action."', '".$item_rarity."', '".$item_value."', '".$item_folder."', '".$item_image."', '".$item_cat_id."', '".$item_visibility."')"); ?> [/code] I didn't know if this would be php or MySQL. I'm getting returned the following error: You have an error in your SQL syntax; check the manual that corresponds … |
| | I've run the install for PHP 5.2.6 and been able to have PHP pages run successfully. My research has told me that PHP no longer includes the dll needed to connect to mySQL. I've run into a couple of problems on my system. [LIST=1] [*]Using phpinfo(), I can identify the … |
| | Hi, I have "Balance" table that is shown below. Table :Balance todaysDate/openBalance/closeBalance ------------ --------------- -------------- 2008-07-24 250000 100000 Above record will be inserted into next row as it is at 10:00pm. How do i do this? Thanks  |
| | have had to move some file across from one server to another and i am now getting access denied for user. it also says it could not connect to the server. i have changed the site path so it is now the address where the files have benn moved across … |
| | I am trying to find a way to calculate a running total of a field in my database, and while I have found a lot of good solutions, such as [URL="http://www.daniweb.com/forums/thread127644.html"]http://www.daniweb.com/forums/thread127644.html[/URL], they all require that I have a column which is ordered in the way that I want it to … |
| | I am stuck between deciding between MySql and Oracle, The reason being, I want to know how long it will take for MySql to reash the level of the current Oracle, if its gonna take more than a year....I guess Oracle is worth the money else not. Any views on … |
| | I have a query. Say in a notepad( D:\SQL.txt) I have 100 commands written in it UPDATE sal SET sal= sal+3000 select * from .................. insert into table tab_name values(........) insert into table tab_name values(........) insert into table tab_name values(........) .........so on Is there any SQL query like that if … |
| | Hello I need to get data from a database and write the db dump to a server as txt file any ideas? |
| | I've installed the plugin "WP Security Scan" on a fresh install of Wordpress 2.6 running on a Apache server at hostgator & the plugin says this about my table prefix. Your table prefix should not be wp_. Click here to change it. Change your database table prefix to mitigate zero-day … |
 | [B]Please excuse the length of this post:[/B] I'm trying to integrate OpenFire (XMPP Server) with a Joomla (CMS) user database. Openfire allows authentication against an external database by editing its configuration. In the configuration you have to supply the query that will retrieve the password from the external database, given … |
 | Hi, I have noticed that a lot of newbies using MySQL ODBC driver on their Windows often come across difficulties testing the connection despite that they have created the database on their servers. If you can put our members through in step wise fashions, please respond to this tread. It … |
| | Hi, How can i pick next or prevoius day in mysql? Any function like curdate() ? Thanks |
| | Hi, [inlinecode]Select closing From balance Where account_no = 12 Limit 1[/inlinecode] returns an error "You can't specify target table 'balance' for update in FROM clause" Where is mistake? Thanks [code] AFTER INSERT ON Close BEGIN Insert into balance (date, opening, account) Values (CURDATE(), (Select closing From balance Where account_no = … |
| | Hi, I have been trying to get MySQL to work on my apache server with PHP on it. My Apache version is 1.3.29 and my PHP version is 5.0.0RC2. I'm also running Windows XP Professional SP2 32 bit. I tried modifying the php.ini file to load the php_mysql.dll, but I … |
| | Problem: I have been unable to access encrypted information using ENCODE and DECODE. The information goes into the file OK but I cannot DECODE it. Below is the code.’ 1. The call from the program. [code]$result1=$dba_pm->selectencrypted($id); [/code] 2. the code in the class module [code] $sql="select DECODE('PM_Subject','2TRILFDA9Gioads*%'), DECODE('PM_Memo','2TRILFDA9Gioads*%') from personal_memo … |
| | first, i am sorry if i can't speak english well i have problem where i can't insert data to data base mySQl using vb2005. it is my simple code on vb. ---------------------------------- [code]Imports MySql.Data Imports MySql.Data.MySqlClient Public Class Form1 Dim xobjConnection As New MySqlConnection("Server=localhost;uid=root;pwd=;database=test1;") Dim xobjAdapter As New MySqlDataAdapter() Dim … |
 | Before I continue, quick explanation: product table pid (primary key), pdesc (Product discussion), and pquant (quantity of product). I then link it to sub_category which determines if it is where it falls (AKA SODIMM or DIMM). Now, I have duplicate product descriptions (160GB HD, for example.) We have 2.5 inch … |
| | Hi, Code below is wrong but i can't find the mistake. [code] Set @RecAdj:=(SELECT SUM(Paid) AS Total FROM payment WHERE PayDate = CURDATE()); if ISNULL(@RecAdj) set @RecAdj:= 0; end if; [/code] Or is there any other way? Thanks |
| | hi, i want to select from more than two table using a single mysql query.please tell me a example query/. thanks in advance |
The End.