11,093 Topics
 | |
| | Hi, I want a MySQL stored procedure which can parse an excel file and save it in the csv format,after which the values in the file can be imported into a table. Kindly help me with a solution for this asap. Thanks, Narayana  |
 | Hi, So basically I have a php file that fetches database records and displays it. Now i would like to add the ability to edit each record using lightbox. here is the main file [CODE=PHP] <?php $username="root"; $password=""; $database="lhs_anniversary_banquet"; mysql_connect("localhost",$username,$password); @mysql_select_db($database) or die( "Unable to select database"); $query="SELECT * FROM … |
| | hi all im looking to use a select mysql query - but im trying to query the database against a users logged in sessions. I have the sessions working correctly but I am unsure how to included the session data in my sql select query. here is my users session …  |
| | I am getting the following error Fatal error: Call to undefined function mysql_connect() in C:\Inetpub\wwwroot\valid.php on line 4 Using php and my sql on localhost |
| | hello. is there a way which i am able to cast/ convert my substrings into integer? This is what i have been trying to do, apparently, it does not work. SELECT campaignmonth CAST(campaignmonth, substring(campaignmonth,1,1)as Jan) FROM campaign a; thanks |
| | Hi, Ive been at this all weekend and can't figure it out.... I need to take it name and 3 results via a form and store this in a mysql database - done. Then I need to print on screen via php who got the highest score. The highest score … |
| | I've got my pagination script working, but now I need help trying to get it to extract data from 2 different sources. The episode data is stored in table episodes, whilst the main table (where the info on airdates for episodes is stored in epdata2). This is my code: [CODE] …  |
| | Hi all ! I 'm a newbie in SQL and has just install the Oracle 10g Express Edition. When using its SQL Command in the Web-interface, I took an error with the GROUP BY, as follow : First, I create a table DEPARTMENT, here 's the code : [CODE] CREATE … |
 | Hi all, I have been running errors too much that I realized that I have learned 'bad' behaviour in writting PHP query. So I decided to change. Please tell me what is good behaviour of writting queries that involve PHP variables as well as functions like one below. [CODE=php]$query = … |
