10,939 Topics

Member Avatar for
Member Avatar for acrocephalus

Hello! I am trying to write a function that looks for a desired string pattern within a table (Countries). Look at the code. [CODE]def selectCountry(): print 'Enter country:' country = raw_input('> ') sql = '''select idCountries,CountryEn from Countries where CountryEn REGEXP '%s'''' cursor.execute(sql,(country)) result = cursor.fetchall() rowHead = 'Country ID','Country …

Member Avatar for acrocephalus
0
350
Member Avatar for ariffin246

[code=mysql] SELECT * FROM fb.order LEFT JOIN item on order.item_name = item.item_name WHERE fb.order.order_status = 'Served' and tab_name='A' [/code] I have two different tables "order" and "item" which i joined using left join. In order table there is a column name called quantity and in item table, there is a …

Member Avatar for ariffin246
0
120
Member Avatar for alkeshtech

Hello all, I am using MySQL on Windows box for one of the project I am working on. My design for a Emplyee table is: employee ([B]id[/B], first_name, last_name, hire_date, start_date, end_date, active_status....) Active status = true if end_date is in future, else false One of the functional requirement is …

0
58
Member Avatar for LRNPHP

Hi Everyone. Could someone assist me in the query. The table has type_of_vehicle field. In this field I have A, B and M. I would like to create a query where I can specify to select A and B, or A and M or A,B,M. Hope someone could assist me …

Member Avatar for swi2
0
113
Member Avatar for raaboo

Hi, I have a table on MySQL server that contains several fields (id, ListingID, Scores),being utilised via a php page. The 'scores' column has the values stored as '1,2,3,4,5,6'. When a rating is added, people select their rating (out of ten) for a particular listing and this is then stored …

Member Avatar for diafol
0
165
Member Avatar for Awah Mohamed

hello guys . i am new to mysql and i really dont know anything about it so i need your help in creating a database that contains two places one is the username the the 2nd one is the password .So please tell me how to do it

Member Avatar for rajarajan2017
0
125
Member Avatar for jeffsbaker

I was wondering if someone could help me with a mysql indexing problem. The index of 'username' for this code works fine: [CODE=mysql]EXPLAIN SELECT count( * ) AS num_messages FROM messages, users WHERE messages.username = 'johndoe' AND users.username = 'johndoe' AND messages.sent_date >= users.last_activity[/CODE] Here is the explain: [code] id …

Member Avatar for jeffsbaker
0
350
Member Avatar for teedoff

I am new to MySQL and navicat as well. I have been creating a database in Access and now adding records. I added about 50 records earlier and then saved them to my flashdrive to import the new data in navicat using the import wizard. The reason I have to …

Member Avatar for teedoff
0
468
Member Avatar for drspock

Hi, Does anyone know if there is a way in MySQL to have it return the column names qualified with the table name? For example, suppose I have the query, SELECT * FROM Items, Sales; and the tables Items and Sales both only contain columns named ID and Count. By …

Member Avatar for tesuji
0
244
Member Avatar for Dartz654

I think I already know the answer to this, but just to be sure, is there any way to connect to a MySQL database in VB?

Member Avatar for Teme64
0
89
Member Avatar for Onisutra

I currently have 12 files I've designed for database connect. I have 1 interface, 1 main class & 11 sub classes. File List: iDatabase.php Database.php mySQL_connect.php mySQL_close.php mySQL_error.php mySQL_errno.php mySQL_escape.php mySQL_query.php mySQL_array.php mySQL_row.php mySQL_assoc.php mySQL_num.php mySQL_id.php While I've gotten as far as creating all the class code & the interface, …

Member Avatar for diafol
0
134
Member Avatar for design.eng

