11,093 Topics
 | |
| | Just need to know whether or not mysql server supports multiple strings of databases. Will the performance be hindered ? My company has a server that holds a few large databases for now (20GB and larger). In the near future more and more databases will be added. Adding more databases … |
| | Hi, Why not uploaded the data into db? Do not show any error. [CODE] string City = "Berlin"; string MyConString = "SERVER=localhost;" + "DATABASE=test;" + "UID=root;" + "PASSWORD=;"; MySqlConnection connection = new MySqlConnection(MyConString); MySqlCommand command = connection.CreateCommand(); command.CommandText = "insert into city(city) VALUES (@City)"; command.Parameters.Add(new MySqlParameter("@City", MySqlDbType.VarChar, 40)).Value = City; … |
| | I get these errors in a script of mine: [CODE]Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\www\vhosts\myradiostation\test.php on line 13[/CODE] and my original page (included in another page): [CODE] <?php //connect to mysql //change user and password to your mySQL name and password mysql_connect("localhost","root","PASSWORDREMOVED"); //select … |
| | Right now, I have a PHP script which - ideally - selects "posts" from a table, based whether or not the the time in the post is greater than the current time. [code]if(isset($_POST['id'])) { $id=addslashes($_POST['id']); $time=date("h:i:s"); $sql=mysql_query("SELECT * FROM public_wis WHERE mig_id='$id' AND time >= '$time'"); if(mysql_num_rows($sql)!=0) { while($rows=mysql_fetch_array($sql)) { …  |
| | Hi, I was wondering if it was possible to update the value of a mySQL cell by a method similar to using += in php code. For example, I'd like to do: [code] $sql = "UPDATE inventory WHERE userID = '$_SESSION[userID]' SET money+='$ssmoney'"; [/code] I know I can instead run … |
| | Hi There I'm a newcomer to php trying to develop a basic photo album. I have created a simple template in htm, and am trying to use php to show 15 thumbnails per page. However, I am experiencing the error message: "Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL … |
| | For some reason this is killing me, I am trying to update the field available to '-1' and don to '0' when the user submits the correct string into the input box, the thing I cant work out is why available wont update but don will the code is below … |
| | I have a small script that connects using ssh and opens a tunnel on port 3306. It works in the ipython interpreter if i type it in manually. However when I try to run the script from the interpreter or command line I get the error message "Can't connect to … |
 | First off I apologize for being a newbie to MySQL but one must learn somewhere... I am attempting to create a stored procedure that take input (primary key) and finds a field for that record and output to a variable... my code so far: [CODE]CREATE PROCEDURE sp_dealer_name( IN dealerID CHAR, … |
| | I have 2 tables 1st INVHD 2nd INVDT In INVHD I have following fields InvNo, InvDate,CustCd, CustName, TotalDisc (Discount on total Invoice), GrandTotal In INVDT I have following fields InvNo, RowNo,ItemCode, Qty, Rate, BaseVal, etc…. Now I need a query to be generated for The customer CustCd, CustName, Sum(totalDisc), Sum(GrandTotal) …  |
| | Hai, I had a database with tables id,name,email. ( Total about 25 thousand of rows in that database ) . I want to do mails to these email ids daily. Now in this condition so much email ids are repeating bcoz I converted a excel file to musql. It is … |
| | Hello, I have been checking for data integration / transfer programs able to help with Mysql. I have had some advice from some people but have not found the right software yet. The main feature would be to be able to migrate important quantities of contacts and data every day. … |
| | Hi people, Do you have any good sites for C++ MySQL.Especially how the 'query' part works in the C++. Thanks a lot!!! |
| | I am using this insert statement - [code=sql] INSERT INTO `crispwer_unipro`.`users` ( `user_id` , `user_name` , `password` , `email` , `activationkey` , `status` , `fname` , `lname` , `dob` , `gender` , `course_id` , `college_id` , `city_id` ) VALUES ( '2', 'k', 'k', 'kk@gmail.com', '', 'activated', 'keval', 'kothari', '2009-12-27', 'M', … |
| | Hello all! :) I dont know if this is the right forum..Here's part of my code: im using php to generate a wml page. It works fine. I want to populate a checkbox using data from mysql db. rand_keys() : store the ids in random order $row(): stores the ids … |
 | How do i start mysqlserver with option of --log-bin using phpmyadmin. Where do i set mysql server startup options in phpmyadmin. |
| | Hello all! :) I dont know if this is the right forum..Here's part of my code: im using php to generate a wml page. It works fine. I want to populate a checkbox using data from mysql db. rand_keys() : store the ids in random order $row(): stores the ids … |
| | Hi, everyone! I'm new to DaniWeb and also to PHP and MySQL. I have a script, previewfile.php, that extracts files of various file types (currently .doc, .docx, .xls, .xlsx, and .pdf) from a MySQL database and is supposed to display them to the user. I'm encountering difficulties in displaying the …  |
| | this is my code [code=php] $query="call call_history('','$real_sdate','$real_edate','$level','$userid',@_count,'0','10')"; //Listing the result $rs = mysqli_query($mysqli,$query); $rs = mysqli_query($mysqli,"SELECT @_count"); while($row = mysqli_fetch_assoc($rs)) { print_r $row; }[/code] always i get blank result or error mysqli_fetch_assoc() expects parameter 1 to be mysqli_result i want to do it with procedural mysqli.. not with oop mysqli..!! … |
| | I have been developing a MySQL database backup and restore appliation in windows forms. This application crates a dump of a mysql database at remote location and imports everything from the dump file back into local mysql database. MySQL database is located at the server which hosts my php website. … |
| | I am trying to accomplish two things with the code below: 1. Make the output display using an adjustable variable for the html table. output: ex: a variable of $tr=4 would display 4 rows of images, instead of a single row of images that I need to scroll across the … |
| | hi, i have this code that suppose to return 1 -> 5 rows from mysql table. when i run it, all i get is the first row from the result. if i'm remarking the code and placeing this line i see all the results [CODE]print_r($row);[/CODE] what am i doing wrong? … |
| | I need to download data automatically from a remote server. Its a CSV file, and i need to unzip it, and store the data in a mysql database that i created. There are multiple databases. The first section below is one of the databases that someone helped me with and … |
| | Hi, I have written a code that retrieves values from a MySql database and displays it in a table. So far so good. Then, what I want to do is have the user click on edit and the row that contains the record to be edited becomes editable boxes. I've … |
| | Hi, I have the query below with the data and query below. I want to select dates from Intable that are with a one month range of the Outtable dates and group them. That works fine But I also want to select values within these data ranges where valuein=valueout. The … |
| | Hi everyone, I hope someone can help me, here's my problem: I have a php script that retreive photos from a mysql db (and place it on my page into a loop in the right album section), I dont know if you understand what I mean but if you have … |
| | Hi this is my table structure. I need one result from this. There is a field named LAPeriodStart in this table. If LAPeriodStart date is 2009-01-05 Site Id is 4067 Today Date is 2009-12-07 1. Now I need to calculate LAPeriodStart Month from the date(2009-01-05) How its Possiblle? 2. If … |
 | Want to click on an image from a list and simply set that filename in a field in a mysql database. I read the tutorials and have tried several different ways to pass the variable on the url and then update with a second php page. Hi my second question … |
| | Hello all, I am at it again this time incorporating MySQL database into C# code using Visual Studio 2008 first off the textboxes are databinded using details view... the issue at the moment is trying to not make bulky code and compare the value of txtDealName.text and mtxtDealNum2.text to what … |
 | Before I begin i'm sorry if this is a noobish question. Basically I'm trying to import a 'forum.sql' file into mysql so that I can access and manipulate it through a Java servlet. The path to the sql dump file is /home/floyd/Desktop/forum/forum.sql so i open a terminal window, cd into … |
| | I just started using both PHP and MYSQL and i have this SQL statement that get record from three tables ie [CODE]Select name,age, datejoind, active, avrage_time_in,avreagework_duration from Personalrecord Union Activestaff Union Timetable[/CODE] but i need to be able to get a the list of Returnd field name into a PHP … |
| | Hi guys, I'm not sure if this is the right category for this inquiry. I have my phpmyadmin working for my existing database but I couldn't make it to work. The site is running in xammp localhost. I have the data in place . I get the database to run … |
| | I have a form where users enter data. If no data is entered in a given field my code still inserts a 0 into the MySQL database even though I allow Null values. This is a problem for two reasons. In some of my fields I'm using TINY INTEGER as … |
| | I have this database project due Monday and I am trying to create a PHP script to do a simple search query in the MySQL database. This is what I have... [B]search.html[/B] [code] <html> <head> <title>NOMO Auto Group Inventory Search</title> </head> <body> <h2>NOMO Auto Group Inventory Search</h2> <form action="results.php" method="post"> … |
| | |
| | Is it possible to get the columns name from a select statement involving more than two table. eg [CODE]SELECT a.field1, a.field2,b.field3,c.field4 FROM a,b,c WHERE a.field1 = b.field1 and a.field1 = c.field1 [/CODE] is there a mysql statement that returns a record set containing field1, field2, field3, field4 that can be … |
| | This is my database it executes with no error. [CODE]--Kudler Fine Food Database Create Database [VALMKudler_Fine_Foods] On Primary (NAME=VALM_KudlerDB, FileName="C:\POS410\VALM_KudlerDB_dat.mdf", SIZE=10MB, MAXSIZE=100MB, FILEGROWTH=10%) --Kudler Fine Foods LOG ON (NAME="VALM_KudlerDB_log", FILENAME="C:\POS410\VALM_KudlerDB_log.Idf", SIZE=5MB, MAXSIZE=100MB, FILEGROWTH=20%)[/CODE] This is my table it executes with no problems [CODE]--Job Tittle Table CREATE TABLE [VALMKudler_Fine_Foods].dbo.tbljobtitle ( jobID … |
 | I've been trying to learn how to program for several years now. I've struggled with everything from C++, C#, to Python, but never got passed simple DOS text based screen programs that were very short. I'M now 24 and I work in a factory. I would love to find a … |
| | hi, i am working on a project where i have to display an image gallery. All the images are stored in mysql and i have to display them and related info one by one using NEXT and PREV buttons. can anyone help me with this. thanx in advance. |
| | I have a mysql table with the following data in it: user_id score 1234 28 4654 -15 5986 15 3657 10 If i have PHP select the score column for user 5986 how could i then have PHP calculate the next highest score in the MySQL table ? |
| | cud ny1 plz tell me,how 2 connect to mysql via VB6.0 without d help of mysql connector as 1 user said. i don't think there is ny need of such in VB6.0 i just wanna know how to set connection string through coding an fire sql query in VB its …  |
| | Hello, We are currently using a Mysql database: we would like to change. Now, we'd like to use Mssql. Only problem is that most of the data and other information are on Mysql. Can you help us with this? Thanks a lot for your help. |
| | How to write the query to [B]insert a picture[/B] to mysql data field which is declared as [B]BLOB.[/B] I would like to knw the[B] pure sql query[/B] with out any involvement of a programing language.(If there is such) Thankx in advance. |
| | Hi Trying to pull this off in one query but my and right & left joining is giving me unusual results... i have a 'product_style' table, an 'product_item' table, an 'addto' table and a 'removefrom' table - im monitoring when products are added/removed to/from the cart... and want to pull … |
| | Much is written in various how-to sites about next and previous page navigation utilizing Limit to retrieve multiple rows of data and display them in chunks of 10 rows to a PHP page, as an example. This problem is subtly different. For the site I am programming, all of the … |
| | Hi! I am trying to implement a server-cgi with C++, but I don't know which is the best way for the cgi to communicate with the mysql server. In the mysql web, I have seen that there are "connectors", but I don't really know which is their functionallity. Should I … |
| | Hi! I am trying to implement a server-cgi with C++, but I don't know which is the best way for the cgi to communicate with the mysql server. In the mysql web, I have seen that there are "connectors", but I don't really know which is their functionallity. Should I … |
| | I have searched the forums here and while there are similar problems going around, mine is different from what I've seen. First, I will say that I have yet to do sessions OR injection protection. This is a project for school so those things will come last; the most important …  |
| | hey guys, I have a table "items" from which I need to select items using two drop down lists ,the 1 st drop down list works, the second one doesn't fetch the parameter passed, when used item_id=? <sql:param value="${param.item_Id}"/> ?? ,but when I give a value it works..... I'm using … |
 | Hi People I would like to get an sql statement that uses LIMIT and OFFSET and then sorts the results in ASC or DESC order through the user of ORDER BY, something like this: [code] SELECT * FROM table LIMIT 10 OFFSET 0 ORDER BY DESC [/code] Note: that does … |
The End.