10,932 Topics
 | |
| | 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 … |
The End.