10,938 Topics
 | |
| | Hi, I have a table like this: [code] name +------------------------------------+ | name | +------------------------------------+ | This is an rna-binding protein. The data which is useful is available from the desired location. | +------------------------------------+ 1 row in set (0.00 sec) [/code] I want to remove extra space i.e in between binding … |
| | Hi All, I have four different tables in my database with following structure: //=================================================================== 1. [B][U]customer[/U][/B] [I][INDENT]customer.CustomerName, customer.CustomerHouseNo, customer.AreaID, customer.CustomerID, customer.CustomerType, customer.CustomerBalance, customer.CustomerAdvance, customer.CustomerMonthlyFee, customer.Remarks, customer.CustomerConnectionDate, customer.CustomerStatus, customer.CustomerTelephone, customer.EUserID, customer.USerID, customer.EditDate, customer.CDDate, customer.DisRemarks, customer.CtypeID, customer.CIP, customer.CMAC[/INDENT][/I] 2. [B][U]payments[/U][/B] [I][INDENT]payments.Amount, payments.PaymentMonth, payments.PaymentDate, payments.CustomerID, payments.PaymentYear, payments.CustomerAReaID, payments.ReceiptNo, payments.USerID[/INDENT][/I] 3. [B][U]area[/U][/B] a[I][INDENT]rea.AreaID, area.AreaDesc … |
 | I have been working on a site for a while now, and finally wanted to load it up to the server. I have been working on my own computer with xampplite. Everything was working just fine. When I uploaded it, after a few little things to resolve, I got most … |
| | I have joined a few tables together and all seems to work well.. [code] SELECT * FROM products JOIN underwriters ON (products.underwriter_lookup = underwriters.id_uw) JOIN countries ON (products.country_lookup = countries.id_co) JOIN repay_types ON (products.repay_type_lookup = repay_types.id_repay) JOIN base_rates ON (products.base_rate_lookup = base_rates.base_rates_id) [/code] However, I have been asked if I … |
 | Hi I trying to implement pagination using LIMIT in MySQL. My problem is it works good for the first 3 results only and for later results it shows error saying [COLOR="Red"]check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 3, 3' …  |
