10,946 Topics
 | |
| | table user->user_id, username, etc image->image_id, user_id, image, etc i am making a delete image page where user can del there image. i want to some how test image is the user who is loged in. 1st check user is loged in if(isset($_SESSION['username'])) 2nd check user hit sumbit button if($_SERVER['REQUEST_METHOD'] == … |
| | I want to create a project where there's a Stock Exchange ticker (you know the thing with green arrow up and red arrow down sliding from right to left). I was wondering if there's an open-source script where it takes data from a MYSQL select statement or simple logic to … |
| | Hi, i need help on updating data in mysql using JDBC since im using java.i want to send data from arraylist and it seems and error when i run it.below is my code for update. [CODE] private void update(ArrayList<String> list, int uid) { try { Connection con=null; Class.forName ("com.mysql.jdbc.Driver").newInstance (); …  |
| | Hello, I would like to retrieve the data from one of my database table. I have read many stuff about it and found out that I need to create a table model which is quite confusing to me. Basically my table consists of customer information. What is the best way … |
| | Hello, I have two tables one for the customer_records and one for the jobs. Both tables are linked together(both contains customerID and foreign key is set) I am trying to insert data into the job table by obtaining the customer ID that is given in the textbox. I have: INSERT … |
| | guy plz help me out with this. If i have a table, in the table is a column called veh_status, the row data will be varchar storing one or many comma seperated numbers so veh_status could be 1,2,3 each number represents an id to the relevant vehicle statuts name and …  |
| | Please help me create views and generat report using only MySQL manager thank you |
 | Hey, I am having a really annoying problem when trying to set up a foreign key in my database... I have two tables - Sell and Category I want the 'c_id' from the Category table to be the foreign key for 'p_id' in the Sell table. Both tables are InnoDB … |
| | Hi all I'm struggling with a MSSQL database that, ultimately, I want to get into MySQL, but for now I just want to import to a local server. I know nothing about MSSQL, but I am pretty familiar with MySQL. I have a .bak file exported from my current hosting …  |
| | Hello: I'm trying to get a record from mysql based on the query of another the queries separately: set @row_num = 0; SELECT @row_num := @row_num + 1 as row_number,queue_num,clientID,customerid, todays_date, request, details,status FROM queue_sys ORDER BY todays_date; outputs row_number queue_num clientID customerid todays_date request details status 1 14 44DWS … |
| | Below is my code which worked up until this morning. conn.Open if giving error 10060. I downloaded the latest odbc driver from MySql and that didn't help. Dim rst As ADODB.Recordset Dim conn As ADODB.Connection Dim gs_SQL As String Set rst = New ADODB.Recordset Set conn = New ADODB.Connection CheckADOConnection …  |
| | Hello, can anybody help me here? I am using mysql database and xampp server. Now, I made the database using my laptop computer and I have to distribute the database with its records to another laptop computer. The problem is when I tried to transfer the database file to the …  |
| | Hi, I have a problem in making a query.I have two tables patient and encounter. Patient has one to many relation with the encounter table. The encounter table has a field encounter_date. I want to make a search query in which I enter the date ranges and the query fetches … |
 | I'M just trying to work my way through the book "Head First SQL" but I can't seem to get it installed. I just need the simple DOS like pompt MySQL program to learn on. Here's what I'M getting when I try and install it. mysql-server-5.5-winx64:6 - Looking for valid template … |
| | Okay, my head is swimming as I've been trying to figure out what I'm doing wrong here. I am certain it's something stupid and I've tried different ways of putting it all in, but still no luck. Basically, I am trying to make it so I can put in our … |
 | Hello all, I'm hoping you can help me with my first search engine/join query. I have 3 tables with differing numbers of coulumns - clients, projects and tasks. Table "clients" with the columns "cid", "client" and "date" Table "projects" with the columns "pid", "cid", "projects" and "date" Table "tasks" with … |
 | 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 … |
| | Hi I'm getting **mysql_fetch_array() expects parameter 1 to be resource, boolean**, I check the white space and maybe some can tell me what I did so I can corrrect the mistake. Thanks <?php session_start(); header("Cache-control: private"); require_once ('../include/init.php'); include_once("../ckeditor/ckeditor.php");?> $page = $_GET['page']; $sqlcats="SELECT * FROM pages WHERE pagename = '".$page."'"; … |
| | 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 … |
| | I need to select a value on a MYSQL table using PHP. Basically I have PDATE column (which I need to make sure it's today's date) then STKNO column (if the value there is 11, then it's Price Index and if the value there is 10 then it's Weighted Index). … |
| | I am trying to build a query that will display the Amount of people that signed up in a certain month. I am adding the date_time to the database at the time someone signs up for a course. I want to display the months and total sign-ups for the month. …  |
| | 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?  |
| | Never had this problem before, and i am not sure how this happened. I got a Mysql sql database for my project. The id field is set as auto increment, which seems to function correctly. But on the form in my text field and datagrid i see a negative number, …  |
| | 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  |
 | hi, i posted this in the javascript forums but didn't get any replies, maybe this is a better place. i have a website for properties (rent, sell, etc), using php and mysql. i allow the admin to manage existing properties by selecting the property id from a dropdown that lists … |
 | i m working on a linux server and my part of the code is this- $post = mysql_real_escape_string($_POST['post']); echo $post; but my $post variable is not getting printed. and when i print $post variable without using mysql_real_escape_string function ,it is working. i.e. echo $post; its a weird problem . can …  |
| | 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 … |
| | Hi I keep getting Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in and dont know how to fix. I have 1 table and need to display two colums awnser here is the code can any one olease point me in the right direction. <?php $result = mysql_query("SELECT … |
| | 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 …  |
| | PHP, MySQL & ajax with data on default page default page is empty when page first load. how can i show data on default page? i mean when page first load i want to show all data then do the ajax after user select to filter Example is based off … |
| | 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 … |
| | Hello guys, I tought this is simple at a very 1st place... but I didn't manage to do it .. Anyone of you can give me an idea on how to do this... I've created a web apps that required authentication. and yeah ... oh the user setting section I …  |
| | 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 |
| | Hi, I am designing a system wherein a student can search projects based on technology, project type, location etc etc. The search form goes like this :- Project Type - HTML Select Option - Example:- Automobile, Manufacturing, Marketing, Communication Technology - Text Input Type - Example:- HTML, CSS, Java Starting … |
| | 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, … |
The End.