10,946 Topics
 | |
| | Hello I want to display random images stored in folder.and their name stored in mysql. Please Help me. Thanks  |
 | In a Visual Basic 2008 windows application + MySQL database. I have a MaskedEdit field used for phone numbers, the mask is (###) ### - #### In my [COLOR="Green"]Table1[/COLOR] , i have a record with two fields: 1. Field Name (string 15)Data "andre" 2. Field Phonenr (string 25)Data " " … |
| | Training management system: Hi, I want to build a webpage in a plain HTML, JavaScript, CSS. In this webpage, I want to build a TRAINING MANAGEMENT SYSTEM. Requirements: 1. A form which should take the trainee's unique id and process it. If the entered trainee ID matches with any of …  |
| | How would I build a web page similar to an online banking page that has a running account balance, only I want to make each line editable. If a specific line was edited the total would then change up through the top. (transactions are sorted by date order) How do …  |
| | I have to columns Positive and Negative. i use this as a rating system. e.g. For example if Positive is value 2 and Negative is value 1 and i subtract. Then the total would be 1. i have a variable $order. if i did $order="(Positive-Negative)"; I now that is incorrect. … |
| | Hello, I am having a little trouble getting the variable $total to insert into mysql table. I used javascript to get the total that is in the input box. Any help is very much appreciative. Here is site: [url]http://illcomputers.comyr.com/custom.php[/url] Thank You Snippets of Code JavaScript Code [CODE] var mainitems = … |
| | [URL="http://shop.ccs.com/guys.shirts/category/"]ccs [/URL] I want to use a similar approach to display my MYsql database and organize it, but i'm unsure of how to go about it. I want to have drop down boxes or use the nav ones i already have [URL="http://www.casingit.com"]here [/URL](at the top) to sort different types of … |
| | Hello everybody I have an excel data sheet. there is 6 column with thousand data. I want to keep those data in mysql. How can I do that. In short how can I convert excel data to mysql without spending single penny. I use [B]excel 2010[/B], xampp server  |
| | Hello, I am trying to use the mysql_real_escape_string() function, but I can't seem to use it without losing the content of the variable. When I use [code] $act="It's now or never" $act=mysql_real_escape_string($act);{ [/code] then attempt to insert the value of $act--it comes out null. I have established the database connection, … |
| | Hi, i'm trying store an image in my sql database . i 'm using java to manipulate it .i 'm able to manage the image store in the database,but i don't know how to retrieve it back to my user interface. can some one help me to do this. [code]//sample … |
 | I'm trying to write this query, but I don't know how to go about it. Say you have a table with a bunch of listings, with multiple listings per company. You have a status field in the table that is either complete or active. What I want to do is …  |
 | I'M new to SQL and I'M reading the book "Simply SQL". I'M running Ubuntu Linux and I downloaded MySQL Workbench. I also downloaded the source .sql files for the book. I need some help getting started. How do I get the files into Workbench so I can follow along with … |
| | Ok I am still unable to create a foreign key restraint in my database. I know I posted this in another post, but after 3 or 4 days with no responses, I wanted to reword and properly explain my problem. I executed two show create table commands for my two … |
| | can anyone generate a query for me. Lets say i have a table [CODE] sales(saleID, date_of_sales, customerID, itemID, saleprice)[/CODE] [LIST] [*]date_of_sales is the datetime field which stores the time of the sale. [*] customerID is self exlpaining tells to whom item was sold. [*] itemID is ID of the item … |
| | anyone know how to call the choices ChoiceGroup who have been selected from data taken from MySQL? help please ... I've done this.. and the question is..how to call options that have been selected ..??  |
| | I just got a new book on sql. So what software do I need to get started to and play around with these statements and load the querys supplied by the book. Thanks. By the way I'M running Ubuntu Linux |
 | A very simple MySQL database class. [B]Usage:[/B] [CODE]// connect $config = array( 'host' => $host, 'user' => $user, 'password' => $password, 'database' => $database); $DB = Database_MySQL::getInstance($config); // set query $DB->query("select * from table1 where col1 = %d and col2 = '%s' LIMIT 1", 5, 'a'); // get rows $rows … |
| | First of all, thank you for taking the time to read my question. With the following code, what I have done is make a database in MySQL and created a table using python. I then imported an excel document with three columns. These three colums are: 1. POS_TYPE which is … |
| | Hi everyone. I am trying to make an if statment that will show text saying create an album if the user has no albums but if they have one or more albums then it will show their albums. Now I have sorted out everything but when I get to the … |
| | hi .. i am working on chat system ..there are two types of user one are register and other are guest and i have to add guest user..in to database as temporary so they can chat with each other the problem i am facing is with there names i want … |
| | Hello anybody! I have some idea and I don’t know if it will work. I am planning to make a user management system using the mysql database but the problem is I don't know where to start because in MySQL database the password is encrypted with password() function and it … |
| | Hi Everyone. Could anyone give me some pointers in creating a PHP, MySQL ShortCode system. I want to create a system where a user can SMS a keyword to a short code SMS number. [B]Example:[/B] [COLOR="Red"]SMS pizza to 33333[/COLOR]. Then the server checks pizza in MySQL DB and replies with … |
| | I have 2 forms, Form5 and Form4. Form5 has a datagridview with customer info, you double click the row header and that opens up form4, inserts customer info into texboxs on form4 My problem is when you click customer 1 or customer 2 the textboxes always fill with customer1. the …  |
| | Hi, I have been working with php for awhile now, but I am bum fuzzled on this one: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/xxxxx/public_html/xxxxx/index.php on line 5 adminlogin.php <?php include "mysql.php"; $res=mysql_query("select * from pagelay"); $mygrow = mysql_fetch_array($res); ?> now the other page …  |
| | This might be a stupid question, as I am a complete beginner in the world of AJAX/Javascript. However, I am trying to build a website using Ajax combined with PHP/MySQL. The issue I have at hand is that the PHP variables and functions that I have included in the header.php … |
| | help anyone! i can add records to mysql database but it won't appear in the listview. can you check out what's wrong with my code. pleeaaasssee.. help needed badly.. :( [CODE] Imports System Imports System.Windows.Forms Imports MySql.Data.MySqlClient Public Class bookForm Dim myconn As New MySqlConnection Dim sqlQry As String = … |
| | Ok I am very new to the php mysql world so please bare with me. I have set up a database for an apartment complex with a table containing the following: [code] create table apartments (apt_num int not null, available varchar(5) not null, beds int not null, baths int not …  |
 | Good morning, i know this was probably asked before, but im kinda in a jam. i have a database where it has a date field and a time field. i want to use a radio button to filter the fields. Say i have 3 radio buttons, the first one only … |
| | On my search result page, I wanted to search for "Nintendo DS Lite - Pink" I used following code: Ex: [code] $search_text = "Nintendo DS Lite Pink"; $kt=split(" ",$search_text);//Breaking the string to array of words // Now let us generate the sql while(list($key,$val)=each($kt)) { if($val<>" " and strlen($val) > 0) … |
| | Hello! I have written this dialog to connect to a MySQL database. It asks for the Username and Password, and it should use this data to connect to the database. [CODE]#! /usr/bin/env python # pwd.py import wx, MySQLdb class LoginDlg(wx.Dialog): def __init__(self): wx.Dialog.__init__(self, None, -1, 'Login', size=(250,150)) # widgets userLbl … |
| | Hello all, I recently made a mysql database using python and imported an excel file into the database. However, I am having some issues with some of the python. Using the following code, I have selected 11 numbers from a table in the database. # c.execute('SELECT REF_PNL FROM actual_data_table WHERE …  |
| | To help increase sales, your management decides to give customers a one-time bonus. Here are the credit rules: for 1-15 credits, add 1 credit for 16-30 credits, add 2 credits for 31+ credits, add 10% and round up (10% of 35 is 3.5, rounded up to 4) Write an update …  |
| | hello guys.. can anyone please help me i have created a Simple search for my database..the search form contains a drop down menu of the field names and user select the field name and input the keyword and then Click on search to retrieve matching records from that particular field.. … |
| | I just cannot get this solved and after way too much time on this, I'm here for help. Here's my code snippet: [CODE] while ($row = mysql_fetch_assoc($result)) { $domain = $row["domain"]; $domainwww = "www.".$domain; //$domainwww = "www.google.com"; $sql2 = "SELECT url_id, url FROM urls WHERE url='".$domainwww."'"; [/CODE] My problem is … |
| | Hello there! I have a question - I'm trying to display store categories (ex: Apparel and Accessories) in this code. The categories display perfectly, but when I click on said categories, they do not display the items underneath it. I've populated the database with a few values, but they still … |
| | I have a file upload website. Information about files and the files themselves are stored in a mysql database. I want to allow the users to delete their own files. On every line I have put a delete button. My concern is which is the most secure implementation. I am …  |
| | Hi, I need to update the product quantity in the product table according to the quantity which the customers ordered...Since I am new to this field I dont know how to do it with a query. This is what I want to do in more details.As the administrator checks for … |
| | Hi, I looked for any posts on this but couldn't find any, it should be pretty easy. I have a Company table with parent_id that points to a company itself. I want to get the names of the parent, if any. So if I have my table as cpy_id cpy_name … |
| | Hello there, I'm in the process of learning C# and windows forms. What I'm trying to do is adapt some scripts I have already made using PHP and MySQL to work in a windows environment and GUI. I previously wrote it using PHP because I was already familiar with the … |
| | Hi experts, I have a problem which is I can't write arabic text as values of table , here is the steps I have done , please help me and correct me if I am mistaken this is what I did: ************************************************** set names utf8 COLLATE utf8_general_ci; create database see; … |
| | i frnds, Many times i try to retrieve image from database. Successfully it upload to database. but cant retrieve. any one know this? Thanks in advance.... |
| | Hi, I would like to make an Online Course Application System. I'm just wondering, what are the frameworks,technology that I need to get started? I'm thinking of using PHP and MySQL. I've used Joomla before, but for normal web page, is Joomla capable of handling such system? Thanks. |
| | Hi, i have been trying in vain all day to assign child name to a parent id in an innodb table with foreign key. I can retrieve the parent id fine, but the problem is when i try to insert child name, PHP doesn't seem to be passing any values … |
| | Im getting an sql error saying "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1" These are the 2 queries... $sql = "DELETE FROM tbl_category WHERE cat_id=$cid"; $sql2="INSERT INTO tbl_sales … |
| | I want to match two tables values in different databases. How i can do this? |
| | Information is arranged that You can assign highest to the least. Ascending or time. If the text is Ascending. They are sort of az if a number from 0 up to sort it indefinitely. Now it is a problem that If we want to give it up before then bangkok … |
| | <?php $con = mysql_connect("localhost", "root", ""); if (!$con) { die('Could not connect: ' . mysql_error()); } $db_selected = mysql_select_db("kar",$con); $sql = "SELECT * from valid"; $result = mysql_query($sql,$con); print_r(mysql_fetch_assoc($result)); echo "<br>"; mysql_close($con); ?> |
| | Hi, I am about to blow my brains out. Im sure you've been there! I am trying to create a table in my MySQL database and getting this error -> SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds … |
| | Can anyone help me? Can i know what is the difference between superkey and primary key? what is actually candidatekey? |
| | The script is supposed to receive data from a HTML form and update the table based on the supplied information. This is what I get: "Connected successfully Selected successfully Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in on line 39 Query was empty" [code=php] <? $name = …  |
The End.