11,093 Topics
 | |
| | Hello, I am developing a simple calender in my site which will display the next upcoming birthday of my member. I have a table which has 2 column cname | dob ------------------- Joe | 9/12/1982 Mathew | 2/17/1997 Pat | 8/23/1880 ------------------- What SQL Query should I use to get … |
| | Below is the code I'm using to try and simply display the contents of a table...however, I'm getting the following errors: `Warning: mysql_query(): Can't connect to MySQL server on 'localhost' (10061) in d:\Customers\user######\www\dbtest.php on line 18` `Warning: mysql_query(): A link to the server could not be established in d:\Customers\user######\www\dbtest.php on …  |
| | Hello all, I am designing a website using php and My SQL. It is an educational website which has an administrator... the adminstartor shall have the apility to add, delete or modify a course. I finished a part of the website but i dont know how to begin to implement … |
| | hi , how do i migrate data from mysql to mssql.....i need some free convertor tools....can any body help me |
| | I fond some tutorial that can search one field of the table in a database,. But I would like to search the whole table.. In my table I have people's name by first name, last name, phone number etc... how can I display the whole thing as a result? For … |
| | Hi... Ok I have created a form which posts data into a mysql database. I can then read that data from the database with another page. I am trying to add russian text to the database... it says it has been added but it comes back as ????? I can … |
| | hi, I decided to build a quick forum system for my site. nothing too advanced...heres the db setup i have. create table ForumsTopics ( id int auto_increment not null, topic_id varchar(7) not null, title char(100) not null, cat char(1) not null, views char(6) not null, date DATETIME not null, last_mod … |
| | Hi all, I try to compile my program and got this kind of error: test6.c: In function `main': test6.c:46: too many arguments to function `mysql_query' Here is my code: [CODE] int main(int argc, char *argv[]) { char string1[1600], string2[1600], query[1600], mobileno[50]; int i, j, len; FILE *fp2; mysql_init(&conn); /* Connect … |
| | [INDENT]I recently bought a piece of software and am having a hard time installing it. The instructions tell me to: 1.create a database on my [URL="http://www.computing.net/dbase/wwwboard/forum/126.html#"][COLOR=green][COLOR=green! important][COLOR=green! important]server[/COLOR][/COLOR][/COLOR][/URL](I have cpanel) 2.create a user 3.Enter this information in dbsetup.php file 4.Create a directory and ftp the files in the public_html folder …  |
| | Hi, I have one doubt in mysql command using limit. I want to delete a first record in a table using mysql query. I using the below query DELETE from view_me where member_id = '$sess' LIMIT 0,1 But if I used the above query mysql cannot deleted the record. It …  |
| | about VC+MySQL problem:) i install mysql odbc V5.0 driver i need to ADO Connect MYSQL DB; code: _ConnectionPtr m_CMConnect; ::CoInitialize(NULL); m_CMConnect.CreateInstance(__uuidof(Connection)); m_CMConnect->Open("Provider=MySQL;server=localhost;DataBase=test;port=3306;uid=root;pwd=","","",-1); but Program run error..... how to Ado Connect MYSQL DB; thank:) |
| | How come MS SQl Server 2000 does not have an autonumber datatype as like MS Access does? Any alternative? |
| | Hi, I am trying to insert a record in a mySQL 5.0 database through a JSP. I am getting an error that the format is invalid. I don't know how to manipulate the code using Java itself. Can anybody guide me? Thanks VDhara  |
| | hello can anyone tell me how to insert the NULL value into a field? |
| | Hello I am using mysql with html to create a webpage I have a table called people This table has 2 fields, first_name and second_name I have 5 records in this table I want to select this information out of the MYSQL database and into fields on a form These … |
| | I'm real stuck on a php jump script. Basically a value is called from my .html pages; somthing like this: <a href="jump.php?m=c"> which looks at the jump.php page and redirects the user. I track the number of clicks in a MySql database. I want the code to check the database …  |
| | Hi..plz..help me with the installation of mysql rmp for linux system...the purpose of my download is i am connecting my system to the router and trying to monitor the attach and any pre signature of the attack..plz..tell me the website address to downlaod and the version.. |
| | Hi, I'm trying to include non-lating characters in a jsp application, is there anything I should know about? because leaving it alone just doesn't work, setting the page content to "UTF-8" or any other encoding just doesn't work......what else is there? I noticed that the sun forum (my application is … |
| | Hi I'm using JSP with Mysql.The Compile time no error.but in the run time the exception has been thrown, java.lang.ClassNotFoundException: org.gjt.mm.mysql.Driver i've set the classpath as well and i've attached jar file in the tomcat lib directory These are the class path settings C:\Program Files\Apache Software Foundation\Tomcat 5.5\common\lib\servlet-api.jar;C:\Program Files\Apache Software … |
| | UPDATE: MY COMMENTS POST BUT NOTHING ELSE? I have a form that collects firstname, lastname, email, attachment(file), and comments. I can query from my database, but when i submit data the fields are BLANK? What is going on? Below is sql on export. Table structure for table `clientlist` -- CREATE … |
| | Hi to all :cheesy: The Problem::-| ======== I was wondering if someone could perhaps help me with a problem i have for a while now. I want to use two dropdowns and a submit button. Sounds pretty easy, but when php and mysql comes in, then it gets a bit … |
| | Hi all, I am having trouble working out how to pull up shipping options from a table based on two parameters, countryID and productCode. I have the following 2 tables: [B]ECOMMERCE_shipping[/B] shippingID countryID productCode cost1to2 [B]SYSTEM_countries[/B] countryID countryName What I want to do is feed it say, 3 product codes … |
| | ok, well i know sql well but i am new to MySQL, learned that(mysql) few months back. however i have installed a new software called Altova DatabaseSpy to make my work much easier. Its working with all other databases Oracle, MSACCESS and all but not running or connecting with MySQL. … |
| | Hi Folks, I am Doug Malsbury, a B.S. degree Chemist and PC compatible Systems Analyst. I am 58 yrs old and getting started learning PHP and MySQL on my own. I will be browsing around here looking for hints and suggestions I can use in my efforts to learn creation … |
| | Suppose I have this two tables; Modules and Student Modules has the following fields [LIST]Module_Code(Primary Key) [/LIST]Module_Name Student has the following fields [LIST]Stud_Number(primary key) [/LIST]Stud_FullName My problem is that I want to include the Stud_Number on the Modules table to make it a primary key. Can anyone show me the … |
| | I NEED HELP PLEASE PLEASE PLEASE THE PROBLEM IS [B]Warning[/B]: mysql_num_rows(): supplied argument is not a valid MySQL result resource in [B]/mounted-storage/home23a/sub003/sc21979-KVVZ/www/ghhookup/functions.php[/B] on line [B]28[/B] [PHP]<? $conn_id; $sql_res; $sql_res2; $sql_query; $HTTP_REFERER=$_SERVER["HTTP_REFERER"]; $REQUEST_METHOD=$_SERVER["REQUEST_METHOD"]; function sql_connect(){ global $conn_id,$sql_host,$sql_user,$sql_pass,$sql_db; $conn_id=mysql_connect($sql_host,$sql_user,$sql_pass); mysql_select_db($sql_db); } function sql_execute($sql_query,$wtr){ global $conn_id; $sql_res=mysql_query($sql_query,$conn_id); if($wtr=='get'){ if(mysql_num_rows($sql_res)){ return mysql_fetch_object($sql_res); } else … |
| | Is there an open source script of some sort, or can how can I make something that takes a backup of a give MySQL Database and every day it daves a .gz of the database toa directory on my server, so it is backed up automatically every day....:cheesy: Thanks for … |
| | I have two tables: tb1: ID USERNAME 1 u11 2 u12 3 u13 tb2: ID USERNAME 2 u12 My question is how to retrieve records from tb1 and exclude one that is in tb2, so the result will be: ID USERNAME 1 u11 3 u13 Any comment? Thanks in advance. |
| | I NEED HELP PLEASE PLEASE PLEASE THE PROBLEM IS [B]Warning[/B]: mysql_num_rows(): supplied argument is not a valid MySQL result resource in [B]/mounted-storage/home23a/sub003/sc21979-KVVZ/www/ghhookup/functions.php[/B] on line [B]28[/B] [PHP]<? $conn_id; $sql_res; $sql_res2; $sql_query; $HTTP_REFERER=$_SERVER["HTTP_REFERER"]; $REQUEST_METHOD=$_SERVER["REQUEST_METHOD"]; function sql_connect(){ global $conn_id,$sql_host,$sql_user,$sql_pass,$sql_db; $conn_id=mysql_connect($sql_host,$sql_user,$sql_pass); mysql_select_db($sql_db); } function sql_execute($sql_query,$wtr){ global $conn_id; $sql_res=mysql_query($sql_query,$conn_id); if($wtr=='get'){ if(mysql_num_rows($sql_res)){ return mysql_fetch_object($sql_res); } else … |
 | Hi, I'm currently doing a registration module for my project. When user click submit button, I want to compare all the existing UserName in the database and the UserName enter by user to see if there have any duplication. If the UserName already exist, user is require to change UserName. … |
| | why does [code]$sql = 'SELECT userid FROM `phplist_user_user_attribute` WHERE `attributeid`= 7 AND `value` LIKE "68104"'; $query = mysql_query($sql);[/code] find 23 records, but [code]$testvalue="68104"; $sql = 'SELECT userid FROM `phplist_user_user_attribute` WHERE `attributeid`= 7 AND `value` LIKE "$testvalue"'; $query = mysql_query($sql);[/code] finds none? Shouldn't they be the same? Can I not use … |
| | Can anyone help..... When I search on my site this is the error I get [QUOTE] [B]Warning[/B]: mysql_num_rows(): supplied argument is not a valid MySQL result resource in [B]/mounted-storage/home23a/sub003/sc21979-KVVZ/www/ghhookup/functions.php[/B] on line [B]28[/B][/QUOTE] This is a peice of the code from function.php [QUOTE]if(mysql_num_rows($sql_res)){ return mysql_fetch_object($sql_res); } else { return ''; } … |
| | Hi All. I have a very large single-table database of articles that I want to convert to a multi-table, relational database. The existing single-table database contains fields for article author, article source, and article category, where several 'author', 'source', and 'category' IDs repeat dozens of times for hundreds of different … |
| | I have a simple database for hockey stats for my son. I can enter data into the db and pull it back, but I wanted to have points, which is goals + assists, displayed without entering into the DB. I enter both Goals and assists into the database and display … |
| | Hi! I'm doing a small website with some mysql and php, and have difficulties with doing a login site. I have the form sending the username and password, and this site should check them. Here's the code: [php] <?php session_start(); if(!($connection = mysql_connect("host","user","pass"))) die("Can't connect to database."); if(!(mysql_select_db("db", $connection))) die("ERROR … |
| | Hello, I'm building a website like MySpace, the address is [URL="http://pantarei.awardspace.com/"]http://pantarei.awardspace.com[/URL] the website is wrote in Italian. It has members customizable profiles, internak message system, search user tools, a forum and a chat. I just builded the main forum page but I have a problem that I cannot solve. The … |
| | hello has anyone installed and uploaded phpadmin through dreamweaver. can anyone explain to me how? im a bit stuck |
| | Greetings All! I would like to get some feedback to all ya good python folks here at daniweb regarding some implementations that you guys doing with Python and using MySQL db. I'm looking for some mysql plugin for python. I've tried sourceforge 's mysql-python but with no luck(installing) .. maybe … |
| | I am new in the forum. Actually i am not sure where to post this tread too. But i am wondering if anyone can kindly help me to understand Microsoft Solution Framework more.(MSF) From what i know, its a software installed in your computer to act as a server. And … |
| | Hi everyone, I feel like such a dumb*** because I don't know how to make automatic database backups. I would love to make backups every 3 days or so. Perhaps 3 times a week would be good, not daily though. I'm using MySQL and Windows and my current method of …  |
| | Hey. I wish to develop a website for team members which has features as listed below. I am impressed with [URL="http://www.evolt.org/PHP-Login-System-with-Admin-Features"][COLOR=#0000cc]http://www.evolt.org/PHP-Login-System-with-Admin-Features[/COLOR][/URL] resource source code which is freely available and I am thinking to use that as reference. I need small help and they are - 1) Password protected login for … |
| | Hi, Is there any freeware to convert mdb format to mdf format? When converting mdb to mdf, why does it keeping prompting for server name , then user then password. Even thou i'm converting it from local server....without having to use the lans connection. Is there any other way of … |
| | MySQL version 4.0.27-standard I want to write selected columns from a table to a file in my web site I've written the following SQL statement, but I'm unsure about the syntax SELECT event, location, eventTime, eventDate FROM commingEvents INTO OUTFILE '/home/_wmevents/public_html/wmEvents.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '\"' LINES TERMINATED … |
| | Hello, I have a database in Access, and I know SQL coding for it. So i wrote a query that would get different things from database and put it all together in a nice table.. I update the database, it updates the output from query. I also have a website, … |
| | Hi, I need some help here. Can i actually link all my access form to website? How can this be done? Please help. Thanks. |
| | How do we go about doing a query under SQL server? And can i actually use the form in access to link to the tables on SQL server? Please advise. Thanks. |
| | hi, In recently, I have a mission for porting a source code from Pro*C. And the database is changed from Oracle to Mysql. The part of original source code(Pro*C) is shown below: char i_id_no[13+1]; char accn_name[16+1], account[7+1], b_no[20+1], code_type[1]; int ii; : : EXEC SQL DECLARE cursor_1 CURSOR FOR SELECT … |
| | What is the most popular scripting language on the internet? what is the most popular Database? |
| | Good day everybody! Could you help me on how to install mysqli extensiton in PHP ver 5? Thank you in advance. Regards to all, Roland |
| | I appreciate in joining the forum of PHP Web Designers/Developers and had started working with PHP & MySQL recently. Being a person affilated with embedded software areas for last 5 years, recently being told to join a new team within my organisation and told to come up with a webpage … |
The End.