11,093 Topics
 | |
| | Hi all, I'm currently finally starting mysql and am have difficulty getting it up online. what i've done so far is correct but only for this error: Warning: mysql_pconnect() [function.mysql-pconnect]: Can't connect to MySQL server on 'www.dteeducation.ie' (61) in /usr/www/users/adv123site/home/youruser/public_html//settings/database.php on line 10 Cannot connect to database, check if username, …  |
| | Hi, I am trying to create a 'simple' admin page where certain (authorized) people can update data in the database or add new info to it. The issue i've run into is after i created the form and have all the fields how do i tell which one(s) the user … |
| | hi i have two different table,i want to select the name and id(primary key) from the first table..based on the id..i want to select the rest of the data in the second table... the below query is showing error,plz do tell me the bug. $query="select id,name from table1 where id='$id' … |
| | i currently have a database that someone else created a while ago and i have been tasked with speeding up the data entry and search functionality. currently the database is one table with the following field names: bid_id = primary key date_num = date of project proj_nm = name of … |
| | hi i have a table where dates and other info are getting inserted... i have a form where the user can select a start date end date.. based on the start date and end date ..i want to retrieve all the content stored between these dates..... |
| | I'm trying to learn php/mysql Read "php and mysql for dummies" and keep getting stuck. Can you get me through this? Regards, Kris [email]m31342@hotmail.com[/email] |
| | Am trying to develop a front-end to Mysql database. I do not intend to use it for web purposes so I do not need PHP. which slanguage can I use? |
| | Hello! I have a query with multiple table joints and where clauses. Tables are huge and query runs for a very long time. I need to run another query, which is exactly the same apart for one Where clause (first time price = "P", second time price = "S"). I … |
| | Hi, I am using a JSP from to collect data from user and then inserting those values into a table in MySQL.But it is returning 'null' always.I am able to query the DB and view the entire table and everything else is fine. But the INSERT is not working somehow!!! … |
| | I really don't have the patience for this but I'm trying to learn php/mysql and really could use some tutors. The online tutorials are a fair introduction. But I've got a big project I need to make progress on quickly. If anyone here would be willing to give me some … |
 | Example: Navigate: PHP Code Library > PHP > Sub1 > Title V Any ideas, tutorials no how to do that using php & mysql ? each category should be able to have items and more categories under it. It should use a single table to store all the category titles. … |
