10,939 Topics
 | |
| | 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 … |
| | [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 … |
| | 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 … |
| | 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 … |
| | 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 … |
| | 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 |
| | 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 … |
| | 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 … |
| | 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 … |
| | 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? |
| | 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, … |
| | 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 … |
| | 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 … |
| | 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 …  |
| | [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] |
| | 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 … |
| | 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 … |
| | 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 ) … |
| | 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. … |
| | 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)) { … |
| | 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 |
| | |
| | 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 … |
| | 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? |
| | 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 … |
| | 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']."'"); … |
| | 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 … |
| | 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 … |
| | 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 … |
| | 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 …  |
The End.