[mysql] Forum Topics

Hi, I have two databases (live and staging). Extra columns have been added to various tables within the staging database by another developer while they were extending the websites functionality. Now has come the time to put the new functionality live, which means taking the staging database schema, creating a …

Hi all, User table has an ipAddress column, & userid column as pk...maybe more than one user has the same ip! UserActivity table has userid as fk, and activityid which is fk to activity table So, I'm trying to get a count of how many rows in the user activity …

I was wondering if you guys can help me with this! I'm trying to display data on the items_Deltails.php page from classifieds1.php page using $_GET. I'm able display all data from [B]items[/B] table without any problem, however when i try to display the field pix from the [B]images[/B] table it …

I don't know what I'm doing wrong, but it won't update ever. I know all the variables work because I've posted them in several places, I've echoed them out, copied that and put it into the query and it's worked, and I've copied it to an entirely different page and …

Hi there, most interesting forum and I hope I can get some help here. I have 2 record sets, one which looks up a product by SKU and the table contains a field with "related SKU's" in a comma separated text field. I have created a Var with the "related …

I'm fairly new to PHP. Recently got a program to help me build a directory database for a werb client. I've been slowly customizing it to fit my design, but I can't get the search to behave the way I want it to. I need to search multiple fields in …

If I am violating a rule please delete this thread. I posted this question in the Linux forms. [url]http://www.daniweb.com/forums/thread298067.html[/url] I have a screwed MySql install in Linux, I assume someone will have the answer to this over here as the Linux forums seem dry.

Hi everyone. I want to add a advanced search function to a demo site I'm doing but have no idea where to begin on this. I'm using a MySQL Db for all the site and PHP to pull data from DB. Any suggestions are welcome. Regards

Hello everyone. I currently have a while loop that pulls all members to a page if the username begins with the selected letter. We have a lot of members now and the "usernames beginning with "a" are quite alot. So i need to be able to have a way to …

On average, I Have been doing quite well on my "TAXA" Wood Wood Knowledge Base website in getting many of the features coded and working --- more than this slow and amateur PHP coder that he could. I even got a search engine working yesterday, something I was not sure …

hi guys i need youre help i have a problem. im retrieving a records (20000+)from my database, $result = mysql_query("SELECT * FROM banco order by counterindex asc"); but it only display 200+ how can i display all my record by page? any help and suggestion is greatly appreciated.

Hi - I've got two (2) Tables: Old and New There are two Fields: ID and Status What I want to do is compare the ID fields between New and Old; if a specific ID is in the New table BUT NOT in the Old table, the I want to …

help guys. im having this error.. i don't know hat to do.. please help..thankss #Region "FillListView" Sub FillListview() lvList.Items.Clear() sqlQry = "SELECT * from book ORDER BY book_id ASC" Dim mycmd As New MySqlCommand(sqlQry, myConn) Dim dReader As MySqlDataReader = mycmd.ExecuteReader() <---- this is the error im getting it says …

Hi i have data in a mysql table which is about 70000 rows. In one column there is information that I would like to split into 2 rows. The information I want to send over to the other named row is nicely sat in brackets eg (18) . It is …

Hey i have upload an image on my database (mysql) and i want to retrieve the blob image on a specific size. until now with this code i can fully retrieve the image on the same dimensions that i have uploaded. The uploaded image has the dimensions 1024X728. I want …

dear all, i have 2 tables. first table named std_table : [CODE] | ID_std | std_1 | std_2 | std_3 | std_4 | std_5 | | 115 | A | B | A | C | D | [/CODE] then i gave another table named cpr_table : [CODE] | ID_cpr …

Hi I'd like to run a flashMovie in a .php page to the norm html. Fla's run ok, except they don't handle 3D object key command .swfs. [url]http://www.flashsandy.org/demos[/url] Click on 2nd image of a type of jet_copter Gavia AT-1008 as the best example of what is possible. Use keyboard arrows …

Hi, I have downloads that are available for users. They can click the links to download the file. Once they do this, I have a query that updates the number of downloads that file has received. I need to create a query that adds up all the rows Total Downloads. …

Hi, Trying to run this script via MySQL workbench. Can anyone see anything wrong with it? I suspect the foreign keys are not defined properly? Thanks [CODE]USE streamlibrary; DROP TABLE IF EXISTS streamlibrary.FileProperties ; CREATE TABLE IF NOT EXISTS streamlibrary.FileProperties( PK_fileName VARCHAR(50) NOT NULL, extension VARCHAR(4) NOT NULL , sizeMB …

I am trying to convert my CMS to SQLite for easy and quicker deploy-ability. Performance wise, I heard that SQLite might be the way to go. At any rate, I am having the hardest time with trying to convert my mysql database to a SQLite database. Having reviewed and downloaded …

hey guys, my simple program flows like this: a textbox where in you will input a keyword then when you press the 'go' button the data in the mysql database will be shown in the listview. im using mysql and vb .net. i've made the table with sample records in …

hello guys , this is my code which i am trying to use to sign up to test my database connection, so usually when i try to sign up it tells me there is something wrong on line 11 any way this is the code [CODE] <? $mysql_host = "mysql9.000webhost.com"; …

Hi to all, i am building a site with movie reviews.. due to the fact that a movie may have more than one category ex action, adventure, sci fi etc i ended up using a sinlge column to add all tha categories in comma delimited form.. 1st question. is the …

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 = …

Hi all I'm having a hard time selecting data from my database. What I want to do is when I view the page that allows me to edit a team name (team1 for instance) I want to list all the product types and then check the checkboxes of the product …

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 All i want a code that fetches a row in a sql database named student and display the result in a table format.........i am a newbie in php................please Help me

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 …

Really hope you can help with this one I have a problem whereby i cant get all my data (over 1million and different csv files) to map and import properly, so i thought it would be better to create new tables with all the information seperate (which i can do …

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 …

Hi there, I have a script in my intranet to which I have 100% rights to run through browser using exec(); passthru(); system(); etc with php. Now we use this to make automated backups per user database of certain systems connected. Very simple for the end-user after done working and …

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', …

Hello, How do i select or set the focus of a particular cell in a datagridview? Actually, this problem is simple but it is hard for me to solve it coz i'm only a beginner in c#. So here is my sample list of students as shown below: [COLOR="Green"]Ann[/COLOR] Antoinette …

I am currently producing a system in which I want the user to be able to select the product name from a drop-down menu and when selected I would like the barcode to appear in the barcode field. I would really appreciate any help, however great or small. The current …

cold fusion and mysql error: I think?I posted this in a MySQL forum, but was told they thought it might be a Cold Fusion error instead. Sometimes when I view my webpage, which has a search form on it and then search for records in my database, and I let …

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 all, Welcome to Study Group 13 (SG13) ^_^ We are a group of people – mostly students – who are self-learners. We share the study materials (obviously online materials), help each other in debugging our codes, and give advice regarding programming or studying problems. Q&A: Q: What programming languages …

I try to create a selection page, where different query are made, depending on selected checkboxes, and textboxes. It works for most the part but I a selection between zipcode ranges and year of birth range (between nbs_zip and nbs_zip2 and between nbs_contact_year and nbs_contact_year2). It works when I have …