10,932 Topics
 | |
| | [CODE] Newbee in php Below is my table and script, I know it should change the password I am using a registration application the password is saved in this manner 1d7d2fcc49f157c0be4456580011a58d469c71b6 I could not make out if this is a md5. I echoed the php, the password i type in … |
| | hi, can any one tell me how to i use my sql sever's databse itno ms sql 2008 server. I tried to to do dat with the help of mysql backup file & execute it on ms sql server, but there are some syntax related problems. please help me. thanks …  |
| | Hi, Basically what im looking to implement is a function where a user performs a search on my site, and is presented with the results and an option to be emailed similar items in future. I have all the search stuff done, but have no idea where to start on … |
| | How can I create a SQL Script using MySql? I already created a database and tables. I populated the tables and wrote queries to solve the questions in my homework. But the professor want me to submit the SQL script. Can anyone help me?  |
| | I need a bit of help with a mysql join query. I have tried and tried and keep getting unhelpful errors. I have two mysql tables: friends: friend1 INT friend2 INT members: member_id INT name varchar lname varchar Basically I want to loop through friends and find all records where … |
 | Hi all, The following code should link 2 tables, showing: student id, surname, firstname, study type, start year. However, its not :-). its just a white screen. ive got php5.ini with ERROR_REPORTING (E_ALL); in it but im still getting nothing at all. The tables definitly exist! have i missed something … |
