11,093 Topics
 | |
| | I bought this website script from someone, it is a website that has free graphics for a popular social networking website. Since I do not know PHP/MYSQL I do not know how to upload my own layouts, graphics, etc, to my website. So I want someone to help me create … |
| | i have been getting this problem n this is getting into my nerves.. it works fine on the web.. but i need to present it on the intranet tomorrow "sunday" it gives this damn error. of mysql_fetch_array.. can u plz help me CODE: <div id="right_nav"> <div id="cga_events"> <div id="navtop" align="center"> …  |
 | Hi! I have a problem with this line: GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, LOCK TABLE ON test.* TO user1@localhost IDENTIFIED BY "abcdef"; Here is what I do: [CODE=SQL] >mysql -h localhost -u root -p Enter password: ******* Welcome to the MySQL monitor. Commands end with ; or \g. Your … |
| | I'm using MySQLdb. Alright, I'm doing [code=python]import MySQLdb as mysql db = mysql.connect("localhost", "root", "password", "database") cu = db.cursor() rows = cu.execute("INSERT INTO users (user, pass) VALUES ('test', 'test')") print "rows affected:", rows cu.close();db.close()[/code] Well, what happens is, it gets executed and prints "rows affected: 1" BUT when I check … |
 | Hello experts could someone tell me how can i combine multiple records into one value. Sample in MS Access: (Lastname & "" & "," & " " & Firstname) AS Name How can i do this in MySQL?..tnx in advance |
| | 1. $q="Select SQL_CALC_FOUND_ROWS * from post_resume where ind_type='$industype' and career='$careerlevel' limit $cps, $rpp"; 2.$q="Select SQL_CALC_FOUND_ROWS * from post_resume limit $cps, $rpp"; hi i am doing paging in php.the first query is not working.the second one is not working........please do tell me the error. [CODE=php] <html> <head> <title>Record Set Paging with … |
| | Ok, I've had enough of looking at the same piece of code now. Someone please enlighten me as to what simple bloody thing it is I'm missing: [code=php] $pp2 = $_REQUEST["pp"]; $io2 = $_REQUEST["io"]; $sn2 = $_REQUEST["sn"]; $re2 = $_REQUEST["re"]; $sd2 = $_REQUEST["sd"]; $ed2 = $_REQUEST["ed"]; $dp2 = $_REQUEST["dp"]; $rn2 … |
 | Iam facing a wierd issue with ASP.NET and MySQL. My ASP.NET site hangs pediodically. After it hangs none of the pages open. But other sites on the same Server still works. The only way to bring the site back is by restarting the WWW service or by restarting the server. … |
 | Hi everyone I have a csv file with data such as first name, surname, tel etc and I'd like to populate a table inside my MySQL database automatically. So far I have this but I keep getting an access denied error and I don't know why: [code=php]<?php $server = 'localhost'; … |
