11,093 Topics
 | |
| | oops!! used the code tag wrongly!! sorry. |
| | hey guys, I have made a database using mysql and php. I have also put in a search option. But what i want is that if the item which is being searched for is not in the databse it should return "Database Not Found". I am not able to execute … |
| | hey guys, I have made a database using mysql and i am showing it on the browser using php. now the problem is that i only want those columns to display which have entries or some data in them for a particular row. Suppose that if there is one entry …  |
 | Hi all! I am trying to connect to a remote MySQL database. This database is located on my LAN at the address 192.168.1.2. I am using MySQL Connector/ODBC 3.51 (MyODBC 3.51) for the connection. The connection string that I am using is the following- Driver={MySQL ODBC 3.51 Driver};Server=192.168.1.2;Database=mydb;User=root; Password=;Option=3; The … |
| | Hello, I am a graphic designer who does some web design on the side. The store I work at had a website that the boss wanted transferred to a different host. So I downloaded it off the server and uploaded it onto a new one. I knew that I was …  |
| | how may i create stored function in phpmyadmin simple one is create but one i try to use a variable in function it is mysql manual error. can anyone help me. |
| | WHO CAN CRACK THIS ONE FOR ME. I have never figured out how to do this. About 2 or 3 years ago, I tried varios methonds which I found on the net. When adding data to a mysql database, I'l like the text to be the way, including the line … |
| | Hi. Thanks for looking. I am setting up a dedicated server for the first time to host a site and I have the FTP accounts set up, the PHP and MySQL packages installed. MySQL administrator GUI tool installed but I cannot get phpMyAdmin to work. I have unzipped it and … |
| | Hi, maybe my problem has a very simple solution, but I'm going crazy to find a way to do that. I have a single table that looks like this: Number | Value (both string and numeric) 123 | foobar 123 | 23846 123 | foobar 345 | 34523 345 | … |
| | |
 | hello friends.... I am PHP programmer using mysql as my database... Now it is the time to make fast all my queries ,which im using in my programming... I heard about indexing... Tel me what is indexing,how to put indexing to my table... mainly what are the advantages and disadvantages...or … |
| | Using MySQL..I have a stored procedure that contains an input parameter defined as a text value. A list of ids are passed in through that parameter... the input parameter is used in the where clause of a select within the stored procedure, however, currently I have this created as a … |
| | Hey guys, I need a "little" help with a query. I'm trying to pull information regarding referrals from search engines which grab the keywords. For example, two people search for [b]foobar[/b] and another searches for [b]barfoo[/b]. I would need the results returned similar to this: [code] Hits | Page URL … |
| | Hi All, I am using VB6 with mysql database recently. But I am having problem with showing the text type of mysql field value in a Msflexgrid. Msflexgrid1.TextMatrix(i, 3) = "" & rdoRS.rdoColumns("products_publisher").Value This line gives error message. Anybody could help me? Many thanks. Tomii |
| | Hi Guys, Im having problems with some mysql select statements. I have a database containing 7 tables in the following format: [U] Adverts [/U] Field Type Null Default advert_id int(11) No 0 frequency int(11) No 0 [U]keywords[/U] Field Type Null Default key_id int(11) No 0 keyword varchar(20) No [U]keywords_to_adverts[/U] Field … |
| | Dear folk, what should I use for [COLOR="Red"]Price[/COLOR] Field in Data base I have used BigInt But I know I could do it with Decimal , I ned to do it without any Limitation of the size of the digits and the numbers after dot ( . ) so what … |
| | Hi everyone, well, my problem would be:There is a database server which contains no databases. So there is nothing to connect to (as it is needed by the DriverManager.getConnection instruction). How can I create a new database under these circumstances? Thanks, Chaster |
| | Hi there. I need assistance with, I guess, a PHP date function. There is a way I can figure this, but its really not reliable and I guess it won't even work. So all you guru's, here is what I need to achieve; I am just writing a simple reservation … |
| | I was wondering how to store this date into the database: Friday, August 28, 2015 and this time: 8:00PM I have one field that collects the date and another for the time.. Im looking to store them in this format, 0000-00-00 00:00:00.. Is there some way to turn this date …  |
| | 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? |
| | |
| | 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 … |
The End.