| | Hi, I need help for this problem that i'm trying to solve for a while (i'm new in PHP). How do i submit the value into database? Here's the code: [code]<form name="Form1" method="POST" action="checkbox.php"> <p><input type="checkbox" name="floor tile"> Floor Tiles</p> <p><input type="checkbox" name="polished tile"> Polished Tiles</p> <p><input type="checkbox" name="homogeneous tile"> … |
| | Hai I had a mysql table and columns like name, address, phone, id. I need to select only name of a specified id. Now i am using this code: $sel=mysql_query("SELECT * from profile where id='$id'")or die(mysql_error()); $row=mysql_fetch_array($sel); $name=$row['name']; Please let me know whether this is a correct way. If not … |
| | hi ive got a school assignment where i need to access data in a MySQL table, use style formatting and output it in a HTML file. Additionally, there is a frequency column that I need to use to create the style. The more frequent it is the larger the font … |
| | [code=php]<?php if ($_SERVER['REQUEST_METHOD'] == 'POST'){ $getLima=$_POST['Onoma']; include "connect.php"; $rsSelectOnomata=mysql_query("SELECT * FROM titloslimmatos WHERE LimmatikosTypos='$getLima'"); //$result=mysql_query($query); while($rsRow=mysql_fetch_assoc($rsSelectOnomata)) { echo $rsRow[titloslimmatos.LimmatikosTypos]; $rsRow[titloslimmatos.MerosLogoy]; $rsRow[titloslimmatos.YfologikoEpipedo]; $rsRow[titloslimmatos.GlwssikoEpipedo]; //$rsRow[extralimmatikoitypoi.ExtraLimmatikosTypos]; //$rsRow[extralimmatikoitypoi.YfologikoEpipedo]; //$rsRow[Simasia.XrisiLeksis]; //$rsRow[synonimo.Synonimo]; //$rsRow[synonimo.Example]; //$rsRow[antitheto.Antitheto]; //$rsRow[antitheto.Example]; } } else { ?> <html> <body bgcolor="#FFFFCC"> <h3><center><b>Δώστε το λήμμα που ψάχνετε</b></center></h3> <table> <form method="post" action="<? echo $PHP_SELF ?>"> <input … |
 | Hi, I've managed to piece together an SQL query (not literate in the language), but it isn't giving quite the data I expected. Here is the code: [CODE]SELECT products_description.products_name, products_description.products_description, products_description.products_id, products.products_image, products.products_price_sorter FROM products_description INNER JOIN ( products, salemaker_sales ) ON ( products_description.products_id = products.products_id AND products.master_categories_id = salemaker_sales.sale_categories_selected …  |
| | pls, help! how can i connect to mysql 5.0 database with vb6 and how do i connect to mysql database from php5.Where do i download the necessary drivers. |
| | I am having trouble with one thing on my project. I have already created the following table and inserted all of the information into it. Items ItemID Description BidFloor 100 1943 Monopoly game 80 101 1972 Ford Pinto Station Wagon 80 102 1.5 L 1921 Chateau Neuf du Pape 1,000 … |
| | Hi frnds.. Currently i am working as a php developer.i know php,mysql and smarty... i am interested to change my domain from [B]web developer to mysql admin..[/B] plz give me some suggestions to me... how can i need to follow? and where can i get information regarding mysql totally.....what should … |
 | Hello Everyone, I have a pretty simple problem for an expert. I want to access the database on the server from my localhost, I don't know how to do it. On our localhost the way is mysql_connect("localhost","name","password"); But how I will access the database on a server from my localhost?? … |
| | |
| | Hello All. I am working on Mac OS X. I installed Python 2.5.4 and Mysql 5.1.31. For the interface, i installed Mysql-Python 1.2.2. I did the right steps for the installation. But , getting some warnings. So, i checked in Python shell for the modules. Python 2.5.4 (r254:67917, Dec 23 … |
| | [I]Hi everybody, I'm new in PHP coding a I want to wrote php script, which find some data in database. But it doesn't work.When I submit form to search, it's write an error: Connection not avaliable! Error 403! localhost 05/27/09 22:33:46 Apache/2.2.11 (Win32) PHP/5.2.8[/I] Could somebody help me? [COde=php]<?php error_reporting …  |
| | I am an not so experienced developer and could od with some help. The problem I am trying to tackle is as follows: I would like to enable the site-administrator, when logged in, to renew the occupancy calendar of a holidayhome in Mysql. The occupance file on the desktop that … |
| | Hello Im trying to create a order form which passes through multiple pages. Im wondering if you could have a drop down menu with the prices on and names on from a MYSQL database. Thanks |
| | Hi I was wondering what the syntax would be to have a left join from one table to a resulting query without the view. Currently I use a view and it works fine but I was wondering how to achieve this without creating the view. Here is the current view's … |
| | Hi to all there ! i am trying to to execute the query to insert values into database but all the time facing this exception my code for query is this [code]String query=("INSERT INTO imageinfo (imgId,imgName,imgEntryDate,userName,imagePath) VALUES ( '"+ 0 +" ',' " + imgNam +"',' "+ date +"',' "+ …  |
| | I need help with structuring a mysql database query so that if a certain condition extists, then a further condition is applied to the "WHERE" clause. This is my standard query: [CODE]SELECT * FROM products LEFT JOIN access ON product_id = access_product_id LEFT JOIN manufacturers ON product_manufacturer_id = manufacturer_id LEFT … |
| | I don't have a clue how to do this. Have a PHP web site template, that has a 'submit ad' form. Works just fine for that web site. What I want to do, is to include a number of additional sub-domains, so that one can run the same ad on … |
| | hello..im new in this forum and php language..i need a help..anybody know how to import excel data into mysql Database?..im a student for the final year and making a project..help me..tq so much.. |
| | |
 | its for showing a users folders. (for private messages) how can i select one of each folder name because i know that there will be more than 1 folder name that is the same. i have a mysql column called folder and there is a folder name in each row. … |
| | last activity. the ultimate goal is to have an active user list. and a script to be run on every page that updates the users activity. and then have the inactive users logged out and removed from the active users table in mysql automatically. my problem is that i dont …  |
| | Hello everybody!! I am a newbie with MySQL but I still need to do this: 1. MySQL should be listening on a port, waiting for an XML document. 2. When it arrives, parse the XML file or just take the contents I am interesting in and insert them into the … |
| | i have thisnew script if anyones interested i have lots of questions just pm me i get emailed if someone pms me and im online a lot so ill get notified fast see i have an emil checker on my firefox browser. i need help with lots thanks guys! |
| | Dear friend, I make a very simple dictionary script. Now I need to extend sound file in this script. My Initial database has only 2 colums {English,Bm} I forget to create the "ID" column. :) all 5000 sound files are stored in a folder [url]http://www.domain.com/files/sound/(english-word)*.mp3[/url] how can I link all … |
The End.