10,946 Topics
 | |
| | Hi, I am showing my output using this. It shows all the records on web page where month is July(07) But I want it show all the records like: there are 29 records found, I also need 3 records per page, How I will do paging for these. please guide … |
| | Hi friends I am new to mysql . After Installing mysql-standard-4.1.22-unknown-linux-gnu-x86_64-icc-glibc23 in linux i am getting the error ./mysql_install_db ./mysql_install_db: line 85: my_print_defaults: command not found Could not find help file 'fill_help_tables.sql' in ./support-files or inside .. pl help me how to overcome it Thanks in advance |
 | I have MySQL running such that I can open a client command line and log on and make databases, tables, etc. I wanted to do some AJAX. Doing AJAX with ASP, SQL Server, etc is not advisable since both places where I am hosting my websites do not use the … |
| | Hi all, I am writing a program which needs to connect to a mysql server I have set up. I use the proxy server at school to access internet. I found that my program cannot connect to the database. So how do I connect to mysql through the proxy server? …  |
 | read: \"you fail at life =]\" yuh is being put into the database from a form submit obviously i dont want the backslashes. how do i get the backslashes rom being inserted into the mysql db table? my code is `$code = mysql+real_escape_string($_POST[code]);` then insert it with mysql query. how …  |
| | Hi, I'm running a Vbulletin install on a CentOS server. MySQL is ver 4.1.22. Every few days, seemingly at random I have a Db that will reach it's connection limit of 150. The rest of the time connections stay below 30. Then all at once queries build up, and we … |
| | Help for wml connection with mysql--------------------plz guide!!!? i have a project to mobilize a school website by wml in which a student can view its result sfter signing in.. i am totally new to wml plz guide me HOW IT CAN BE PERFORMRD ,HOW TO CONNECT WML DECK WITH DATBASE???(mysql) … |
| | i have a thread in my forum. all the replies are by THE SAME USERNAME. the mysql thing looks like this: (that runs when i post a reply) [CODE]mysql_query("UPDATE `replytable` SET `the thing to show if its a mod` = 1 WHERE `by` = '$_SESSION[username]' AND `the thing to show … |
 | How do i search table for a given keyword? I want to use it with Python. Cheers! |
 | Hi all, I have completed a cms system but at present they have to use html tags to edit the information. I recently found out about wysiwyg, which i would love to impliment but im having issues. the two following files allow you to type something, then click edit, which … |
| | I can connect from the services window but whenever I try to set the code myself on my app it tells me it cannot connect to the database. Here's my code: [CODE=java]import java.sql.*; public class LogBook { public static void main (String[] args) { connectToDB(); } // Connect to the … |
| | I know mysql but I now have a job where mssql is needed. I am having a problem inerting multiple rows at once. MySQL Query: [code=mysql] INSERT INTO colours (ccode, cdesc) VALUES ('35', 'Green'), ('35', 'Turquoise') [/code] How do I get the same result with MSSQL? Thanks in advance. |
| | Hey all, I have a MySQL database and I am wondering how to make certain data (tables and columns) in it available to search engines. Hopefully this is a MySQL question and not PHP. Any help or suggestions are appreciated. |
| | hi folks , I have a Table names A with these fields (Id,Entry_Date,State) I want to fetch the 5 recent records with Unique States And Order them Desc so this is what I did [code=sql]Select * From A Order By Entry_Date Desc Limit 5 [/code] I tried many ways to … |
| | I am writing a sports event result analyse of a database, there are few awards will be given 1. individual prize: suppose getting champion get 5 marks , second runner up get 3 marks , etc 2. the most active athlete award every student in a House participating every event … |
| | I got a little problem I am making a little admin tool for my server that you can edit player stats and things with it. Problem is if I like make string Test and assign value "Hi" to it. How can I use the string inside my IMPORT INTO statement. …  |
| | Hello im juner, a new php developer, i already finished with a [B]register.php[/B], [B]login.php[/B] file. My problem is when the [B]main.php[/B] is accessable after login by correct username and password stored in mysql database, the main.php composed of the following link: changepassword.php addsponsor.php deletesponsor.php when i click the changepassword.php link …  |
| | ya i have this site i am working on and at first it was working fine, im not sure what i did but now it says i registered but when i login i get the error saying invalid username. So i went and looked at PhpMyAdmin and it did not … |
| | I have a program that I want to use a view with. The code I'm using is: [icode] $v="select * from peoplecontact".$where." order by ci_city";[/icode] The select statement seems to work fine. It returns the correct number of rows. Now, how to I use it (see $entername)? [code=php]$v="select * from … |
| | hello, i want to create a program to fetch the xml files data to mysql database. here is my code [CODE] <?php include 'mysql-connect.php'; $m=1; $n=".xml"; while($m<6) { $str=$m.$n; $doc = new DOMDocument(); $doc->load( $str ); $params = $doc->getElementsByTagName('BookData'); // Find BookData $k=0; foreach ($params as $param) //go to each … |
| | I am new to AJAX. that's why I ask it to you. i search it in daniweb and google but i decided ask it. anyway, my question is : how can i dropdown list from database like google. I want to use it in searching the word in a dictionary … |
| | Hey guys im trying to do a query on our database, the pieces of information i need are in 2 tables within my database. table 1= customers - information i need from this table: customers_id (primary) customers_firstname customers_lastname customers_email_address table 2= orders customers_id orders_id (primary) both tables contain more fields …  |
| | is it possible to fetch data from mysql and storing it in javascript array..!!! . . waiting for valid reply.. :) |
| | Hi New to this forum so hello from sunny Coventry, UK My website uses MySQL which is accessed through PHPmyAdmin via CPanel. I have a major update to do on my main product inventory database. The standard edit/insert facility is too slow and risky in this instance as 1000's of … |
| | When i type the text myself and click send it Goes to database but when i copy from anyweb and paste in the Text box so as To send. The text is Not Going To Database...And suprisingly its Not giving any Error.Help please,i dont know whats wrong. below is my …  |
| | how to create a function in mysql and code it to vb6?? |
| | i want to ask.......if i have the data in a database of mysql....how can I generate html, chart from the database(mysql) |
| | hellow everybody, i have created a image gallery, i am displaying a button name "[B][COLOR="Red"]Collect[/COLOR][/B]" with every image, when ever a registered user clicks on this button, the image id will be stored in the database table, but it must be behind the scene, i mean without refreshing the whole … |
| | I have multiple tables, table_a, table_b, table_c. Each having the same structure. i.e ID, title, rating, content. I'm using [code=sql](select * from table_a order by rating DESC) union (select * from table_b order by rating DESC) union (select * from table_c order by rating DESC) [/code]to list all titles from … |
| | Hi, I'm trying to create a CSV file from Excel to upload into a MySQL db. It's for a web-based dealer locator called Lookup Runner. When I try to import my CSV it never works. The people at Lookup Runner (hitcode.com) did something to my CSVs and they worked like … |
| | I've created a PHP web application in Dreamweaver, which uses a MySQL database, containing 14 tables. On one page, I use an SQL query to select data from 10 of the tables in the database. However, when I try to preview the page in a browser, a PHP warning stating … |
| | I've also wanted to know which of the following is the better approach Does it actually have a difference??? where table1.userid = table2.userid using the proper join statments such as Inner join |
| | how to export mysql database table contents on to a PDF file. it has to be displayed in the website as "download/print data". when the customer click on that he/she has to get the PDF opened or an option to download the PDF with all the contents of the table. …  |
| | Hi all, Im busy moving a site from localhost to hosted server and im baffled as to why mysqli simply wont run. The following script iscalled after a captcha script has been satisfied, but it just doesnt seem to like the Mysqli. I have converted other simple mysqli scripts, but … |
| | Hi, Anyone know how to retrieve arabic Data stored in MYSQL DB which is stored using character sets Latin1 , So Arabic Data appears as Ùاسر in tables . how I can retrieve this data in proper arabic symbols in Excel 2007 throughtout using MYSQL ODBC to work on this? … |
| | I need help I want to updated table(userlogin) in MS-SQL that should synchronize with another database (MySQL) having same table name(userlogin) and also fields. I need code for this.By Procedure,PLSQL or JAVA programming |
 | Hello, I have my own website where I make programs and put them up on my web page, it has info on the programs ext.. I also allow other people to put up they just have to e-mail me with a specified template. But I want to make this easier … |
| | Hi guys! I'm designing my first site and i've stumbled on huge block. Problem I'm having is that Ajax doesn't seem to update my MYSQL table in firefox. I have two forms and two functions (each initiating a XMLHttpRequest). First is to display a MYSQL query using PHP and second …  |
| | |
| | Hi, I need to compare MySQL, MS SQL 2008 and Oracle. Do you know of any link where this comparison takes place? I found a few comparign MySQL and MS SQL 2000 but not with MS SQL 2008 and Oracle too. Can you please help? Thanks Josh |
| | Hi i am fairly new to php and am trying to make an application where some1 enters a unique id which brings up a form with data in it retrieved from the database. the user should then be able to edit the information and submit & the details changed in … |
 | Hey all, Here's my problem: php/mysql noob here. I have an admin section on the website, and I have successfully password protected all the php pages in that directory using sessions. I have included code like this on the top of each of my pages: [code=php]<?php include('login.php'); if (checkLogin() != … |
| | I have a database with about 150 tables in it. Now I wanted to copy all of the tables with something like [COLOR="red"]tablename[/COLOR]_copy at the end of each table. Also the data that will go in each of the table will be the same. |
| | I'm trying to display a certain amount of words on one page from a database entry. For ex., on my main page I want to display the first 50 words of a story then a link will lead you to the rest of the story. I kind of know what … |
| | [CODE] <?php include 'dbc.php'; $query = "SELECT * FROM em.tutor"; $result = mysql_query($query); while($row = mysql_fetch_array($result, MYSQL_NUM)) { echo "Name :{$row[0]} <br>" . "Subject : {$row[1]} <br>" . "Message : {$row[2]} <br><br>". "Message1 : {$row[3]} <br><br>". "Message2 : {$row[4]} <br><br>". "Message3 : {$row[5]} <br><br>". "Message : {$row[6]} <br><br>". "Message : …  |
| | test_imagedb_create.php [CODE] <? $dbserver = "localhost"; $dbuser = "root"; $dbpass = ""; $dbname = "em"; $dbconn = @mysql_connect($dbserver,$dbuser,$dbpass) or exit("SERVER Unavailable"); @mysql_select_db($dbname,$dbconn) or exit("DB Unavailable"); $sql = "SELECT image_type,image FROM em.testblob WHERE id =". $_GET["id"]; $result = @mysql_query($sql,$dbconn) or exit("QUERY FAILED!"); $contenttype = @mysql_result($result,0,"imgtype"); $image = @mysql_result($result,0,"imgdata"); header("Content-type: $contenttype"); echo … |
| | Hi all, I want to store the hours of restaurants in a database (sounds simple, right?). I don't want a text field where hours are entered as a lump of data, but was thinking of making a column for each day of the week and filling in the hours this … |
| | Hi. Suppose I have a list box, which is filled out from mysql, and I have a text box and a submit button. I want to add the text box data into list box and at the same time I want to have the text box data into mysql as … |
| | Hi, I have a problem. I am storing projectid (varchar) as a field in this format :- DD-NNN where DD is the last two digits of the year and NNN is the next project number within that year (i.e. 09-500 is the 500th project in year 2009). The user has … |
| | I need help on fetching data before inserting. My issue is as follow: My table fields are: serial_start_no - varchar(25) - unique key serial_end_no - varchar(25) - unique key Using JSP user will be allotted the starting number and ending number (i.e. 1. Start number – S001 and End number … |
The End.