| | Hi, i'm not really sure how to explain this. I have a table with a lot of places sorted by date, all connected to a MySQL database. I'd like the table to update automatically everyday and remove the top ones where the date has passed so that the table only … |
| | Doing a system in drupal using php and mysql. Want to integrate a function for reporting - that is print out watever search result in the search page which displays in tabular form. please help. i have only heard of jasper reports. is there something simpler? if so wat n … |
| | Doing a System in Drupal - coding with php and mysql - want to know how i can integrate jasper reports to it so i can generate reports at the click of a button.. does anyone know? please help.. |
| | Hi folks, [COLOR="Green"] I have a MySql table...which has 4 columns say sid pid tid data 1 abc 2 def 3 ghi 4 jkl - - 10 xyz 1 dfsf 2 sdfs [/COLOR] I want to convert column name 'data' into multiple rows i.e. 1 2 3 4 5 --- … |
| | I have a table and I want to start the select with the 20th row. How do I do this? Does conditionals work on "limit" |
| | I'm doing my assignment, and I can't figure out how do it. For instance, I have to decrease the prices in a "movie" column by 3%...how do you update the table like that? So, would you say: UPDATE table_name SET PRICE = (PRICE * 0.97); ? |
| | Hey I am trying to run this in php: [code]// Retrieve data from table where row that match this passkey $sql1="SELECT * FROM $tbl_name1 WHERE confirm_code ='$passkey'"; $result1=mysql_query($sql1) or die(mysql_error())[/code] and I get this error: [code]You have an error in your SQL syntax; check the manual that corresponds to your … |
| | Please see this: [CODE]WARNING [1024] Error while executing query: select event_type, EventId, VenueId, Price, Schedule, ev.startDate, ev.endDate, events.name eventname, movies.name moviename from `eventvenue` ev, `events` left join (movies) on (movies.ID = ev.EventId) where events.ID = ev.EventId and VenueId = '493' and ((ev.startDate >= '2010-04-25' or ev.endDate >= '2010-04-25') or event_type … |
| | Anyone, please help me here. I created a view in mysql but when I use it in my code in php, an error appears that the view doesn't exist. What can I do? Here is my code. [CODE] $count = mysql_query("SELECT COUNT(*) FROM ViewName where ftTimeIn != '' AND ftTimeOut … |
| | Hi Everyone, I have a page that displays information from a mysql database. The information is taken from the members table where the id is in the url e.g. [url]http://www.clancorner.net/tounament.php?go=MW2&[/url][B]id=2[/B]. And that works perfectly, pulls ou all the information i asked for. Unfortunatley i now need to just echo "Invalid … |
 | Hello, I'm trying to pull data from multiple tables in a single mysql_query and I'm having trouble displaying the data that's pulled. Here's what I've got so far.. the highlighted code is the part that doesn't work. (sorry in advanced for the sloppy code.. i've been copying/pasting stuff all over … |
 | |
| | hello, I need to have in ONE request clients who just like apple AND banana : clients id name relations_like id id_client id_like like_fruits id title a same client can have a few differents like_fruits if I made a classic SELECT FROM relations_like WHERE id_like IN (idapple, idbanana) I will … |
| | hi, I need php mysql image upload and resizer. The image uploaded through a uploading page should be resized and should kept in mysql server. and we need to retrieve it to another page. help me. thanks, |
| | Hi, I`ve started doing PHP and MYSQL for a few months now and I am working on a project for a friend. Basically I had the code written down in mysql format and decided to change my code too mysqli. Everything was working fine except for one function. I keep … |
| | Hi, I have written the following code to download a file from a MySql database using a Servlet.The problem i have is that i havnt done it right. Can someone please point me in the right direction. Any help will be greatly appreciated. Thank you for your help. [code=java] import … |
| | Hi all. I've been having this problem and I was hoping someone could catch something I didn't. So here it goes: I have developed a registration system using PHP and mySQL, with usernames and passwords being encrypted by salt and md5 (and display names getting no encryption) on PHP's end … |
| | I'm coding a simple forum, for a user system that I'm making. By simple I mean very simple - viewing categories, threads, and topics, as well as posting, editing, and reporting to a moderator. Moderators can also delete, sticky, or lock threads, or delete posts. Now, I'm doing quite well … |
| | Hello all. Am new to the forums and this is my first post and I am in need of a little help. I am in the planning stages of building a pretty involved web application. This question needs some background info first. This is for a direct mail company (a …  |
| | i would really like to automate something like ... login to mysql cmd followed by creating a database following by creating tables... with one bat script here is my try: [code] mysql -u root password password; [/code] however it returned me this: [code] C:\Documents and Settings\lih>mysql -u root password root … |
| | Hi, I want to create some kind of AJAX script or call that continuously will check a MySQL database if any new messages has arrived. When there is a new message in the database, the AJAX script should invoke a kind of alert box or message box. I’m not quite …  |
| | I'm trying to build a room booking web application with php+mysql. I'm close, but something keeps going wrong. The way it works is this: 1. User logs in 2. User redirects to "booking" page, where they can choose from 1 of 2 rooms to book 3. there are drop downs … |
| | [code]<?php mysql_connect("localhost", "Master", "pword"); mysql_select_db("db"); $official2 = mysql_query("SELECT * FROM Contribute WHERE stack LIKE '%comic%' ORDER BY points DESC")or die (mysql_error()); while($row = mysql_fetch_array($official2)) { $officaluser = $row['username']; $officalpoints = $row['points']; echo "<table><tr><td align='center'><font face='Arial' size='3px' color='#D99C29'><strong><a href='ustack.php?search=$officialuser' style='text-decoration: none'>$officialuser</a></strong></font></td><td align='center'><font face='Arial' size='3px' color='#FFFFFF'><strong>$officialpoints</strong></font></td></tr></table>"; } ?>[/code] the page is coming … |
| | code to link database selected through dropdownlist with corresponding database in mysql.Plz reply as soon as possible. Dropdownlist will list all database names inserted in a particular table |
| | How am I going to create a relationship from one table to another in phpmyadmin? Like a one to many relationship? |
 | When I do `mysql> show status like '%qcache%';` it returns: mysql> show status like '%qcache%'; +-------------------------+----------+ | Variable_name | Value | +-------------------------+----------+ | Qcache_queries_in_cache | 19817 | | Qcache_inserts | 299528 | | Qcache_hits | 687127 | | Qcache_lowmem_prunes | 6702 | | Qcache_not_cached | 3171 | | Qcache_free_memory | … |
| | Hi, I was looking for some help with how i would go about setting up my commission table. Basically i have currently: Users Table UserID Username Password Email Clients Table: ClientId Client_UserID FirstName LastName Address PostCode Tel Email Insurance Table: InsuranceID Clients_ClientID Provider Commission DatePaid CarInsurance Table: CarInsuranceID Clients_ClientID Provider …  |
| | I have a strange problem when making a backup of my mysql databases. In order to do so I have a 2TB external hard disk mounted when needed under /backup. Before making the backup I stop mysql (with /etc/rc.d/mysqld stop) and use rsync to copy all the data to the … |
| | hi, fairly new to mysql. i have been working on a site which would have say 100 + agents. basically the agents clients are their own so i thought the best way would be to get a dedicated server and create a mysql database for each agents company. the database … |
| | Hi, im working on some project on php with mysql, and I'm only actually a beginner in programming with php and mysql. I created a table in mysql which contains several records. I have like 10 records in it. Now what I want to do is I only want to … |
| | Is it possible to use PHP and a mysql query combined to allow a whole database backup file to be downloaded? For example, I'm currently backup up my database by using the export tool in phpmyadmin, but what if I wanted to add a button or link on my site … |
| | Hello Today is the first of february and I noticed a bug in my coding. I use the php date function to give me todays date in an european style: 010210 I then insert this date to a mysql table. The problem is that the date after being inserted is … |
| | Hi, I changed my table to InnoDB so one table can be used as foreign key. To do that i had to DELETE the content in my child table. I exported and saved the data on my computer. 1, Now that im trying to import all the data with phpMyAdmin … |
| | Hi everybody, I'm having some difficulties with mysql_num_rows( ) on line 26. I keep getting a warning that the supplied argument is not a valid MySQL result resource. What does that even mean!? I get the same warning on line 51. Can somebody fill me in on why this comes … |
| | i know this is about MySQL, but there is no 4GL forum, so i'm hoping one of you experts might know: we have an application that uses Progress (on a unix system) that imports data from .csv files and writes the various fields to the database. one particular type of … |
| | Hey guys, I have a question: So... I want to do a product page with new product, edit product and delete product feature. While I'm on the modify or the deletion page, I would like to and [B]categorise [/B]by [B]date[/B]-desc, asc ; by [B]category [/B]and [B]alphabeticaly[/B]-desc, asc the retrieved content … |
| | I am attaching a word document I put together with screen snapshots on how to connect to MySQL on a remote server using putty. I hope it helps those of you how have questions. |
| | Hi, I'm pretty new to php and MySQL. I am trying to use a form to update a the database. However it just doesn't seem to actually work. I also am getting this error from printing out errors: You have an error in your SQL syntax; check the manual that … |
| | Hi all! I am still new at PHP and mysql and am having a little difficult time figuring out how to get my "Trainee Name" link to switch my info list from ascending to descending order and vice versa. Right now, you will see it defaults to ASC. Any help … |
| | I have a tab delimeted file that I want to convert into a mysql table. there are 25 tab delimeted fields in the text file. I can get the values in when I construct the SQL statement word by word and get each value individually stated in the VALUES part … |
| | Hi, I need help for this problem that i'm trying to solve for a while (i'm Using ASP.net and C#). How do i submit the values from selected checkbox lists into database using c#.... Here's the code: .......................................................................... [code] <asp:CheckBoxList ID="CheckBoxList1" runat="server" Font-Bold="False" Font-Names="Vrinda" Width="338px" style="text-align: left"> <asp:ListItem>Public Tap</asp:ListItem> <asp:ListItem>Well … |
The End.