10,946 Topics
 | |
| | Hello. I have experienced a very weird problem with my myisam table with appr. 1M rows. Query [CODE]select num,subnum from a where trip='!mOWjKAWAII' order by timestamp asc limit 10;[/CODE] executes immediately, which is just as expected. But with a slight modification: [code]select num,subnum from a where trip='!mOWjKAWAII' order by timestamp … |
| | Hi there! I'm having a very odd problem with mysql_fetch_array my code looks like this: [code] function getMachines($domain){ if (! is_resource ( $this->connection )) { return false; } else { if (get_magic_quotes_gpc ()) { $domain = stripslashes ( $domain ); } $query = sprintf ( "select machines from `domains`.`%s`", $this->escape …  |
 | Despite the fact that my script runs perfectly well on the server, it fails to submit form data into mysql database. Kindly look into this for me. see code below: [code=php]<?php> $dbcnx = mysql_connect("localhost","user_name","password"); if (!$dbcnx){ exit('<p>Unable to connect to the database</p>'); } If (isset($_POST['submit'])) { $SchoolName = $_POST['SchoolName']; $SchoolEmail … |
| | I try to connect by ODBC 3.51 and I get connection and I can get data from MySQL database and show it in my VB 2008 Express Edition, but when I want to AddNew or Update something it gives me an error property "Item" is "ReadOnly" (about my rs). This … |
| | Hello, thanks in advance to anyone who can help me with this query. What I am trying to do is to retreieve a list of all the users from the table 'users' and count how many posts the user has made. The code below will shows a list of users … |
| | Heyy, need some help here. ok, I've got my script here right. [CODE]<html> <head><title>Display Records</title> <style type="text/css"> td {font-family: tahoma, arial, verdana; font-size: 10pt } </style> </head> <body> <?php $db="aseco121"; $link = mysql_connect('127.0.0.1: 3306', 'root', '******'); if (! $link) die(mysql_error()); mysql_select_db($db , $link) or die("Couldn't open $db: ".mysql_error()); $result = … |
| | Hi, In what sql cases we should lock particular rows? Is it UPDATE and DELETE only. Thanks |
| | Hi - relatively new to MySQL & still coming to grips with its permissions system. Probably a slightly noob question - hope you don't mind! (should be easy then?) :) SITUATION: 1) I want to set up a standard set of records in my database (DB) with values that ALL … |
| | Hello, I am quite new to PHP and MySQL. Could anybody please help me with this problem? Suppose I have a database like this, [ICODE][U]Type[/U] [U]Name[/U] [U]Price($)[/U] A ABC 150 A DEF 350 B XYZ 250 B UVW 450 C ....................... .............................[/ICODE] The user is required to choose the type … |
| | Ok so what i'd like to know is how to have two where statements in a mysql delete query. I get an error if i do this: [ICODE]mysql_query("DELETE FROM user_notifications WHERE username='$acc' AND WHERE notification='$note2'") or die(mysql_error()); [/ICODE] Any help would be much appreciated, I know this is a silly … |
| | Hello to everyone. I am new in the forum, and my first post is going to be about mySQL. I am a total novice in mySQL and the problem i have is that i want to put a specific filter in reading some data. I have created a database with … |
| | HI I want to submit csv file data into mysql pls tell me how 2 do if any one has any program made to insert csv file into mysql pls give me the code i really need it pls help me bye |
| | Hi i had a mysql database ( coading in php ) in my real estate web site. It had 4 columns. 1. for ( ie, buy or rent ) 2. district 3. Type ( villa,house,.....) 5. price ( 1 lakh, 2lakh, 3 lakh ...) I need to add a searh … |
| | how to download table data from mysql table using php other than files |
| | I’m using Mysql (version : 5.0.24) which is accessed by web application developed by ASP.NET 2.0 .The version of the .net connector i’m using is 5.0.7.0 .Now the problem is the DB service is crashing unexpectedly i.e. the DB service is stopped & to be started manually. This to happening … |
| | Hello, people am glad to join this forum. this is actually my first post for mysql forum. I badly need help with the different entities and attributes to store in the database for a place location kind of system. this project is totally new to me and i just have … |
| | I'm getting the above error for the following code. Can anyone see what it is? Is my date formatting off? [code] $get_topics_sql = "SELECT topic_id, topic_title, DATE_FORMAT(topic_create_time, '%b %e %Y at %r') AS fmt_topic_create_time, topic_owner FROM forum_topics ORDER BY topic_create_time DESC"; echo $get_topics_sql; $get_topics_res = mysql_query($connection, $get_topics_sql) or die(mysql_error($connection)); [/code] … |
| | hi i have problem , rhe code is working properly on local machine but when i upload it on net then it give the warning [COLOR="Red"][B]Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home7/wyzerpmc/public_html/wyzer/survey/survey.php on line 22[/B][/COLOR] [code]<html> <head> <title>Untitled Document</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> </head> … |
| | Ive got a MySQL search, which searches an index of urls. The search parameter searches titles. What I want to do is have something like Google. So, if someone searches: [CODE]site:example.com something to search[/CODE] It would look for example.com in one column then from those results it would look for … |
| | I have a user table that contains username, password and status jobs. The user have a option to fills unemployed and employed in jobs field. My question how to make sql statement to count how many people that choose unemployed and employed. Then view the result for number of unemployed … |
| | Hi, I've searched this and other forums and found what are clearly the right answers for some people but not for me. I have a database with an item table. Item has a field called image that stores a path to an image. Here is an actual example of a … |
| | hi i would like to store the data of a text area inside mysql, and for that i want a suitable dtatype For eg if the data in textarea is [QUOTE] hello hie are you i'm fine! [/QUOTE] currently i'm using varchar but th eproblem is that the data apperas … |
| | hi, I am trying to learn how to upload multiple Music files to server then save information about them in database e.g. albumname, filename, type and maybe url. i have few questions: 1. would i be able to write the albumname in database as the folder i am uploading to. … |
| | hi how to solve this eroor ____________________________________________ Class.forName("com.mysql.jdbc.Driver").newInstance(); ___________________________________________________ this is my code ------------------------------------------------------------------------------------ [code=jsp]<%@ page import="java.sql.*" %> <%@ page import="java.io.*" %> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd" > <HTML> <HEAD> </HEAD> <BODY bgcolor="#ffffcc"> <FORM action="p.jsp" method="get" name="f1"> <TABLE style="background-color: #ECE5B6;" WIDTH="30%" > <TR> <TH width="50%">Name</TH> <TD width="50%"><INPUT …  |
| | Hi Sir.. I am Using MySQL-Front 5.0 .. I want to create a Trigger n Stored Procedure.. But I Could't Do In MySQL .. It shows an error message n ask Super privilages... My Doubt is .. Can we Do Trigger n Storedprocedure in MySql-Front 5.0 and .. If Possible,, … |
| | I will be needing to use PHP and MySQL to create a small application. But I need some help setting this up. I need to create a database for my application. I went to mysql.com, but couldn't determine what application I needed for creating my database. What do I need …  |
| | I allow a member to create new styles for a program. They can save each style to a table called style_custom. A person can have more than one style in that table and the name of each can be found in the column called name. All I want to do … |
| | Hi, I would appreciate some help, I cannot get my query to work: [code=sql]UPDATE journey j SET j.occupancy=j.occupancy-1 Inner Join passengers p On p.journey_id = j.id Inner Join shuttle s On s.id = j.shuttle_id WHERE s.id = '1' AND p.passenger_name = 'bill gates'[/code] It is used when a cancelation is … |
| | Hi, I'm new to coding (anything) and my manager has tasked me with developing a stats page for the IT dept. trouble ticket system (php helpdesk by EXOScripts.com)(MySQL database) I have laid out the table on the page but just need to populate it. the table has the following coloumns …  |
| | Hi, I get this error in my myPhpAdmin in WAMPserver 2f. [code]#1045 - Access denied for user 'root'@'localhost' (using password: NO)[/code] How can i solve it? |
| | Hello everyone. I'm a new member here at DaniWeb, but have learned a lot about PHP from these forums in the past. I'm pretty new to PHP and am having a problem with meeting a customer's request. I'm making a job logging/tracking system for a clothing company. Basically I have …  |
| | Hi I am trying to set up remote access to mysql on a headless server. From what I have read this can be done by installing phpmyadmin on the client pc. Is this all I need? I have changed the entry in my.cnf "bind = localhost" to "bind = ipofserver". … |
| | Im trying to delete records. Most delete ok but some don't and Im completly lost as to why... The information Im storing are just URLs. Could it be to do with some irregular characters within these URLs? Is there a recomended way to store a URL? Please help me out. … |
| | Can anyone see anything wrong with this. Im stuck :( [code=php] $sql1 = mysql_query("DELETE FROM spider WHERE url='$addtolist'"); if (!mysql_query($sql1,$con)) { die('Error Deleting: ' . mysql_error()); } echo "Record Deleted <br />"; $sql2="INSERT INTO list (title, url, description) VALUES ('$title','$url','$description')"; if (!mysql_query($sql2,$con)) { die('Error Adding: ' . mysql_error()); } echo … |
| | This query doesn't work. What have I dont wrong? [code=php] mysql_query("INSERT INTO list (title, url, description) VALUES ('$title', '$addtolist', '$description') DELETE FROM spider WHERE url='$addtolist'"); [/code] Heres the whole page if it makes things clearer. [code=php] <?php include('includes/config.php'); $addtolist = $_GET['add']; $open = file_get_contents($addtolist); $title = get_inner_string($open, '<title>', '</title>'); $description … |
| | I think I have a PHP configuration problem on my development machine where I am setting up a development environment which interrogates a local MySQL database from Eclipse on a Windows XP platform using an Apache server. I can execute the PHPINFO program so I have a minimal PHP system … |
| | I have tried getting my Perl 5.8.9 installation configured for Mysql. I have used cpan and PPM to get mysqlPP, DBD::mysql-simple modules. I am trying this on Windows XP with Mysql 5. Here is my latest error: C:\>perl c:\perl\test.pl DBD::mysql initialisation failed: Can't locate object method "driver" via package "DBD::mysql" …  |
| | Hi, I'm trying to create a database that stores shoes. Each shoe must have more than one size so I have created a table "mens_boot_test" with a field "size". In the size field I have an integer which holds the delimited values 1,2,3,4,5,6,7,8,9. I'm then trying to retrieve these values … |
| | Hi, i've been trying to make a simple login script php and have come across these error messages Notice: Undefined variable: pass in /var/www/vhosts/numyspace.co.uk/web_users/home/~unn_t013534/public_html/adminlog.php on line 15 Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/numyspace.co.uk/web_users/home/~unn_t013534/public_html/adminlog.php on line 18 The code i've used so far is: …  |
| | hi, i am trying to develop a database application. i am using python as front end and mysql as back end. But now i am getting some problem as "INTERNAL SERVER ERROR" while i am running my application on MAC OS x. #!/usr/bin/python import os import cgi from cgi import … |
| | Hello, Lets assume that I have the following four tables in my database: Magazine: mag_id (primary key) name (Nature, Time, etc) cat_id (reference to Magazine_Category.cat_id) Magazine_Category: cat_id (primary key) category_name (Weekly, Monthly, etc) User user_id (primary key) user_name Subscription user_id (reference to User.user_id) mag_id (reference to Magazine.mag_id) Now I wish … |
| | Hi All I'm new here and have searched high and low for an answer to my problem, and have so far had no joy. I am trying to create a if/else statement depending on the outcome of a SQL command that should be extremely simple and basic, but for some … |
| | I've had a good trawl through search and Google, but can't get to grips with a problem. I don't know if it is possible, but here goes: A friend asked me to install a few mods to his phpBB3 site. No problem. However, there were a few that required SQL … |
| | Hi, first of all Hi to all members. i have a shopping portal in which we data coming from different merchant on web of there products in CSV format. the CSV of the product come in standard Structure from all the merchant. we get these CSV at same time schedule … |
| | Hi folks, I’m planning on building a site somewhat similar to a web hosting directory and was hoping to get some input/advice on the database design from all you coding gurus :P I’d like to have two different types of users: 1) hosts 2) normal users Because of the this, … |
| | how to display formatted text, images and flash those url stored in mysql database in php? |
 | I have been learning PHP for sometimes and it is interesting. Can anyone point me to good PHP/MySQL tutorials for newbie :) So far I have been playing with simple PHP scripts like Forms etc. Thanks all |
| | Hey Guys, I'm having a very difficult time. I'm not sure exactly what to do. I have a form that contains fields for HEX, DEC value. I'm using a color picker (RGB ColorPicker 1.1) along with php5 and MySQL. All I want to do is be able to save the … |
| | Hello. I'm trying to select users from database that were last active today or yesterday...but there is a problem... When a user logs in, it stores both date and the exact time. So when i want to select user from db that logged in today or yesterday i must use … |
| | Hi guys, i have a big problem, hope you gurus in MySQL can give me a hand. I installed the following package in 2 servers that have all in common except that the server A is in a Domain, and have SQL SERVER 2005 installed. The package installs with no … |
The End.