| | I have successfully uploaded images into mysql database, but now I want to display the images alongside other row data in html page. Thanks for your previous help. Austin. |
| | Anyone know where I can get a free MySQL database so I can start the learning process for myself? I saw a post listed here for dbfree.net.. that post is old.. that takes you to IX Webhosting. I signed up for db4free.net but when I goto login it says "Loading" … |
| | Hi there I posted this problem in the php forum thinking the issue was something I had done wrong with my PHP but is now looking like a MySQL or possibly a technical computer error altogether: [url]http://www.daniweb.com/forums/thread108602.html[/url] Could someone please help me out. |
| | Hi guys, I am trying to find a solid optimization technique for my problem. I have two tables that grow quote large: [code] CREATE TABLE `mydb`.`xm_artist` ( `artist_id` int(10) unsigned NOT NULL auto_increment, `artist_name` varchar(255) NOT NULL, PRIMARY KEY (`artist_id`), UNIQUE KEY `index_artist_name` USING BTREE (`artist_name`), FULLTEXT KEY `fulltext_artist_name` (`artist_name`) …  |
| | hi i am learning to work with mysql and c. i want to select a particular row from database which must be equal to a variable and the variable should be given by user.the program is in c where i use c api to connect sql database. how to join …  |
| | I have been running SPybot and Adaware, but have some spyware that keeps returning. Spybot was unable to remove Clever IE Hooker. Here is my hijack this log: Logfile of HijackThis v1.98.1 Scan saved at 2:31:26 PM, on 9/24/2004 Platform: Windows XP SP1 (WinNT 5.01.2600) MSIE: Internet Explorer v6.00 SP1 … |
| | I've got two tables - members and sponsor, their simplified structure below. members: id_num program_id sponsor_program_id sponsor: id_num sponsor Some of the members in members table are sponsors. I need to update the field sponsor_program_id in all records in members table with their sponsors program_id field. Sponsor table tells me … |
| | I was sticked in showing images from mysql, and another thing, if the user gives a single image , can we give a thumbnail on its own plz reply soon  |
 | [code=php] <?php // connection to MySQL server mysql_connect('localhost','root','root'); mysql_select_db('administration'); // *** Validate request to login to this site. //session_start(); $loginFormAction = $_SERVER['PHP_SELF']; if (isset($accesscheck)) { $GLOBALS['PrevUrl'] = $accesscheck; session_register('PrevUrl'); } if (isset($_POST['username'])) { $loginUsername=$_POST['username']; $password=$_POST['password']; //$MM_fldUserAuthorization = "level_usr"; $MM_redirectLoginSuccess = "validated.php"; $MM_redirectLoginFailed = "index.html"; $MM_redirecttoReferrer = true; //mysql_select_db($database_connBlog, $connBlog); mysql_select_db($database, … |
| | Hi. I have a little problem. i tries to connect to a datasource defined in Tomcat context. But when i run the jsp page i got an error telling that the driver i not found. I'm using the mysql jar 5.0.x whitch i have placed under Catalina common lib folder … |
| | Hello- I have these two tables: [code] CREATE TABLE ampref ( ampref_id serial NOT NULL, amp_id integer NOT NULL, code character varying(255) NOT NULL, description text ); CREATE TABLE amp ( amp_id serial NOT NULL, name character varying(255) NOT NULL, description character varying(255), url character varying(255) ); [/code] ...and I'm …  |
| | I installed script .It was working fine since one month but today this error is coming.Please be advice. Thanks [URL="http://www.marketdayafrica.com"]Link[/URL] [ICODE]SELECT a.*, UNIX_TIMESTAMP(a.createdon) AS timestamp, ct.cityname, COUNT(*) AS piccount, p.picfile, scat.subcatname, cat.catid, cat.catname FROM clf_ads a INNER JOIN clf_cities ct ON a.cityid = ct.cityid INNER JOIN clf_subcats scat ON a.subcatid …  |
| | Hi Guys, This is probably the most silliest of questions, i am still learning php and mysql :-| . I have this code below which brings up data from the database and displays it, what i want to do is to give the table headers a bgcolor how do i …  |
| | I new to mysql and I need a free mysql developer software ? |
| | I am getting this error message [code]Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'dorcas'@'localhost' (using password: YES) in C:\myweb\dbmysql.php on line 2 Error connecting to database [/code] when i run this code[code] $con = mysql_connect("localhost", "dorcas", "dorc123") or die("Error connecting to database"); $query = "CREATE DATABASE chene"; $result = mysql_query($query); … |
| | i am getting the aboe error in the code given below <html><head> <title>MySQL Server Information</title> </head><body> <h1>MySQL Database Server Information</h1> <?php $DBConnect = mysqli_connect('localhost', 'root', 'mrityunjay'); echo "<p>MySQL client version: " . mysqli_get_client_info() . "</p>"; echo "<p>MySQL connection: " . mysqli_get_host_info($DBConnect) . "</p>"; echo "<p>MySQL protocol version: " . mysqli_get_proto_info($DBConnect) … |
 | Hello everyone! Im just a newbie here, and i really need help from you guys. We have a project in our school right now... i want learn how to implement a simple "Post Messages and Announcements" using PHP and MySql in my site. Kind of like a miniforum where the … |
| | Hi, I want to create a table in Mysql but i receive an error. [COLOR="Red"]Warning: mysqli_query() expects parameter 1 to be mysqli, null given in C:\wamp\www\CreateTable\create.php on line 11 Table veriler_2 couldn't been created! : [/COLOR] i give you the whole lines to check it for me. I can not …  |
 | Pliz help me for an efficient tagging system such as for images, articles, products etc, so that it could be easy for tag-could and relevancy searching for my web site. (php/mysql) |
| | Hello, I would first like to thank everyone for their help so far, i really appreciate it. Well, i have been learning perl for my job now for about three weeks. Things have gone pretty well so far. I have written a few scripts here and there. However, i have … |
| | i have acode that upload file from client to web server but i need to insert the file name into DB (mysql) to get it in download list............HOW? this is jsp code <%@ page contentType="text/html;charset=windows-1252"%> <% response.setContentType("text/html"); response.setHeader("Cache-control","no-cache"); String err = ""; String lastFileName = ""; String contentType = request.getContentType(); … |
| | Dear all I have a few questions. I would be grateful if you could take the time to answer. I have installed on windows xp home apache2, php 5 and mysqlserver 5. The [URL="http://localhost"]http://localhost[/URL] page of apache works fine. The <?php echo phpinfo(); ?> page works fine. However when i … |
| | I've got a Perl script that lets a client of mine dump and restore his inventory database. It has worked fine for years, only I recently noticed strange file results. Instead of dumping the data to the file, I found this (I've munged the db name): -- MySQL dump 10.10 … |
| | Using PHP on my registration page to register users on my site. Everything seems to be working properly from a PHP perspective. It even tells the user that they've been added. But when I view the table it only has one record which is the one that I created when …  |
| | hi, im trying to view my php page on the browser on iis and i got this error : [COLOR="Red"]call to undefined function mysql_connect().[/COLOR] im not sure why this happened, tried googling but found only solution on apache. any help would be appreciated.thanx |
| | I am a Newbie To PHP!! I used maestro php myqsl to crate the code below.. I am trying to change the query to include a where statment: "where Product_Category = Acoustic treatment" everytime i edit it i get a syntax Error!! please can you help? Thanks in advance [CODE]<?php … |
 | Hey everyone, I'm using php to delete a row from a table in a database in mysql, but it's not working. I'm not even trying to do anything fancy, just delete one row. Here's the code: [PHP]<? include 'config.php'; $recordid = $_POST['recordid']; echo $recordid; mysql_query("DELETE FROM employees WHERE recordid='$recordid'") or … |
