10,940 Topics
 | |
| | Please let em know if this is valid....... I am trying to run mysql from my shell script by passign a parameter.the sql(script.sql) is in directory $mydir and the parameter is $date and trying to run it this way: un="username" pd="PASSWORD " dbname="dbname" result = `mysql($un,$pd,$dbname,$mydir,"script.sql",$date)` I am trying to … |
| | Hello everyone. I already know the C code required to use SQL statements within C++. Using mysql_real_connect, I was able to establish a connection to a remote MySQL server. The problem is, even though mysql_real_connect did not RETURN NULL, (meaning that a connection to the mysql server was established) I … |
| | Hello everyone. I have tried to fully install MySQL on Windows Server 2003 for a few days now, with no success. There are two things stopping me from completing the install: 1) I forgot the initial password that was used for the root user 2) Every time I get to … |
| | Hey there everybody! Me and a couple of others are currently making a CMS but we got a problem :( Here is the code: [code=php] function ImportSQL() { $conn = mysql_connect($_POST['host'] . ":" . $_POST['port'], $_POST['user'], $_POST['pass']); mysql_select_db($_POST['vision_db'], $conn); $db_content = @file_get_contents("../sql/Database.sql"); $query = mysql_query($db_content); if(!$query){ return mysql_error(); }else{ return …  |
| | Example of GRAND TOTAL, TOTAL1 TOTAL2 TOTAL 3 SUBTOTAL 1, SUBTOTAL 2 SUBTOTAL 3 How many chairs we have in our village? Grand total chairs in houses =total chair in house A + total chair in house B Total chair in house A = TOTAL CHAIR IN ROOM 1 + … |
| | Hey guys. You guys were awesome in helping me solve my last issue. I was wondering if I couldn't pick your brains again? I've been able to troubleshoot and solve most of my issues myself, but am a bit confused on this one. I found a similar thread to my … |
| | I have created a website in Dreamweaver CS3 that includes mySQL databases. I have been using xampp, and have a test server running on my local machine. Everything seems to be working fine, and now would like to put the website online. I'm not sure how exactly to do that. … |
| | I want to Learn PHP and MySQL, plz tell me from where I have to start and is there any good software for php and mysql sites creation ? |
| | I have a table with information about the type of scrap generated on a bag making machine. Every time scrap in generated on either side of the machine (left or right, there are 2 packing machines on the one bag maker) a line is added to the table with the … |
| | 1) Simplicity. Mysqli is object oriented. It's simple to use. You create an object and pass your database information to the constructor. And you're all set. [CODE] $mysqli = new Mysqli("localhost", "username", "password", "database"); $query = $mysqli->query("YOUR QUERY"); $row = $query->fetch_object(); echo $row->result; [/CODE] 2) Speed. Mysqli is newer and …  |
| | Let's say a user submitted some information through a form into a MySQL database. The data was timestamped. The user is given a certain number of days to submit an additional chunk of data into the database. If he doesn't submit it by the required date, an email has to … |
| | I am using VB to query a MySQl database and populate an Excel spreadsheet. All is working well, but now I would like to start distributing the spreadsheet shroughout the company and cannot protect it. If I protect the spreadsheet the VB cannot add the MySQL data, so I added …  |
| | If I want to search record by age like (30 to 35) just like dating script but I will not use in dating site, I have my school website and I just want to display record by age but If I want to display age between 14 to 17 kindly … |
| | hello dear all, need some advice and help here.PLEASE HELP.. i use jsp page to input same value to mysql table. i have several tables inputed the same way(use jsp). Then, i show this table with jsp page (this is the same data i inputed to mysql tables).i named it … |
| | Can someone look at this and tell my why it's not working like it should? It gets the data from the database fine, just wont post to search.php [CODE]<?php //connect to your database ** EDIT REQUIRED HERE ** mysql_connect("localhost","root",""); //(host, username, password) //specify database ** EDIT REQUIRED HERE ** mysql_select_db("test1") … |
| | I am trying to Add rows to my table through DOM. I have two drop downs and one text field in one row. One drop down is populated from database and when the second drop down is populated through Ajax. As far as one row is concerned it is doing … |
| | Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\wamp\www\registration\login.php on line 19 is the error i get when i run the below code i cant figure out what is wrong with it. :( [CODE]<?php $username = $_POST ['username']; $password = $_POST ['password']; if ($username&&$password){ $connect = mysql_connect("localhost","root","") … |
| | Hi again I'm still having problems with PHP/MySQL Warning messages, even when using mysql_real_escape_string(). The offending string is: [CODE][25:64] And the true servants of the Gracious God are those who walk on the earth humbly and when the ignorant address them, they avoid them gracefully by saying, 'Peace!'[/CODE] If I … |
| | I would like to save to database but not file. please help me and show me how i can change from file to databasetables. [CODE]****users***** <?php function saveUsers($onlineusers_file){ $file_save=fopen("onlineusers_".$_POST… flock($file_save,LOCK_EX); for($line=0;$line<count($onlineusers_f… fputs($file_save,$onlineusers_file[$li… }; flock($file_save,LOCK_UN); fclose($file_save); } $onlineusers_file=file("onlineusers_".… if (isset($_POST['user'],$_POST['oper'])){ $user=$_POST['user']; $oper=$_POST['oper']; $userexist=in_array($user,$onlineusers… if ($userexist)$userindex=array_search($use… if($oper=="signin" && $userexist==false){ $onlineusers_file[]=$user; saveUsers($onlineusers_file); echo … |
| | I have tbl 1 id_column(1 2 3 ) tbl 2 id_column(1 1 1 2 2 3 3 3) I need result tbl2 join with tbl 1 values (3 3 3) Thank you in advance i'm strugling from two days for this. |
| | Good day everyone! Anybody could give me script for uploading or inserting image into database and how to retrieve it and print it to browser Any help would be appreciated. Thank you in advance. roland |
| | I need to create a row and its content to be unchangeable and undeleteable, as a secure way to ensure that the administrator will always have access to the website. Does anyone have any idea how to do this? A Google Search gave no results, but perhaps someone knows how …  |
| | Hello friends, Well i have two table one is used for user information while registeration and another table is only used for users profile image. In member list page i want to show users name , location and profile image. I m able to show a name and location but … |
| | Hi All, I am building quite a complex CMS (mysql & php) and am wondering what the best approach to inserting data into multiple tables at once is. I have about 10 tables i need up update with user data, some of them linked by keys, others not. I have …  |
| | Hello all, I have spent a good few days looking over daniweb trying to get the right answer, But I am yet to find what I am looking for. I have successfully upload my image to a folder store and named my uploaded image. The path and file name is … |
| | hi there,i have problem with insert image into mysql.... is there any function that can be use ??? please help me :?: |
| | I understand after running now() function in an SQL statement, I will get current date/time like following in mysql browser: '2010-08-04 17:01:06' If I want the returned value to be '2010-08-04 00:00:00'. How can I do? Thanks. |
| | To view this tutorial with notes at [URL="http://www.effectivewebdesign.co.nz/tutorial.php"]http://www.effectivewebdesign.co.nz/tutorial.php[/URL] yes I am aware this is more php than mysql. howerver I get asked how to do it so often I thought I'd post it here aswell :) |
| | this is my table structure [CODE]CREATE TABLE IF NOT EXISTS `test` ( `id` int(11) DEFAULT NULL, `disable` timestamp NULL DEFAULT NULL, UNIQUE KEY `id` (`id`,`disable`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;[/CODE] Assume values as [CODE]INSERT INTO `test` (`id`, `disable`) VALUES (1, NULL), (2, '2010-07-27 15:52:20'), (3, '2010-08-03 00:00:00'), (5, '2010-07-28 15:53:39'), … |
| | I have a dedicated server that I wanted to look at moving to cloud based computing, so I hopped on over to rackspace and setup a cloud with 2gb of ram. I then setup mysql and had it replicate my dedicated server so I could keep the data updated and … |
The End.