| | HI GUYS, I HAVE A PROBLEM IN FINDING OUT AN INTERFACE FOR PYTHON 2.6.3 AND MYSQL-5.1.31. IS THERE ANY COMPATIBLE VERSION FOR BOTH THE ABOVE???? WHEN I RAN THE setup.py file of MySQL-Python1.2.2 version, i got the following error. -[COLOR="Red"]-------------------------------------------------------------------------- [COLOR="Green"]This script requires setuptools version 0.6c5 to run (even to …  |
| | [CODE] <?php $host='localhost'; $user='root'; $pass=''; //establish database connection $conn=mysql_connect($host,$user,$pass) or die('Unable to connect'); //select database for use mysql_select_db('acumenchain') or die('Unable to select database!'); $query2 = "SELECT tblclasslist.studentNo FROM acumenchain.tblclasslist JOIN acumenchain.tblregistration ON tblclasslist.studentNo = tblclasslist.studentNo"; $result = mysql_query($query2) or die('Unable to execute Query' . mysql_error()); $num = mysql_num_rows($result); //close connection …  |
| | I want to set a password to [B]phpmyadmin interface[/B] in WAMP.. How can I do that?? I jst want to make sure that no one will change my databases using Phpmyadmin GUI ..() mysql console is ok..... thankx in advance.. |
| | I want to find the capacity of my data fields....how can i calculate capacity of varchar(10) or int(15)...???? (in kilobytes s or megabytes s) please help..t hankx in advance. |
| | We've had an old website move server but am having lots of problems with it, plus it's been nearly two years since I did any PHP so any help would be greatly appreciated. Have sorted some problems out but am stumped by this one. Have stripped the code down to … |
| | I currently have a table structure like this [code=sql]create table main(id int(10) unsigned NOT NULL AUTO_INCREMENT, fname varchar(25) NOT NULL DEFAULT '', `uid` int(10) unsigned NOT NULL, PRIMARY KEY (`id`)) insert into main(1, 'abcd', 1), (2,'doll',1), (3,'animals',1) CREATE TABLE category ( `cid` int(3) NOT NULL AUTO_INCREMENT, `id` int(2) NOT NULL … |
| | I'm trying to find out what the legal laws for the internet are on storing text via e-mail/chat. I am not sure if there is such a law but than again it's better to ask than to find out the hard way. Does DaniWeb keep history of Private messages for … |
| | Can you divert one database to another database if the former has crashed? My site crashed and would like to have a backup database if this happens again (hopefully not!). Thanks. |
| | Hi i have this section of code that looks for user info on another table... this code works fine querying the database locally... but i need it to work remotely can anyone see what im doing wrong... [CODE]from sqlite3 import dbapi2 as sqlite import MySQLdb as mysql from mud.common.persistent import … |
| | hello im studying dba, right now im stuck with project i have to do. Here is what bothers me. i have 2 tables one with tasks and one with salarys. Task table describes who is working on what from when how many hours on so on. Salarys gives me info … |
| | Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in activation.php on line 11 Invalid Validation Code what is wrong here? [CODE]<?php session_start(); include "mysql.php"; $c; if(!$_GET['code'] || !$_GET['act']) { die("Invalid Use Of System."); } else { $code=$_GET['code']; $cq=mysql_query("select * from confirm where code=$code",$c); if(mysql_num_rows($cq)== 0) { die("Invalid …  |
| | hey; I'm creating a image database. I want each user to register, login and be able to upload images. I however, do not know if each user needs to have their own database for images to be stored in or if I can grab the image via foreign ids from … |
 | Hi Everybody.. I installed wamp server and Mysql services doesn't start. I've found on Google Search. and nothing to solve my problem. Can anyone help me? Thanks.. |
| | Hai, I had a mysql database and it contain columns like "id" and "name". I am using the following query for selecting a name with an id . My code is [ICODE]$row=mysql_select("SELECT * FROM table where id='1'") or die(mysql_error()); $result=mysql_fetch_array($ROW); $name=$result['name'];[/ICODE] It works and my problem is please let me … |
| | hello i'm beginner with php/mysql on windows xp platform i've worked with ms sql server in which we have query analyser to work with queries, i am not familier with running queries on my sql i've installed mysql-essential-5.1.39-win32 from [url]http://dev.mysql.com/downloads/mysql/5.1.html[/url] but do not know how to operate with it please …  |
| | Hi, Can someone tell me if i can use the below query. When i click submit button SQL says: [QUOTE]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE username = 'genieuk'' at line … |
| | I am updating a conference website, and I've come across a design problem that has me stumped. I have tables for: -a company's account -person (each company can have many persons in its account) -conference sections (for example, 1-day, 2-day, or 3-day attendance) -a lookup table relating people to sections … |
| | hello daniweb users, I been currently developing a mass email html coupon system for my work and am stuck at the last part of the development, the redemption of the coupon. So it works like this: On our site, users put in the month of their birthday and email and … |
| | Hi Following is server information OS version:Linux playpen 2.6.18-6-amd64 #1 SMP Thu Dec 25 21:08:54 UTC 2008 x86_64 GNU/Linux 64 bit OS MySQL version mysql Ver 14.12 Distrib 5.0.32, for pc-linux-gnu (x86_64) using readline 5.2 By using TOP command mysql is allocated 4.5G and using upto 58.5 % Database size … |
| | I stored two time values in mysql data as 'starttime' & 'endtime'. I have another column to store the' duration '(which will contain 'endtime-starttime') Is there a way to add values to ' duration ' automatically when I insert values to 'start time' & 'end time'. I use WAMP ..I …  |
| | I have the following code to fetch images from an SQL data where a "gallery" id is set and a "artworks" id is set. BTW the "artworks" is really the images which I want to display. I am able to display the first image OK, however the "next" and "before" … |
| | Hi, I'm having trouble with writing this statement as an INSERT function instead of UPDATE. [CODE=php] $sql = " UPDATE tbl_category SET " . ($cat_parent_id == 0 ? "sub_cat_name = '$name'," : "cat_name = '$name',") . "cat_description = '$description', cat_image = $catImage WHERE cat_id = $catId";[/CODE] Sorry if this is … |
| | hi to all, this might be very simple, but i don;t know how to get correct output, someone help me to complete it... [B]1st i need to get result from this query[/B] [CODE]$sql="SELECT * FROM $tbl1_name WHERE sex='$show_all'"; $result=mysql_query($sql); [/CODE] this'll result either all the boys or all the girls; … |
| | Hello! I have been trying to make a news script where you can edit/delete news. I've looked for tutorials and tried to make mine too. But I still have some problems, and I don't know what is wrong. So, I'm posting the code here, maybe someone can help me. [code=php] … |
The End.