| | hi folks, I have installed PHP 5.2X on apache and mySQL 5.0. PHP on apache is working fine. can anyone tell what exactly are the steps to configure PHP to mySQL ? thanks in advance, nikhil |
| | I'd been trying to do date range comparisons all day, and found that using sql was the only way to find out if a date (inside a table) was between a range (assigned by me) I have 4 of the statements below, one for each season. [code] $strSQL = 'SELECT … |
| | |
| | I am trying to add users to my MySQ table "users" and for some reason I can only get one record added into the table. It tells me that the user is added but when I check the table I still only have the initial record in there. Please Help... … |
| | how can i generate a data report using vb 6 and mysql...? |
 | So I'm not happy right now ... just woke up to an IM on my screen that Sun is buying MySQL. Look what Sun did to Java. Good or bad move for the developers out there? Cheers  |
| | I am working on a product reviews site using php and mysql, and have a table set up for product data, as well as review data. I am trying to get a list of top rated products within the last 24 hours to show up on the front page. This … |
| | Hello I am really new at this and are having trouble with MySQL updating .php files in the database program I am using. This used to work until I changed some of the .php file. I only changed the front end of these files and cannot see why what used … |
| | Hi all, I want to add a string and a character to two columns of a sql database table. To do that I use a Command object rather to use the same connection on different functions. At the same time used a stored procedure to add data. Hear are some … |
| | I have a standard SELECT query as follows: [code=MySQL]SELECT eid, title, content, thumb_image FROM diary ORDER BY eid DESC LIMIT 3[/code] ...and a SELECT SUBTRING query as follows: [code=MySQL]SELECT SUBSTRING(content, 1, 200) FROM diary[/code] I'd like to combine the two so that it selects the latest 3 entries in the … |
 | Hello all, i have recently finished work on a clients database. they now wish for one field in the database to have 10% taken off for each record. can this be performed soley through an SQL statement on the MYSQL database. |
| | Hi guys and gals Just curious to know if it's possible to select the 3 latest entries in a table. Would be an added bonus to my project. ;) |
| | Hi there What I'd like to do is store a paragraph in a column and pull roughly the first 200 characters of the paragraph and display them on a page as a snippet. Is this possible? If so could someone give me a link or code snippet on how to … |
| | Greetings, I am triying to diplay morethan one column from mysql database by limiting the display into three rows. I want all the row data to be shown as column data. I want the data in the fourth, fith and sixth row to be diplayed in the next columns, and …  |
The End.