| | Hi Everybody, i found out that to create a trigger i have to remove the BEGIN and END and it works, but as i put an IF STATEMENT inside like this one: CREATE TRIGGER status_history_upd AFTER UPDATE ON projects FOR EACH ROW IF NEW.project_status != OLD.project_status THEN INSERT INTO project_status_history … |
| | Hi, Im only used to basic sql queries. wonder if anyone can help with the below - or at least get me pointing in the direction of the correct resource to solve. I have a table, with fields a,b,c,d,e,f I need to run a query that shows from the above …  |
| | [B]Warning[/B]: mysql_fetch_array(): 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]36[/B] [code]<? // select all unapproved members $result = mysql_query ("SELECT * FROM $table WHERE apr!='y'"); [COLOR=darkred][B]if ($row = mysql_fetch_array($result)) { [/B][/COLOR] do { // display all unapproved members ?>[/code] Line 36 is in bold, … |
| | I've two tables where their composite keys are foreign keys that references each other. table1 (projId, userId, name, add) table2 (projId, userId, status, responseDate, reason) I need to retrieve table1(name,add) and table2( status, responseDate, reason) with projId only.. my query is [CODE]Select ap.name, ap.add, p.status, p.responseDate, p.reason from table1 ap, … |
 | hi... i have setup the mysql replication but i dont know for some reason its not replicating the data.. i may be missing some configuration.. please help me... to do the same.. Thanks in advance.. Pooran Jaiswal my.cnf entries on slave server [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock # Default to using old … |
 | My hosting server is located in Texas and when I use the localtime() function, I get Texas local time rather than Massachusetts local time (where I currently reside). I want to standardize all my time information so that when I store it into the MySQL database, I store GMT rather … |
| | [COLOR="Green"]Hello ppl! Hoping all of you is great! Ok, this is this first time to deal with VS2005 C++, and I need to help me that How could connect C++ with MySQL ?? please it is really important to me! any example will be helpful. dankie in Advance.[/COLOR] |
| | hi, i want to kill all the sleep process in mysql , since it is unnecesserly taking the server memory and process.. Regards Pooran Jaiswal  |
| | I need a simple script to do the following... a form that a zipcode is entered into and when subbmitted returns the results matching the field zipid. Here is what I have but I can not get it to work... FORM <form method="post" action="http://alwaysaegis.com/cms2/content/results.php" target="_blank"> <div align="center"> <table border="0" cellpadding="0" … |
 | Hello... I'm a nOob. Sorry if this is in the wrong forum or if it's been asked... I did search but couldn't find anything. I have a job between hands I don't know if I can handle to be honest. I have to redesign this website: [url]www.tiendaxtienda.com[/url] (in spanish). As …  |
| | HI.. I want to create an webpage such that when user will enter their username and password,the data will be stored in a database(I am using MySQL).I have the code.But when i am trying to run the servlet,its showing following error: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver I have set the classpath of the … |
| | i have the following code for loading the csv file in to database dynamically. that is i want to give the file path dynamically . Dim conn As New MySqlConnection Dim myCommand As New MySqlCommand Dim myAdapter As New MySqlDataAdapter Dim myData As New DataTable conn = New MySqlConnection() conn.ConnectionString … |
| | hi i want to know whether my coding is correct because data is not getting inserted in my sql table,but it is displaying the "data inserted" message<html> <head></head> <body> <?php $uname1= $_POST['uname1']; $cname=$_POST['cname']; $caddr=$_POST['caddr']; $mid=$_POST['mid']; $skills=$_POST['skills']; $degree=$_POST['degree']; $indtype=$_POST['indtype']; $desc=$_POST['desc']; $req=$_POST['req']; $yoe=$_POST['yoe']; $sal2=$_POST['sal2']; $search=$_POST['search']; $hostname = "localhost"; $username = "uname"; $password …  |
| | Hi, The system under my program is using MySql version 4.0.18. I want to have a documentation for using [COLOR="Red"]MySql Transactions API[/COLOR] from my C program. Could you give some link? thank you.  |
| | This is an annoying error...tried re-writing the code a few times...deleting and recreating the table...etc...still the same result: " ... You have an error in your SQL syntax; check the manual that corresponds to your MYSQL version for the right syntax to use near 'desc) VALUES ( '', '1', '1', … |
| | Hi All, Newbie poster here. I have an, I guess, architectural question. I am still very much a beginner in mysql so bear with me. I have an e commerce site in which the prices of my products fluctuate very often. By default, my customers see the regular prices or … |
 | Is it possible to select day from the DATE field in a db so that it includes a zero in front of it if the day is less than 10? If so could you post the code please. Struggling and stressed...with qwerty imprinted on my forehead |
| | Hi all, I need to use MySql in a commercial website. What License should I buy MySql in? What if I reveal the sourcecode? Do guide me. thanks kararu. |
| | Hi, I have the following query i'm trying to execute: [CODE="mysql"] SELECT CONCAT_WS(' ', g.genus_name, s.species_name, i.rank, i.infraspecies_name, conf.auth1, conf.auth2 ) AS scientific_name, cn.common_name, GROUP_CONCAT(cn.common_name ORDER BY cn.common_name SEPARATOR ', ' ) AS common_names, ui.unvouch_image_src, ui.unvouch_image_alt, gh.growth_habit, gd.gen_distrib_name FROM plants AS p LEFT JOIN (genera AS g, species AS s) … |
| | Hi to all, I have a question and I hope to have an answer here. the Question is, is using MySQL DB in commercialweb site free of license or not? I know it's an open source, and to the best of my knowledge the using of open source applications like … |
| | hi, Can anyone please show me how to use siss, and how to load data using SQL Server and SSIS. thank you |
| | I'm trying to write a little wrapper for executing MySQL statements, and I've run into a wall trying to use [inlinecode]mysqli_bind_param[/inlinecode] without knowing the number of variables I'm binding. Here's what I've got: [code=php] /** * Note: * . execSQL is variadic, just like bind_param * . prepareTypeStr is another … |
| | Hi, I have this code. It works fine using PHP 4 and MySQL 5.0. but it doesn't work at all on my webhost (php4 mySQL 4) and I cannot for the life of me figure out why. Here's my code: /<? // Connect database. include("connectdb.php"); //if "Submit" button is clicked …  |
| | hi, I have only done basic sql queries and need help on this major one trying to combine many queries into one. What I need is to make the following queries into one: [code]SELECT Username, LastLogin, DateCreated, Views, MainPic, Logged FROM Users WHERE UserID=? SELECT COUNT(AlbumID) FROM ProfileAlbums WHERE UserID=? … |
| | hi all, right now i'm trying to migrate from db2 running under linux to mysql v5.1. i manage to export out the db2 structure & data into a del (ascii) file. but when i try to load the data from the del file to mysql table, it generate an error. … |
| | :?: Greetings, I am brand new to php and mysql so get out the asprin. smile I am making a php file to pull information from dat files to update my database. When I run http://www.sandpointrealty.com/read2.php I get this error Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result … |
| | Hi this might sound like a simple question to most but it is something that i have been trying for quiet a while. I have a table in mysql, which contains a name of a football match, date, time , and one of the variables is a link address to … |
 | Hi all, I am new here, (as you might have guessed :) After I get the PHP/apache thingy working Or kill myself whichever comes first I will be needed to set up a db back end I would like to pose a question to you learned folks. I notice many …  |
| | [COLOR=#000000]Hi,[/COLOR] [COLOR=#000000]I have this program written in Perl and to be tested on Linux-Fedora.[/COLOR] [CODE] #!/usr/bin/perl use Mysql; $host = "localhost"; $database = "DVDRentals"; $tablename = "Orders"; $user = "root"; $pw = "password"; # PERL MYSQL CONNECT() $connect = Mysql->connect($host, $database, $user, $pw); # SELECT DB $connect->selectdb($database); # DEFINE A … |
| | recently i created a system using php and mysql to record faults that the ict technicians could get reported faults out of. so far it does everything i want but some senior members of staff now want the front end to give a report of status, one of the things … |
| | Hi everyone. I am new to PHP and MySQL. I am trying to create an RSS feed that gets content from more than one database table. The database tables are "categories". And I want to retrieve the latest content from those categories for the RSS feed. I want to retrieve … |
| | Hey everyone, i have a Mysql database and Php setup on a linux server. all are updated. WEll i have a form in which a user can enter three words.(not all at once) to perform the search on the database. Forms and php coding shown below. I have one index … |
| | I've been configuring PHP with MySQL and ran into a few issues. I uncommented the line to include mysqli.dll and set extension_dir = "./ext". It still isn't working. Not sure if I'm missing anything. Got any clues?! |
| | Hey guys! Right heres the problem, I have made this script that basically displays all the data from a table from MySQL; pricelist. However it only displays the data when i have to manually write in all the database passwords and names and stuff, however when i use the require_once() … |
| | hi everybody, Iam using mysql.I have a login form in which user vl enter his name and password.Now when he/she types upper-case or lower-case in the username field,mysql unable to check the case.Is not mysql 4.0 not a case-sensitive.can anyone suggest how to solve it.  |
| | I am trying to use this script to enter data into my database from an html form. [code] <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <html> <head> <title>Item Entry - Opulentworx - Private</title> </head> <body> <form action="/php/itemENTRY.php" method="post" id="itemENTERdb"> <input type="text" id="itemNUM"/>Item #<br> <input type="text" id="quant"/>Quantity<br> <input type="text" id="date"/>Date<br> <input … |
| | Hi there, I wonder if you can help. I am looking for a database of UK postcodes, cities/town and coordinates. I need this data in order to construct a search portal. Where can i find such data? Many thanks, Daniel |
| | I am pulling a simple query but basing it off of a group of sums. What I want to do is pull all the information from "albums" where albumID equals "photos" albumID. Then Grouping by Photos.albumID, I want to grab the sum of all the views of each albumid, and … |
 | Hey, I'm using a while loop to display all the rows of a table in my database, and wondered if anyone knows how I can make it so the background color of each row alternates between two different colors. I'm using php to call the information, so I can stick … |
The End.