10,940 Topics
 | |
| | Hi. I'm fiddling around with Python and MySql. I keep getting an error with this little script to try and read the rows in a table. The error is: TypeError: unsupported operand type(s) for +: 'int' and 'tuple' Here is the code snippet. Any help would be hugely appreciated [CODE]import … |
| | After hosting, i get this error:"Can't connect to MySQL server on 'localhost' (10061)" The code was working fine in my computer. I have hosted it in windows platform and i am using mysql and php. Here is my code for db connection $connection = mysql_connect(localhost,uname,pword) or die (mysql_error()); $db = …  |
| | hello....sir i have to access image from mysql database using java program and display it on the window please any one can tell me solution for this problem thanks in advance  |
| | Hi I am writing a program that will read the number of aborted_connects from the global variable... Below is the program code.... I am facing difficulty in displaying the result set [code=c] #include "stdafx.h" #include "mysql_connection.h" #include <cppconn/driver.h> #include <cppconn/resultset.h> #include <cppconn/exception.h> #include <cppconn/statement.h> #include <cppconn/prepared_statement.h> #include <iostream> using namespace … |
| | Hai, [B]Problem we are Facing Currently[/B]: Records getting inserted as only one during the process of updating the server. Previously, all the given records get inserted into the database table during the updation process. "updateprice" is the .mdb exists locally in the same folder where the calling file for updating … |
| | I have one table METER with the primary key serial, another table TC with the primary key tc, and a third table History with the primary consisting of the 2 foreign keys serial and tc along with week and create_date. Every TC has 0 or more METER's. How do I … |
| | Hello everyone. I have already read the "MySQL C API Programming" tutorial found at: zetcode.com/tutorials/mysqlcapitutorial. The problem is, the tutorial does not show how a person would display the results obtained from the [u]SELECT FROM[/u] statement in a char * format. Does anyone know if it is possible to convert … |
| | Hello I have to make a menu for a restaurant and I am kind of rookie at MySQL .. The menu has to be 8 columns wide ( 1column + 7 days ) and 8 rows in height . The problem is that it needs to be fully customisable , … |
 | If this should be posted in another area, such as, layout and design please let me know. A person who post's as Ardav on this board has gotten me this far. I have a relational database that pulls by brand and descriptive keyword. I wish to search and display on … |
