10,940 Topics
 | |
| | 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? |
The End.