11,093 Topics
 | |
| | |
| | Thanks for your help in the past, and this forum is great. I have a question about dates, and in searching, there are huge amounts of results, but very hard to narrow it down to exactly what I'm asking. In using PHP, I have some variables pulled from mysql databases …  |
| | i am trying to get this code to work but there is something wrong with the array (not to good at these). the main part of the code works it is sending out the email but only ever to one registered user. here is the code i have so far. … |
| | Hi, I have a distributed DB , comprising of 800 db servers (huge data for a social networking company). the records are sorted in db based on user_account _id, and the table also has user's credit card number , now - given a credit card number I need to find … |
| | I'm not very good at MySQL stuff, so I need a little help with a problem I'm having. I'm trying to make a script that will open up a text file and print the contents of the list onto the screen. Additionally I wanted the contents of the file (a.k.a. … |
| | I have three tables: posts, topics, and forums. Each row in post table has a topic id and a author name. Each row in topics has an id that corresponds with the topic_id in posts, and then it has an id for the forum that it (the topic, containing the … |
| | We have integrated Paypal with our application and everything is working perfectly. But after the transaction is completed and successful we need that it should redirect to our application again. But its not happening. We have turned on the auto return option in the paypal too but its still not …  |
| | Hi, I use Ubuntu and want to restore a mysql file. How do i do it? It is on my desktop. Thanks |
| | I keep getting the following error: [b]Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource[/b] on line 17. I'm trying to figure out if there's some problem with my SQL query statement, or what. When I try to print $result, nothing is displayed. I've included my code below. … |
| | I have a query that brings though a list of passenger names, is there a way in which I can set the length of each of these names to equal 10 characters. So even if I have shorter names eg "bob, demarcus, adam and scott" they would display with the … |
| | I am using the syntax: REPLACE(str,from_str,to_str) to replace data in my table. However I have a slight issue I would like to address, when I have the following records jon | jonathon | jonas | jonny and I do the replace with REPLACE(names, jon, '') I am left with | … |
| | I have three tables: posts, topics, and forums. Each row in post table has a topic id and a author name. Each row in topics has an id that corresponds with the topic_id in posts, and then it has an id for the forum that it (the topic, containing the … |
| | i am trying to write a script that will send out an email to all the email addresses stored in a mysql db when the site has been updated. the code i have so far is as follows [CODE]$sql= "INSERT INTO $table (date, title, article) VALUES ('$a', '$b', '$c')"; if … |
 | [url]http://au2.php.net/function.mysql-query[/url] [code] mysql_query($query, $link_identifier); [/code] Which commands require $link_identifier, thought there be a list on google but to no avia. :( Thanks, Regards X PS: There not required but its good practice you use the connection string after the query string. |
| | Hi, [code]INSERT INTO money (salary) VALUES ('100,000,000.00')[/code] 100,000,000.00 is stored as 100.00 in decimal (14,2). I don't know what is wrong? Thanks |
| | There are a few: - I am trying to use it in a function within a function, which then I call the second function (mysql > function > function) ? - Using within while loops (while ( VAR mysql_fetch_aray (query)) ? So any ideas? THanks, Regards X  |
| | Hi, Data is stored like this in Varchar(2500) (with paragraphs): [code] Looking for NET developer, programmer. Required skills: VB.NET NET MsSQL XHTML If you are interested, please call "000" number's test. Thanks [/code] When i echo it, it is displayed like this: [code] Looking for NET developer, programmer. Required skills: … |
| | I know this might sound silly....please forgive on this one I am not a programmer, but simply a graphic designer, but our programmer left us,and since that, my boss (which also my father) askin me to help about this matter. This company is still looking for the replacement, but we …  |
| | Hello everyone..How do i create a user manual or the instructions of the software in vb6? Is it possible to pattern the manual with the manual of mysql or the like.. Another question. How do i populate my treeview in vb6 from a mysql database?? Any help would be very …  |
| | 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 … |
The End.