| | Hello Daniweb.com, i hope you can help me, i am will create a dropdown navigation with php and mysql. I have some codes here, as you can look at. My dropdown navigation works. But it will not shows under the right navigations points. As you can se here on my …  |
| | Hi Normally I would use the mysql_fetch_array command to get vallues from a DB array to print in seperate tables like below: [code=php] echo "<table width=\"100%\" border=\"1\"body bgcolor=\"#ffffff\"align=\"center\"text=\"#ffffff\">"; echo "<th>THUMBNAIL</th><th>NAME</th><th>SIZE</th><th>LOCATION</th>"; while($r = mysql_fetch_array($TagSearch)) { $Code = $r["Code"]; $Name = $r["Name"]; $Size = $r["Size"]; $ImgPath = $r["ImgPath"]; $PurchaseDate = $r["PurchaseDate"]; $StartCycle …  |
| | hey guys what is wrong with my mysql_fetch_array here is my code : [CODE]<table width="400" border="0" align="center" cellpadding="3" cellspacing="0"> <tr> <td> <strong><h2>Welcome to Our Website</h2></strong> </td> </tr> </table> <br /> <? $mysql_host = "localhost"; $mysql_database = "members"; $tbl_name = "posts"; mysql_connect('localhost','admin','*******')or die("can not connnect to database"); mysql_select_db("$mysql_database")or die("sorry , can … |
| | hi guys , i wrote this code but when i try to open the page it says there is a syntax error on line 26 here is the code : [CODE]<table width="400" border="0" align="center" cellpadding="3" cellspacing="0"> <tr> <td> <strong><h2>Welcome to Our Website</h2></strong> </td> </tr> </table> <br /> <? $tbl_name = …  |
| | Hello everyone. I am creating a very large gaming server which will have thousands of individuals inserting data into an mysql database, most of which will be doing so simultaneously. I need desperate help in knowing what values (such as max_connections, etc) should be altered in my.ini (running a windows … |
| | Hello everyone. Does anyone know if a database has a maximum capacity to much data can be stored inside of it? Someone told me that the max info a given database can hold is 4 gigabytes. Also, if there IS maximum capacity per database, does anyone know how to INCREASE … |
| | Hi Everyone, I am currently trying to list a leaderboard for refferals. The table is set up with the following columns: id | refferer | user So obviously if someone reffers someone else they will be in a new row so there are multiple rows per person. I am trying … |
| | I am trying to get the following functionality working which requries some SQL. The need is to be able to produce a list of general staff who are not on holiday or on other sessions on a given day. I have two sql statements that will give me the information … |
| | I have a problem with this script. I would like to have the user input used in the query. I have been trying for days and numerous methods with no success. [code=php] <?php function new_module_menu() { $items = array(); $items['new_module/form'] = array( 'title' => t('My form'), 'page callback' => 'new_module_form', … |
| | hi , I want to split the field by comma and that should check the values in another table and display multiple values as given below. Here is my table format: Table1: ====== id : nos 1 12,13,14 2 14 3 14,12 Table2: ======= id : values 12 PHP 13 … |
| | Hi How can I transfer some tables created in a database in MySql on my computer to a friend's computer. I have sent to my friend the tables stored in C:\ProgramData\MySQL\MySQL Server 5.1\data\mydatabase folder via email. But when it is pasted in the same location in another computer, it isn't … |
| | Hi All. I am having some trouble with a script which allows a user to upload a photo. When the page first loads it checks if the user has reached their maximum photo capacity. If they have then it will redirect them to another page. If they can upload more … |
| | Hi all, I have a code which works fine. [code=php] <?php $db = mysql_connect("localhost","root",""); mysql_select_db("test",$db); $today = date("F j, Y, g:i a"); //echo $today;exit(); $file = "test.txt"; $fp = fopen($file, "r"); $data = fread($fp, filesize($file)); fclose($fp); $output = str_replace("\t|\t", "|", $data); $output = explode("\n", $output); foreach($output as $var) { //$categories_id … |
 | hello friends, I am try to get database values from while loop. but It gives me [B][COLOR="Red"]Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/COLOR] in /home/empower.md/www/index_ujbee_file_uploard.php on line 32[/B] here this is my code... [CODE] require "connect_ujbee_file_uploard.php"; require "todo.class_ujbee_file_uploard.php"; // Select all the todos, ordered by position: … |
| | Hi I am new to the database concept and I have to make a college project such as hospital management, Transport management system etc. in DBMS. Our college is teaching us MYSQL. Please can anyone advice me as what to use in making these projects. What database type to use … |
| | Dear Gurus, I am trying to insert information into three tables then send an email. The purpose of the code is to place uniform orders within a company with multiple stores. Each store must be able to place orders according to job function as well as order accessories available for … |
| | I have a table which holds the status of a machine in our factory. When the machine is running a line is written with a status of 1, when it stops it writes a status of 5 until a program records the error then it writes a line with a … |
| | hi, i have been working on creating a view in my database: [CODE] CREATE OR REPLACE VIEW productnotgot( ProductID, Product, ClientID, ClientFirstName, ClientLastName, Email1, Tel1, Email2, Tel2, ProductSold) AS SELECT Product2ID, 'Product2', c.ClientID, c.App1FirstName, c.App1LastName, c.App1Email, c.App1Phone, c.App2Email, c.App2Phone, p.clients_ClientID FROM clients c JOIN Product2 p on c.ClientID = p.clients_ClientID … |
| | hi i've to develope c/c++ console application that connects to a MySQL server and lists all hosts connected to it at that point in time. pls help me |
| | I am new, any one can tell me how can add image link in mysql after adding image link how can we display image. |
| | Hi, I am practicing MySQL JOINs and was hoping I could get some insight on how to do a particular problem. I am using the World database, it has a table called City with name, population, country code. It also has a table called Country, with Code and Name. What … |
The End.