I have been looking for a tutorial to learn populating drop menu or list data from a mySQL. I have found this thread from a website. But it seems something wrong. I get this error [CODE]0 and !is_numeric($cat)){ // to check if $cat is numeric data or not. echo "Data …

Member Avatar for design.eng
0
1K
Member Avatar for vijayamani

Hai Everyone.. I am new to this forum & MySQL.. I hava a table like this [code=php] iss_date item_code aa bb cc 2010-06-05 abc 10 15 15 2010-06-10 cca 20 20 20 2010-06-12 abc 12 12 12 2010-06-13 abc 13 13 17 2010-06-15 cca 18 17 24 [/code] I need …

Member Avatar for vijayamani
0
101
Member Avatar for wiredtec

I'm looking for a beta form. what i want it to do is auto redirect user from a main site to the enter beta key form. If they don't have a key , a link to a get beta key signup form that only require a name ane email. This …

Member Avatar for vibhaJ
0
303
Member Avatar for Meeta123

[TEX]Hi, Can anyone tell me how to retrieve an image from mysql along with other columns of different datatype to a jsp page? [/TEX]

Member Avatar for Meeta123
0
43
Member Avatar for acrocephalus

Hello! I have created a database named Ornithobase, which contains a Users table with Name, FamilyName, eMail and Username columns. I have already connected to the database with MySQLdb module. How can I print this table in the console from the Python script? Furthermore, how can I perform a search …

Member Avatar for acrocephalus
0
122
Member Avatar for tyronet2000

I have a database with two tables: [B]books[/B], the fields are [B]title_id, title, pages, publisher[/B] [B]author[/B] the fields are [B]author_id, title_id, author[/B] I can INSERT ok into either table as a speparate entry but what I would like to do is enter the data into both fields from a form …

Member Avatar for drjohn
0
87
Member Avatar for backendcode

help me plz i m facing an error.....thnx Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in J:\xampp\htdocs\projects\admin\index.php on line 45 <?php //database connectivity $host="localhost"; // location of my sql on server $user="root"; // Database name $pass=""; // Database name ( By default with no password ) …

Member Avatar for karuppasamy
0
138
Member Avatar for canadian_angel

I know I am missing alot, but I am new to mysql and I have to make a table for a used car dealer which includes make,model,price and mpg and I am confused. I have to configure commands with sample data to enter at least one record in each field. …

Member Avatar for sandeepji1
0
160
Member Avatar for artvor

Hello, I have this code till now: [CODE]<?php include '../include/db_viewer.php'; ?> <?php $c=$_GET["c"]; $sql="SELECT * FROM regulations AS b LEFT JOIN global AS ab ON b.id=ab.id WHERE checked = '".$c."' "; $result = mysql_query($sql); echo "<table class='maxWidth' cellspacing='0'> <tr><td> <table cellspacing='0' class='advanced'> <tr > <td>Broker</td> </tr>"; while($row = mysql_fetch_array($result)) { …

Member Avatar for artvor
0
91
Member Avatar for sivak

i have 3 tables student table roll no name sub table roll no subid subname markstable roll no subid marks 1)select name,subname,marks whose having marks less than 40 2)select sub name,marks whose having avg above 60% 3)select rank of each student can any one tell me the query for that

Member Avatar for tesuji
0
57
Member Avatar for Shaswat
Member Avatar for sandeepji1
0
102
Member Avatar for fakemew

I am storing the images in a folder on my webserver and adding the location/details of the image to the database. But I have problems retrieving them, please help! Is this the code I should be using? [code=php]<?php echo "<img src='/images/". $filename ."'>" ?>[/code] then $filename is supposed to be …

Member Avatar for rajarajan2017
0
177
Member Avatar for Mike516

Is there any way to search with a variable that is an array. ie) [code=php] mysql_query("Select * FROM table_name WHERE `id` = '$var'"); [/code] where $var is an array. Is this possible?

Member Avatar for Mike516
0
141
Member Avatar for acrocephalus

Hello! I have this funtion to delete a record from a MySQL table: [CODE]def delUser(): #Delete user #Ask for user to delete Username = raw_input('Which user would you like to delete? ') #Delete user delUser = '''DELETE FROM Users WHERE Username = %s''' cursor.execute(delUser,(Username)) db.commit()[/CODE] The problem is that it …

Member Avatar for gunbuster363
0
114
Member Avatar for Indirect

Hey all. First post ;) and since i've used this site a lot for help i think its about time i registered and joined up. Im not new to programming but i am new with php + database manipulation. [CODE] $app = mysql_query("SELECT * FROM applicant_classinfo WHERE appid='".$_GET['id']."' AND '".$_GET['cname']."'"); …

Member Avatar for Indirect
0
148
Member Avatar for swi2

Hi, I am Installing XAMPP in Windows XP but when I start my computer it gives the dialog box with "mysqld.exe not found" and when i start the localhost/phpmyadmin the following errpr is occured "#2003 - The server is not responding " pls some one give me some solution of …

Member Avatar for keval_hack
0
779
Member Avatar for asahmed

Hello Does anyone know how to effectively search for a string in a Mysql table? Here's the problem: Let's say I have a table(id,song) and I want to search for a specific song (ex: One Love) Using the following query returns the exact song when the user enters it exactly …

Member Avatar for asahmed
0
143
Member Avatar for tanha

Hello everybody, firstly I am new in PHP, and I use the WAMP5 tools which has the following features: i) Apache 2.2.4 (SERVER) ii) PHP 5.2.3 + PECL iii) SQLitemanager iv) MySQL 5.0.41 v) Phpmyadmin I have a table named 'tblStudent' with four fields as follow properties: 1. stID int …

Member Avatar for JimiTster
-1
188
Member Avatar for aMOEBa

Hey guys I am trying to write this application to display members who are celebrating the birthday in a particular week, month. I want the app also to be able to display those who will be celebrating their birthdays in abt 2months. I want to do something like how Facebooks …

Member Avatar for pritaeas
0
149

The End.