[mysql] Forum Topics

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 …

Hi; I have a question regarding my curent use of datasets and classes. I currently have a class with public properties of connectionstring sqlcommand Im setting the 2 properties from my main form and then calling a public sub within the class, this sub reads the connectionstring, connects to my …

Hi, please assist; I'm trying to read a text file located on a url, and that file information is separatedby tabs, and some cases the results on it are null values, depending on the systems performance. now, I can't read it if all values are tabs, especially the last values, …

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 …

Hello! I have been playing around with python and mysql, and I have started thinking about creating a database to record my bird sights. For connection purposes, I have programmed this class [CODE]class LoginDlg(wx.Dialog): def __init__(self): wx.Dialog.__init__(self, None, -1, 'Login to Ornithobase 1.0b', size=(250,150)) def comboLogin(): import MySQLdb db= MySQLdb.connect(host='localhost', …

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 …

Hello! I have defined a function to create a combo box to log into a database [CODE]def comboLogin(): import MySQLdb db= MySQLdb.connect(host='localhost', user='root' , passwd='acrsci00', db='Ornithobase') self.cursor = db.cursor() sql = '''select Username from Users''' self.cursor.execute(sql) result = self.cursor.fetchall() result2 = [] x = 0 for record in result: for …

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 ..??

HI, in my project, i have a table 'Orders' with orders submitted, where some have already completed and others are pending,,, The status of the order is denoted by a status ('completed' / 'pending') My problem is this,, I need to display the orders separately in two different sections in …

Hey guys, What would the best / most efficient way to incorporate an achievement system be for a MySQL database? I have a users table with users in it. Should I make a whole new table for achievements called "achievements"? How would I most efficiently link this table to the …

Hi, I have a php code that lists the contents of one of the tables in my database. At the bottom of the listing, there is code that takes you to the next 10 results. Problem is, when I test it out, I am being redirected to a comcast search …

Hi everyone. I am seeking help to display my query result (user list) into several pages. The code below retrieves user details successfully like a picture, accommodation name, address and a clickable link to a profile page related to specific details of user. This page is my users_list.php which displays …

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

Hello. I am currently working on a website to post some articles I write for my friends. The problem I am currently having is with a dynamic redirect. I have a dropdown list that is populated dynamically from a mysql database. That part is working fine but I can't get …

I administrate a database with 3 main tables for a training company: course providers, lecturers and graduates. I have to create a database admininstration page with insertion, modification and search features. I am using php with mysql. I wanted everything to happen in the index.php (do not know if this …

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 …

Hello! I have this function that prompts a wx.MessageDialog [CODE]def DelUserDlg(self, event): dlg = wx.MessageDialog(None, 'Are you sure you want to delete your user?', 'Question', wx.OK | wx.CANCEL | wx.NO_DEFAULT | wx.ICON_QUESTION) dlg.ShowModal()[/CODE] I would like to assign an event to delete a mysql database user. How can I assign …

I have this output from a mysql export: [code] <?xml version="1.0"?> <resultset xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" statement="select product as sample,count(*) as count from table1 where itemno in (5,10,37) and type='food' and package='boxed' group by package,product order by count(*),product desc limit 5 "> <row> <sample>cereal</sample> <count>1</count> </row> <row> <sample>macaroni</sample> <count>1</count> </row> <row> <sample>cookies</sample> <count>2</count> …

how can i clear my data table? I am using VB.Net as my front end MySQL as my Back end.

What it want from me? [CODE]<?php if (isset($_POST['submit']) && $_POST['submit'] == "Update") { $query_update = "UPDATE preturi SET preturi = '" . $_POST['preturi'] . "' WHERE username = '" . $_SESSION['user_logged'] . "' AND password = '" . $_SESSION['user_password'] ."'"; $result_update = mysql_query($query_update) or die(mysql_error()); $query = "SELECT * FROM …

I have a drop-down list box which has to be populated from a database in mysql. I implemented the following code: [CODE] //DB Conn done here.. <td>College Name,id :</td> <td><select><option selected="selected">Choose a college...</option> <?php $query="SELECT nameid from college"; $result=mysql_query($query); while ($line = mysql_fetch_array($result)) { foreach ($line as $value) { echo …

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, Im struggling to do a function like this.In the admin panel of my site,there is an option for the admin to select multiple orders using check boxes and marked them as accepted.And I need to update the product table at the same time according to the product quantities of …

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 developed a download / upload script that also counts the downloads of each downloaded file. For statistics i currently got total files and total overall downloads but would like to extend this so it can say how many downloads there has been in a week, month, year. …

I have a search a particular filename in my msaccess file . if i search through ID no , i am able to fetch the output . but if i am searching by comparing filenames then i am getting error [CODE] Private Sub cmdSearch_Click() Dim key As String, str As …

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 …

Hellow programmers, today I stuk on a new one,This time is a $_Get sintax that give me error like so :"invalid query 4: 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 ''36''' at …

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 …

Can somebody help me? We are tasked to create a library system. And my very first problem is how to create a search engine. The form must be like this: 1.) One search engine for the Title of the book, wherein the user can search through the title of books. …

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) …

I'm trying to finally implement an idea I've had for years now and I need to be pointed in the right direction. Here's the scenario: A registered user sends a specific text delimited SMS to my website/server. The server processes this specific text as a database query that matches specific …

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 …

Need help with displaying picture from mysql database. Can anyone provide a basic php script to retrieve picture from database for display in html page. I have database field: avatar_url whichs save filename of picture in database and a folder: images/avatars where the picture get saved saved. This is for …

Hi, I am trying to get something up where by: -> It dynamically displays input text fields that can be edited. -> However I need the current id as well as the current value to display -> when a person submits the form, it updates all / or only each …

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 …

Hi guys, I have a small problem here... There is a [B]customer id[/B] field and a [B]search button[/B] in one page. In my database there is a [B]table[/B] called "[B]customer[/B]" which contains fields of [B]customer_id, full_name, name_with_initials, address, contact_number and gender[/B]. The table is filled with record of each customer …

Hi all, Here i have a serious problem. I want to sought it out using [B]PHP and MySQL only[/B]. I have a form includes fields of customer id and Account type( [B]stored in a jump menu and includes 6 different types of accounts[/B]) [CODE] <style type="text/css"> <!-- body,td,th { font-size: …

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.. …

Hello Now this is very strange and way out of my knowledge-basis. I had a working form (see code) which inserted data into eph_product. Suddenly it stopped working and when I click on 'submit' I get the following error: [B]You have an error in your SQL syntax; check the manual …

i get this error Syntax error (missing operator) in query expression [code=c] "FROM (Employee LEFT JOIN DaySchedule ON Employee.[Employee Number] = DaySchedule.[Employee Number] " + "RIGHT JOIN Rules ON Employee.[Default Shift Code] = Rules.[Rule Name]) " + [/code]

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 …