11,093 Topics
 | |
| | Hi all, I am fairly new when it comes to SQL... and i would like some help I would like to run 2 select statements in the same time...in order to get my results in a table with 2 columns and 2 rows that shows me the result of my … |
 | Hi All, I was trying to research my problem, but wasn't getting any results to satisfy me. The problem is: I am storing data in a mysql database (the server time is stored as well), I am also uploading data into this database from a file that was downloaded from … |
| | could u pls help me out to create one databse inside another databse using PHP , MySQL. is it possible??  |
| | Hi, I am new to MYSQL stored procedure. Getting problem in SP execution through PHP. How can we execute multiple procedures using mysql and php. I made connection using mysql_pconnect("host", "user", "pwd", 1, 131072); and have 3 procedures one for select, insert and update. If i am going to execute … |
| | hi how can access romote Mysql database from local mysql database. like oracle dblinks will also work in mysql. |
| | ho do i store information to a mysql database? what i am trying to do is to fill out some students information and when i try to click save it should be saved to a mysql database.... here is my code but every time i click save it couldn't connect … |
| | Hi guys, A few months ago i installed a version (5.0 i believe) of MySQL on my machine with no problems at all. Two weeks ago i had to format my hard drive and reinstall my OS. I have successfully installed Visual Studio 2005 and tried to install MySQL last …  |
| | Hello, I have a php script. there is user and admin sections. The information is displayed in the user side (displaying adding new article) when added from admin side. But when I add a new article and refresh page. it does not come but after 2-3 refreshes It comes. same … |
| | Hello. I have a MYSQL database and I receive CSV files throughout the day. At present I have to open up my database and import the CSV file. Is there a exe file that can run so the CSV file can be imported as and when it arrives on the … |
| | Hello I am trying to run an exit survey when people leave my website. I really have no Idea how to got about it, so I have been piecing together PHP code and HTML. Hear is what I got so far. [CODE]<p>Thank you for visiting Niland's Place Campsite today. I … |
| | Ok..here's a challenge (maybe not if you're really good I guess) for you PHP/MySQL gurus out there (may need javascript perhaps?) If you can point me to a solution that exists for this, that would be good. If you can implement one, I'd love to learn from it, tweak it, … |
| | Hi, I need to fetch 5th top and 6th max from my database table... asssume everything are integer datatype. Thanks |
| | but I NEED to learn. I am a graphic designer and I am working on my first website.... I must find a php/mysql picture uploader with contact form to place on my web page. I have tried many from this site but I think I am illiterate when it comes …  |
| | Hi Everyone I am working through a book called Dreamweaver PHP Web Development. It has a tutorial for creating a booking system for a hotel. The because went out of publication in 2002 and there isn't a errata on the Glasshaus site for it . When creating the search page … |
| | Hi, I am trying to use MySQL full text search in my application, but surprisingly the query doesn't seem to be working for keywords like 'ASP.net','Vb.net' The query is given below, [CODE] SELECT * FROM tbl_postedjobs WHERE MATCH (keySkills) AGAINST ('ASP.net') [/CODE] |
| | Hello, i would like to be saving images from an online form to a mysql database. what is the php syntax |
| | Hi, I'm a website developer. I need importable .sql files for coutry/state and city list of the World. 3 Separate list with the support of foreign keys will be ok. Best if you can send me a single table. I specially need, Indian state and city list .sql files. Any … |
| | 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.. |
| | I know this is for MySQL, but there really isn't a forum for 'other databases.' I was wondering if anyone could point me in the right direction for learning SQLite. I tried googling it, and I did find some helpful things, but nothing that shows me how to use it. … |
 | 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 … |
| | I'm new to mysql and I need some more practice with this stuff since were going to have a test soon ([I]this is not a homework assignment[/I]). One thing I still don't get is how to check if two tables contain an equal set of values. Heres the practice problem … |
| | So I was making a calculator that pulls from a mySQL database. The program works flawlessly on my personal computer. However, when I move the program to another computer it crashes upon loading. If I take out my database call the program works so I believe I have localized it … |
| | for example, the blogs, how they divide the entries in pages? i have kinda of a idea like if ur on page 2 and ur blog shows 5 post per page the $row=mysql_fetch_assoc would execute 5 times before starting to post, thats the only way i can think about, is … |
The End.