10,946 Topics
 | |
 | 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 … |
| | 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 … |
| | Hi. I am having problems getting PHP to insert data into a MYSQL data base. I am using the following variations of syntax. [code=php] mysql_query("INSERT INTO table member VALUES ('$var1', '$var2', '$var3')") or die("couldn't add new user"); [/code] and also with session variables as well [code=php] mysql_query("INSERT INTO table member … |
| | Hi I need to store binary data in a MySQL database from a web page. Basically it the web page will ask user to upload an image, and on submit, it should store this image in a MySQL database on the server. Could someone please let me know how to … |
| | ok so this is what im trying to do. this is a products page and the products diplay but i want to create a filter so if they want to view only the in this case tvs that are sony they use the from that is in the coding to … |
| | Hi, I want to update a specific field in my database. My database has only one row with one field in it. How do I overwrite that field? This is what I have at this point, but its not working: [CODE]mysql_query(UPDATE Table SET column = "$item" WHERE column = "1") … |
| | Hi, This T-SQL works fine but i just want to make sure that it is also reliable. Do you think this is reliable? Thanks [code] CREATE DEFINER=`root`@`localhost` PROCEDURE `addNewUser`(IN username_in varchar(15), password_in varchar(40), name_in varchar(25), surname_in varchar(25), dob_in date, address_in varchar(50), postcode_in varchar(8), city_in varchar(20), phone_in varchar(14), email_in varchar(50)) BEGIN … |
| | hi everyone. please tell me difference between mysql_connect & mysql_pconnect? and which is better and how? |
| | Hello, I'm a bit new to VB (actually use VBA), but would like to get some knowlegde about class module. One thing I was thinking of would be to create a class module which take cares of the connection to the MYSQL database. Please let me know if you have … |
| | [CODE]<? include("db.php"); mysql_connect($host,$username,$password); @mysql_select_db($database) or die("Unable to connect to database"); $query="SELECT * FROM tcg"; $result=mysql_query($query); $num=mysql_numrows($result); mysql_close(); echo "<center>Viewing Records</center>"; $i=0; while ($i < $num) { $client = mysql_result($result,$i,'ClientsName'); [B]$prgno = mysql_result($result,$i,'PrgNo'); this is line31[/B] $prgname = mysql_result($reslt,$i,'PrgName'); $trainername = mysql_result($result,$i,'TrainerName'); $dates = mysql_result($result,$i,'Dates'); $days = mysql_result($result,$i,'Days'); $proffee = mysql_result($result,$i,'ProfFee'); …  |
| | Hello, I'm getting an error [B]"Column count doesn't match value count at row 1"[/B] [CODE] <? include("db.php"); $ClientsName=$_POST['client']; $PrgNo=$_POST['prgno']; $PrgName=$_POST['prgname']; $TrainerName=$_POST['trainer']; $Dates=$_POST['dates']; $Days=$_POST['days']; $ProfFee=$_POST['fee']; $TrainerFee=$_POST['trainerfee']; $ReimbExp=$_POST['rexp']; $HandoutChg=$_POST['handchg']; $InvoiceNo=$_POST['invno']; $TotalInvAmt=$_POST['invamt']; $FeeRecd=$_POST['feerec']; mysql_connect($host,$username,$password); @mysql_select_db($database) or die("Unable to connect to db"); $query = "INSERT INTO tcg VALUES('$ClientsName','$PrgNo','$PrgName','$TrainerName','$Dates','$Days','$ProfFee','$TrainerFee','$ReimbExp','$HandoutChg','$InvoiceNo','$TotalInvAmt','$FeeRecd')"; mysql_query($query) or die(mysql_error()); mysql_close(); echo "Data …  |
| | I had a mysql table with a field named "age". And I need to search it using php form. ie with two text fields called "age_from" and "age_to". In simple words i want to do a search like this... [code=sql]search * from profile where age>= age_from and age <= age_to …  |
| | hello all, i need help with php/mysql syntax that will search a mysql dbase using 3 user-provided (from web form) options. All options are contained in drop-down menus. the mysql database has an auto column which is the primary key allowing for duplicate entries which are neccesary the table has … |
| | hi, how to find and open the backup file .sql in mysql... |
| | Hi, I am thinking to create an e-commerce web site. I just want to find out about the logic behid processing the order that have more than one order. How do we place an order? Stock check and update before and after placing order. I am asking this question because, … |
| | Hello, My brother asked me to create an application where he can save all his data and retrieve at any time, which does all the calculation. A friend of mine suggested PHP and MySQL would be a better option. I know HTML and CSS but very little of PHP. As … |
| | when i install mysql, my computer keeps restarting I can't even uninstall it! i fixed it by logging into Safe Mode and do a System Restore. MSQL is now uninstalled, so it's fine now. I want to have MSQL working. - using XP SP2.  |
| | Hi, I am not sure what i am doing wrong. I got my code (below) basically it is to resend user activation email if they for some reason or other did not get it first time etc. It sends the email and everything etc... what i need to do it … |
| | Hello everyone. I'm now working on a banner software which allows admins to see full statistics of banner displays, clicks and other information in selected time interval by minutes, hours, days etc. I want to consult any experts who have experience using large tables with JOIN queries and optiomize my … |
| | the most important thing is that people cant access the members only page without loggin in first. the second most important thing is actually loggin the person in and being able to like store a session i guess thats what it is that makes it so they can visit thir … |
| | how to take back up the mysql data as an sql delimited file ie .sql file by using c# from a windows application  |
The End.