7,368 Topics
| |
Hi, I want to know how to search the inputs provided by the user in the form of checkboxes in a mysql database. <form> <input type="checkbox" name="interests" value="Food"> <input type="checkbox" name="interests" value="Movie"> <input type="checkbox" name="interests" value="Music"> <input type="checkbox" name="interests" value="Sports"> <input type="checkbox" name="interests" value="Reading"> </form> I have other input elements … | |
hello! i want to know about maximum mysql strength, that how many users can login and use database at same time. waht is the maximum size of table and maximu rows in table. what are the security risks and how can i overcome on security risks. and how can i … | |
How would I go about importing several CSV files into a single table? Any advice is greatly appreciated! | |
Hello, if you can help with a query about coursework here the condition Requirements: The base is WordPress. The aim is to survey. Each user registers and selects names of courses they want to attend. Explore the structure! A. For each course, how many people have written? 2. For each … | |
Hi all, I'm hoping someone here might be able to give me some advice. My current client has hired me to create a product importer for their shopping cart. The problem I am having is that there is a total of 7,154 products which need to be inserted into the … | |
Hello, I am familiar with PHP and MySQL and teaching myself how to create a login script, I am not sure if I am simple missing something or something is worong with the code. I am able to signup a user and submit the data to the MySQL table, It … | |
I know this is a simple quetsion but I am stuck. I need to create a view that displays the discount house price by 5%. CREATE VIEW v_hou_discount AS SELECT hou_price - (hou_price * '.05') as '5% Discount Price' from house; What am I doing wrong? | |
long blob size is way too small for me. how can i make it bigger??? i want thing when i making col image. i can set Attributes to or lenth/value? but i dont know what to type in help plz | |
| Good evening I'm running a tipping competition, and am hoping to make the updating slightly less tedious. The code currently reads as follows: <?php $query = " SELECT SUM(comptipsterselections.profit) as Profit, comptipsterselections.stable, comptipsterboard.link FROM comptipsterselections INNER JOIN comptipsterboard ON comptipsterselections.stable=comptipsterboard.stable WHERE comptipsterselections.comp = 'aintree 2010' GROUP BY comptipsterselections.stable, comptipsterboard.link ORDER … |
I'm trying to do a query that if mike isn't in the three highest bids for a keyword, then select the row(row that has been outbid). I tried below but i get no results, i should get rows with id 4 and 7. btw a keyword can be bidded on … | |
I would like to alter the example provided [URL="http://www.w3schools.com/php/php_ajax_database.asp"]here [/URL]so that there is a second dropdown input for 'Male/Female'. I know the example itself does not provide a 'Sex' field in the MySQL db, but let's just pretend it does. Furthermore, assume we have a new in out select for … | |
Hi There; I am learning how to establish a connection to mysql in c#. Here are my codes : using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using MySql.Data.MySqlClient; public partial class _06_web_form_elemanlari_08_button : System.Web.UI.Page { protected void connect(Object Sender, CommandEventArgs arguman) { try { MySqlConnection … | |
Hi, I have table (MyIsam) and want to set an index but fail to do so. Field : Varchar(10) Not Null Index Type : Unique Index Method : Hash Everytime I try, index method automatically assigned as BTree. Is this combination wrong for setting an index defined above? Thanks | |
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 … | |
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 … | |
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 … |
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 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 … | |
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 |
The End.