10,946 Topics
 | |
| | What does connection.conv() means? I know that connection.conv() - set type conversion options between MySQL and Python but How to implement this in python Vinay  |
| | I need to know if anyone using vb6 has hooked up with mySQL database system without any clumsy third party drivers or so. |
| | List Of Free PHP,MYSQL Webhosting Provider at [URL="http://softwaretutorial.myitcareer.org/freephpmysqlwebhosting"]http://softwaretutorial.myitcareer.org/freephpmysqlwebhosting[/URL] |
| | Mysql info [IMG]http://kennyleitz.googlepages.com/mysql.jpg[/IMG] [PHP] <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>Untitled Document</title> </head> <body> <?php /* call this script "advs.php" */ if(!$c) { ?> <form action="advs.php?c=1" method=POST> <b>Find Results with: </b><br> Any of these words: <input type="text" length=40 name="any"> <br> … |
| | Hi, I have two fields...both are not unique, but both can't be the same. So two fields: user | fruit | joe11 apple angel bananna bobby apple jeff orange julie orange angel apple angel orange ---------- So lets say the above was my table, notice how both fields are not …  |
| | Hi, Need in brief: [COLOR="Blue"]Have 3 tables. I need to extract data from two tables and fill the third table.[/COLOR] Table structure: COM PROFILER: CREATE TABLE comprofiler ( [COLOR="Green"] id int(11) NOT NULL default '0', user_id int(11) NOT NULL default '0', firstname varchar(100) collate latin1_general_ci default NULL, middlename varchar(100) collate …  |
| | :mad: I'm currently creating a quiz program that radomly generates questions from a table in mysql........right now I have to php forms. takeTest.php..... <html> <head> <title>Test Week 13 CIS32</title> </head> <body bgcolor = "yellow"> <center> <? $link = mysql_connect("localhost", "web26", "web9660!", "sere1") or die("Error ".mysql_errno().": ".mysql_error()."<br>\nThe SQL sent was: $sql"); … |
| | Incase you are looking for tutorial for configuring apache with PHP and Mysql, I found [url=http://www.expertsrt.com/tutorials/Matt/install-apache.html]one[/url] Hope, it will be useful to you too. ;)  |
| | How do I communicate with my mysql database using VB.Net. I am trying to create an application for my employees to use. They will enter calls made, support requests, replies to those requests, and client data for our clients. |
| | I am not able to connect to remote MySQL server, using MySQLdb package. I have enough permission on remote machine with all rights set to 'Y' and Host field of USER table in mysql database has a value '%', which allows remote login. I tried using Navicat which requires me … |
| | [B]Warning[/B]: mysql_num_rows(): supplied argument is not a valid MySQL result resource in [B]/home/content/r/a/e/raeyshe/html/fanlisting/admin.php[/B] on line [B]21[/B] [B]Warning[/B]: mysql_num_rows(): supplied argument is not a valid MySQL result resource in [B]/home/content/r/a/e/raeyshe/html/fanlisting/admin.php[/B] on line [B]26[/B] [code]<? if ((!$_POST['action'] && !$_GET['action']) || $_GET['action'] == "login") { // get total member count $querycount="SELECT id FROM … |
| | [COLOR=#0033cc]Dear all[/COLOR] [COLOR=#0033cc][/COLOR] [COLOR=#0033cc]I have the following problem. I am trying to communicate with mysql through php but unsuccesfully. In the following script when i misspell the password it gives me the error message. but while it does not create the database it does not return any message. It seems … |
| | i m trying to connect jsp page to mysql. i have insatlled jsp-mysql connector. but still not able to connect to mysql. pla anybody help me. thanks |
| | |
| | Dear all I have a few questions. I would be grateful if you could take the time to answer. I have installed on windows xp home apache2, php 5 and mysqlserver 5. The [URL="http://localhost"]http://localhost[/URL] page of apache works fine. The <?php echo phpinfo(); ?> page works fine. However when i … |
 | I can't find it anywhere! :rolleyes: I want to install it onto a test Red Hat box so that I can replicate our live environment before doing an upgrade. I've scoured and scoured. If the internet had been a saucepan, it'd have very little of its copper bottom left. :lol: … |
| | Hi everyone!! I need some help with setting up a php page that calls an sql database.. here is what I want it to do? -firstly: a user must be able to log in(because under this login you must be able to get stats from this user) Then the user … |
| | I create 2 connectionsand then try to select the current active database: [code] $aaa_link = mysql_connect("host1","user1","pass1") or die(mysql_error()); $bbb_link = mysql_connect("host2","user2","pass2")or die(mysql_error()); mysql_select_db("dbname1", $aaa_link) or die(mysql_error()); [/code] However, mysql_select_db fails with error: [code]Access denied for user: "user2" to database "dbname1"[/code] What is wrong here? |
| | Hi I'm real new to php etc, and just wanted to know if there were any implications to using an IIS on windows as my server rather than apache? thanks alot...oh apart from the obvious being apache is free open source....:) |
| | [code]mysql> insert into fund_history select * from temp_fund_history where data_date='2006-06-30' and index_num between 1 and 10; Query OK, 0 rows affected (0.03 sec) Records: 10 Duplicates: 10 Warnings: 0[/code] I am really wondering why this INSERT statement is not inserting 10 records. Its saying 10 Duplicates: 10, and there is … |
| | I've been having this php/mysql problem that I can't seem to be able to fix. I'm displaying information from a mysql database on my site, but for some of the variables only half of the cases can have information in tehre that needs to be displayed on the site (e.g. … |
| | Hi ! When I want to display following code by assigning it to $res["description"] , in the following mentioned way, it works fine and displays properly. The code is : /************START CODE*****************/ <script language=\"javascript\"> var uri = 'http://impgb.tradedoubler.com/imp/img/16173558/1014659?' + new String (Math.random()).substring (2, 11); document.write('<a href=\"http://clkuk.tradedoubler.com/click?p=37983&a=1014659&g=16173558&epi=$_SESSION[UID]\" target=\"_blank\"><img src=\"'+uri+'\" border=0></a>'); </script> … |
| | Hello, I Am having problems with a simple script i wrote to login a username and password from a mysql database. i get the error **Warning**: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in **H:\steadyology\steadyology\account.php** on line **21 I ran the script on my localhost where i … |
| | Sir, I had mysql file ss.sql. Now I want upload the file in the Database. Is there any way to do the same. Kindly help me in the matter. Ashwin Perti |
| | I have a table with three columns that I want to group. The columns are driver, passenger and date. Basically what I want is something like... SELECT COUNT(*) FROM TABLE GROUP BY driver,passenger,date; However what can happen is that the driver and passenger can be the opposite on the same … |
| | hi,everyone my name uma,I use powerbuilder with mysql and have some problem.I have a table that have 2 primary key first a character and second a numeric.I create a datawindow that has 2 argument(primary key) for retrieve data.if second argument(numeric) has value more than 9 the datawindow can't retrieve data.I … |
| | Hi all, does anyone know if it affects the way google ranks a page if most of the data in php pages is drawn from MySQL? For example - a simple [B]About Us[/B] page... One page in php with all body text drawn from MySQL, versus, one page in php … |
| | I'm having problem in inserting into table. I'm inserting data from one table into another [I]insert into table1 select * from table2 where condition = expression[/I] I have 962 records in table2 for specified condition, but only 105 rows are getting inserted. Both tables are in same database. What could … |
| | I have a serious problem. I am trying to update an entry in a parent table which has three children tables which are coupled in such a way that either on delete or update they are affected. What I want is to know if there is a way to update … |
| | Hi,I can provide all the code etc if you like but this is a very general query and therefore im hopeful someone can answer without too much inconvenience caused.My position and steps so far are basically this - I built a database full of information in MS Access.I duplicated it …  |
| | Thanks so much Can anyone please tell me. I have Mysql 4.0 my users are listed by auto increment not null On the site I offer you a form to send a member a message you fill out the form. The form inputs are named = message from and user_id, … |
 | how deposit a picture to MYSQL database below is the code : <?php $id=$_POST; $photo=$_POST; if ($photo<>""){ $fp=fopen($photo,"r"); $data=addslashes(fread($fp,filesize($photo))); } $sql="insert into product(id,pic) values('$id','$data')"; mysql_query($sql,$conn) or die ("插入数据失败: ".mysql_error()); ?> but always unsuccessful! why? plz help me! |
| | Hello Pro Programmers! Can you help me, Please!!! What I want to do is let my users message each other, I have my form and message page setup I love it! It’s working the messages are going in the right ID’S in the Mysql database, BUT! It is overwriting as … |
| | I need to set ft_min_word_length=3, so that my users can perform boolean fulltext searches for words of three characters instead of four. However, I share the MySQL server with other customers of my ISP. My ISP's administrator is willing to change this system variable, [B]provided[/B] I can show him an … |
| | hi...is there anybody who has the right software for converting MSSQL to MYSQL?maybe u can share with me? please help coz im still very new to these fields. |
| | Hello, I get the error bolow on my page, could anyone with an idea tell me how to go around it? mysql_num_rows(): supplied argument is not a valid MySQL result Regards, omesa |
| | Hi, Um new to php... kindly help me on the following... <?php $action = $_SERVER; ?> <?php //if(!$_POST=='result') //{echo "<p style=' font-family: arial; color: blue; font-size: 14px;'>You are not authorized!</p>"; return false;} //$choice=$_POST; $name=$_POST; $link=mysql_connect("localhost", "root", "") or die("<p class='texxt'>Can't connect to server: ".mysql_error()); mysql_select_db("test",$link); $query="SELECT * FROM saudi_journal WHERE … |
| | ok, im not too sure how to explain this, but ill try... i have a website that a friend hosts for me on his server. it is an oscommerce website that seems to run fine. i felt that working from the webserver was a little slow for all the images … |
| | Hello Pro Programmers! Can you help me, Please!!! What I want to do is let my users message each other, I have my form and message page setup I love it! It’s working the messages are going in the right ID’S in the Mysql database, BUT! It is overwriting as …  |
| | I am using MS Excel 2003, Win XP, MyODBC driver 3.51.12.This problem is associated with the use of MS Excel with Mysql Connector/ODBC3.51.12 . Connector/ODBC was installed and tested successfully.However,I tried to import data to Excel from the MySQL database that resulted in error message "[MySQL][ODBC 3.51 Driver]User cancelled. Procedure … |
| | [LEFT]Hi. I hope I put this in the right spot, I have this friend that is making a game and now hes on the client; hes finnished the login server, char server, world server and some packets folder but when he runs it and clicks on a monster nothing happends … |
 | I have a txt file (log) that an application writes to regularly that I want to automate import into a MySql table. I intially thought about using LOAD DATA INFILE but can not use this in a stored procedure. Any thoughts or suggestions? Thanks in advance... Greg |
| | I just got this [B]Error Returned when i tryied Type the url of my site [/B] mySQL query error: SELECT e.*,b.blog_name, b.blog_friendly_url FROM ibf_blog_entries e,ibf_blog_blogs b LEFT JOIN ibf_blog_categories bc ON ( e.blog_id=bc.blog_id and e.category_id=bc.category_id ) WHERE e.entry_status='published' AND (b.blog_private=0 or b.blog_id = 1) AND ((bc.blog_id IS NULL) or (b.blog_id … |
| | I am currently running one script between two databases. This means that halfway through the script, I need to run [inlinecode]mysql_select_db()[/inlinecode] and then farther down in the code, run it again to switch back to the original database. My question, essentially, is if the overhead in doing this is hideously … |
| | I'm trying to do a MySQL Query but it doesn't work. MySQL version: 4.0.26 When I put only one argument in MATCH, it shows no error but doesn't return anything [quote] SELECT * FROM item WHERE MATCH (nom) against ('Huile');[/quote] or [quote]SELECT * FROM item WHERE MATCH (nom_en) against ('Huile');[/quote] … |
| | Hi, I'm new to this forum and hope I'm posting in the right section! I hope someone can help. I am trying to upload a website but have been advised I need to edit the includes/config.inc file. I've to edit the database name, username and password which is fine but … |
| | i want to learn asp . can i use mysql database with asp.how to connect to mysql database. will u tell me the basic asp tutorials for beginners. |
| | hello there, im doing a program of consolidate database. however, my scope is to do it automatically. so far, i have designed a timer and also codes to insert the data from excel file into MySQL database. then, my idea is whenever there is an error occured in a particular …  |
| | I need to "clean" the database so I only have data starting from 1-1-06. Can anyone help? Thanks.:) |
| | I would like to know if anyone has bench marked MySQL server, compared to Oracle. I have developed a database that will sort 1,000,000 records in less then 22 seconds (100 byte record sorting on 2 fields, and 1.3Ghz cpu). |
The End.