11,093 Topics
 | |
| | okay.... I have been trying this stuff for a couple days and I think I have completely lost my way. I am trying to read data from an excel and import it into a MySQL DB. When I fetch the data from the cell, this is what I get.. >>> … |
| | Guys, I having problem converting the sql server function to mysql function. It work perfect at sql server now it now working at mysql. Please help.Thanks delimiter $$ CREATE FUNCTION SortingAlphanumeric(ColValue NVARCHAR(255)) RETURNS NVARCHAR(1000) BEGIN DECLARE p1 NVARCHAR(255); DECLARE p2 NVARCHAR(255); DECLARE p3 NVARCHAR(255); DECLARE p4 NVARCHAR(255); DECLARE Index1 TINYINT; … |
| | Ok, I'm developing a chat bot for a client. But I'm having a hard time figuring out the best way to do this. Because the bot isn't that big, I thought use a table with the phrase and the response. Then use LIKE. Not as easy as I thought though. …  |
| | I am currently working on a simple survey system for educational purposes. I know it is subject to SQL Injection, but I am new to PHP/MySQL and wanted to learn something basic so I have something to build upon later. Basically, I have an HTML form that processes the PHP …  |
| | Hi, hindi kruti 13 font is not working in form. I also installed again but getting same result. Need advice  |
| | ``this code keeps kicking out the error Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/a2595218/public_html/login.php on line 49 with the out-put " The username you enterted was not found " I should be seeing the error " You must active your acount to play. $form";" … |
| | Is there a way to use Order by RAND() for a query so that it returns a list of results and guarantees that adjacent values will be at least 'x' from each other, on either side? The results are all numbers, no strings. So if it returns 5 results r1 … |
| | Hi, I have two tables and they have one to many relationship.The two tables are fares and fare preferences.Now in fares table there is a unique user id and username and the user id is related to multiple preferences.Now I want to make a query that displays the username once … |
| | select name, REPLACE(format, ' – ', '/') as format, CAST(price AS UNSIGNED INTEGER) as price, CONCAT('http://www.example.com/',url_key) as url, id, delivery, sku from Database1 where delivery <> 'finished' INTO OUTFILE 'test.txt' FIELDS TERMINATED BY '\t'; this query returns empty result while select name, REPLACE(format, ' – ', '/') as format, CAST(price … |
| | Hi, I'm new to the forums and could really do with some help on the following... I've got a mysql query which i'm running to log a user in to a secure section of a website. I've successfully managed this on another website, however with the query i'm running it … |
| | Hi all, I have the following code to process through my requests, then use in a database. FIRST of all, I was wondering if i have it in the right order, and SECOND, if there are any other steps i could do to secure up my application. have a look, …  |
| | Hello forum! I was tinkering with a login script and I came accross the following error: Warning: mysql_result() expects parameter 1 to be resource, boolean given in /home/content/79/9398479/html/abyss/dio.php on line 60 //Code here: <?php $sqlError = 'We are experiencing very temporary downtime, please refresh or try again in 10 minutes.'; … |
| | Hello there, I've got a search box that finds the item that I look for but it doesn't display the id number when i put the mouse cursor on top on the item. instead of showing the id number it shows the variable ($id). Any idea why this is not … |
| | Hello! I am working on a server program that has a connection to a MySQL database. In one of my sql:s i need to use [URL="http://dev.mysql.com/doc/refman/5.0/en/user-variables.html"]User-Defined Variables[/URL] but i can't get it to work. The sql looks something like this: [ICODE]"SET @rank=0; SELECT id FROM (SELECT @rank:=@rank+1 AS rank ..."[/ICODE] …  |
| | Hi everybody, Can you please help me to fix this error: For exit press 'q' Please enter name :Jack London For exit press 'q' Please enter name :C.S. Lewis For exit press 'q' Please enter name :q Traceback (most recent call last): File "/home/serg/python/First/start/Q1.py", line 28, in <module> print row[0], …  |
| | please give the code for searching a value from mysql databse in jsp page?... i created **1.search jsp 2.searchAction.jsp 3.searchBean.java** and created **DBConnection.java** for db connection and i need to view the search result in new page which is **searchresult.page**  |
| | Hi I have a select statement that uses coalesce but I am wondering if there is a better way that it could be written?? I am trying to come up with a comparison table to show wich software has certain attributes. Many thanks Julie select a.title AS SOFTWARE, COALESCE((select 'Y' … |
| | #include <stdio.h> #include <mysql.h> #include <string.h> int main(int argc, char **argv) { MYSQL *conn; MYSQL_RES *result; MYSQL_ROW row; int num_fields; int i; char user_query[100]; char word[10]; printf("Enter word: "); scanf("%s", word); sprintf(user_query, "select * from english where word = %s", word); printf("%s\n", user_query); conn = mysql_init(NULL); mysql_real_connect(conn, "localhost", "root", "123", … |
| | Hi all, I have problem getting data from mysql table . What i am trying to do is that i want to get data from specific Category-id column and search a specific word or starting letter search from Name column , suppose this structure, -Database ---Table ------Category-id, Name My query … |
| | hello everyone, so i am new in sql and i would like some help. i wanna create a table with foreign key but it gives me an error which i can't fix. i wrote : foreign key(id_w) references waiter(id_w) waiter is the table in which id_w is a primary key … |
| | hi guys working on a little basic forum for collage but i keep getting this error kinda driving me crazy i know its something small but i cant spot it. any help would be great [B]Notice: Undefined index: topic_id in /users/2014/daf1/public_html/cs1109/lab18/showit.php on line 14 Warning: mysql_num_rows(): supplied argument is not … |
| | Hi I have 2 MYSQL servers One on a LAN and one on a dedicated server at an ISP. I cannot run normal replication as my ISP does not allow this. I have however written a script that will dump the data to a .sql file and ftp it to … |
| | Hi I have a MYSQL DB hosted on a Win 2003 server on my LAN and a Mysql DB on a dedicated (linux) server at our ISP. I would like to dump a few tables to a .sql file and ftp it to the server and then import the .sql … |
| | I'm getting an error when I run this. I'm sure it's simple. Any thoughts? Code: mysql_query("INSERT INTO leads `facility` = '{$facility}' , `leadAdded` = '{$today}' , `updatedBy` = '{$username}' , `manager` = '{$username}' , `name` = '{$_POST['name']}' , etc... ") or die(mysql_error()); Error: "You have an error in your SQL … |
| | hi, iam not sure if this is sql question or not. but i just download "sql developer". from oracle website. and i need help setting it up. i want to connection to my localhost (myphpadmin). how can i find these things. connection name: no idea username: using myphpadmin username which … |
| | hey guy, i need some help in reading a file across my network... this is what i did... $myFile = fopen("\\10.102.216.129\backup\Gatepass\Gate_Pass.csv",'r') or die("cannot connect"); $rows = file("$myFile")or die("cannot connect"); but each time i'm getting an error : failed to open stream: No such file or directory can someone help me  |
| | Hi everyone and thanks for reading. This problems been driving me nuts for the last day and I'm completely stuck. I made a dummy table of users to test out SQL connections but everytime I echo out the information, it keeps dropping the first record, and jumps straight to record … |
| | Hello, I know very little about programming, means what ever learn, i learnt it from the you tube, so in order to explain my problem i am writing every thing so when i get the reply i can understand it. first i try to download apache, mysql and phpmyadminn but …  |
 | What is wrong with this signup code? > process.php: <?php $host=""; // Host name $username=""; // Mysql username $password=""; // Mysql password $db_name=""; // Database name $tbl_name=""; // Table name // Connect to server and select database. mysql_connect("$host", "$username", "$password")or die("Cannot connect to server. Try again later."); mysql_select_db("$db_name")or die("Cannot connect … |
| | I've just started php and mysql.trying this code to check if mysql account is correct or not. <?php $usr=$_POST['username']; $psw=$_POST['passwd']; echo ' body tag, other things and a message: Logging in! '; echo $usr; $connection = myqsl_connect('localhost',$usr,$psw); if (!$connection){ die('<p>Stopped : ' . mysql_error()); echo '<br /><a href="index.html">Retry</a></p>'; } else … |
| | Hi all, How to display search results from MYSQL database in JSP page?? is it possibile to create gridview in jsp page? please help |
| | I've recently found that 1and1, my host, doesn't allow for remote access to MySQL databases and tables, and access is only possible via a slow and cumbersome web UI. Is there any workaround? I don't want to have to spend ten minutes browsing PHPMyAdmin every time I need to timestamp …  |
| | I have a problem with my site regularly exceeding Max User Connections. The limit from my hosting provider is 10 and I am regularly exceeding this amount for 1 database user. I'm unsure if this is due to a Coding Error / stuck or errored cfthread / malicious attack / … |
| | I am trying to set up a survey system. The survey questions themselves come from a database. I have created the page that pulls the questions from the mysql table into an html form but can't work out how to insert the responses into the database. I think i will … |
| | I have 2 tables one storing sizes the other company names. I would like to alter my existing query to give out different results from the table depending on the product type so at the moment I have and assigning the aliases accordingly ` SELECT MAX(#__xyz_sizes.size) AS MAX, MIN(#__xyz_sizes.size) AS … |
 | Hi. I have been working on a project that displays data in an XML file. (It's kind of like an API). I know how to parse XML with PHP, and how to make an XML file in PHP, but they don't work together. :) Basically, I have two files: `parse.php` … |
| | Hi Experts, below is my data file and I want to create form the basis of data returned by the following code. **getdata.php** <?php include ("dbConnect.php"); $examID = $_POST['examID']; $sql= mysql_query("select * from examsub where examID='1'); if(mysql_num_rows($sql)>0) { while($row=mysql_fetch_array($sql3)) { echo $row['examID'].$row['subject'].$row['thrymarks'].$row['pracmarks'].$row['subjectID']; } } ?> Below is the code from … |
| | I am using the followng code, to import csv into mysql. if($_POST['sform'] == "1") { $fname = $_FILES['upload']['name']; $chk_ext = explode(".",$fname); if(strtolower($chk_ext[1]) == "csv") { $filename = $_FILES['upload']['tmp_name']; $row = 1; if (($handle = fopen($filename, "r")) !== FALSE) { while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) { $row++; $data_entries[] … |
 | There are two tables - posts and comments: create table posts ( id integer not null primary key auto_increment, body text not null ); create table comments ( id integer not null primary key auto_increment, body text not null, post_id integer not null references posts(id) ); Now I want to … |
| | hello: I'm pulling mysql data and want to load into an array. I getting the data in like manner: $result = mysql_query("SELECT DISTINCT item2 FROM products"); echo "var option_array = new Array(num_of_cats);\n"; $count=1; echo"option_array[0] = new Array(\"Please Select a Merchandise\");"; while($row = mysql_fetch_array($result)) { echo"option_array[".$count."] = new Array(\"--select One--\",\"\",\"\");"; $count++; … |
| | kindly send me a vb / .net code for sync 2 mysql databases on localhost. I need only 1 way syncing. Thanks and Regards: Umair-Hassan |
| | Hi, i got tis trigger CREATE PROCEDURE updateG AFTER INSERT ON gnojidba FOR EACH ROW BEGIN DECLARE box int; SELECT quantity INTO box FROM stock WHERE name = NEW.name; IF (box >= NEW.Qty_value) THEN UPDATE stock SET quantity = (quantity-NEW.Qty_value) WHERE name = NEW.name; ELSE UPDATE 'Error!' SET x=1; END … |
| | i have a upload.php page where user can upload images to database. now i want to create gallery.php. where who ever is loged in can view all his photos from database. here is my struct for my gallery.php file gallery.php ______________________________________ (1)at top there is going to be menu and … |
| | Below is the code in which I am creating the list of URL s with the information of hotels in a city, the problem is when click on the URL no values are being displayed. please let me know how should i modify the code. <?php include ('connectdb.php'); $query = … |
| | I am, trying to write a PHP-Mysql code which fetches the important places in a city and displays the results as links, when i click on the city it should display all the details like name, place, address, phone number etc, but in this case results are not being shown. … |
| | Hi I am trying to create a stored procedure to list node titles with either a Y or a N if there is a coresponding record in another table, I am very new to stored procedures and am not sure how I get the data out and into a list, … |
| | Guys, need some guidance here... i have this php codes that copies all the value in a table to another table....some sort of table replication now, the problem is when i tried copying them, keep getting an error Database down **1054: Unknown column '124928F014007570' in 'where clause'...** the codes dataverification.php … |
| | hi All, I have two tables table-1:customeramount table-2:customerpurchaseamount table1 have customers bonus amount and table 2 i have customers purchase amount now i need to calculate balance bonus amount i tried with following query but It shows unexpected result , could any one guide me.. SELECT CM.`custid`, SUM(CM.`amount`) - SUM(CP.`Amount`) … |
| | I'm having trouble deleting this file... keep getting this error : Warning: unlink(Gate_pass.csv) [function.unlink]: Permission denied in C:\wamp\www\SVS\copydata.php on line 31 i search trough some sites, they said replace the $myFile with the orginal name Gate_pass.csv, but still getting the same error...can someone guide me on this matter. thank you … |
| | hi i trying to work on a lunch monthly order form.what i want to do is create a table just like a calendar with 30 cells label 1 to 30 days and in each cell the same food item with checkbox next to it generated from mysql. the user put … |
The End.