11,093 Topics
 | |
| | 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] … |
 | As the title suggests, I'm having trouble sorting the results of a union statement. I'm trying to sort the results by date descending and it's coming out ascending. [CODE=mysql] (SELECT a, b, c, d, e, f, date FROM table1 WHERE a=10 AND b=1) UNION (SELECT a, b, c, d, e, … |
| | hello, I'm trying to create a database in SQL Server management Studio for a project. I have created a tabel named Employee and I have 14 columns. I need to set the firts column (Emp_ID) as Primary Key (accomplished) and then generate a unique number for each Emp_ID that I … |
| | I am trying to build a small website using PHP and MySQL serve as the database. Can anyone tell me how to connect to MySQL database using PHP and is it similar to using Access because I have succeeded in doing that. Thanks  |
| | Ok if I do a simple datareader and print each row in my test column (encrypted) I get the value as expected. What I am looking to do is simply take the returned value, pass it to the Decrypt function of the TripleDES class and print the decrypted value. I … |
| | With the release of [url=http://esd.ingres.com/] Ingres Database 9.3[/url] today, the company says it's now easier for developers to migrate their application to the open source system from MySQL, Oracle,SQL Server and Sybase. It does so, the company said, through "improved accessibility of table procedures from within the query" and support … |
| | I am creating two tables with names group,phone group caontains id,name,place,phone numbers phone contains id,phone numbers my query is that phone table should accept id and phone numbers that matches group table(id and phone numbers) can one please help me . |
| | Hello, I was wondering if anyone could help as this has been puzzling me. I have a form with a few checkboxes on it and i need to store them in a database table taking on the following structure: user_id / c_id user_id being the users profile id and c_id … |
| | I was asked Suppose there is table A in DB,Suppose when we update that table,whose are two tables(Magic tables) that are updated other than table A? |
| | Hi, i created dynamic table with a help JavaScript master (Airshow) which add rows automatically and sums each added row. and so on here is my code. Please help me to send it to MySQl base via PHP Thanks beforehand [CODE]<html> <head><title>dinamik sheet</title> <script> function addrow(){ var tbl = document.getElementById('sheet'); … |
| | Here is my code [code=php] /* Create a new mysqli object with database connection parameters */ $mysqli = new mysql('localhost', 'username', 'password', 'db'); if(mysqli_connect_errno()) { echo "Connection Failed: " . mysqli_connect_errno(); exit(); } /* Create a prepared statement */ if($stmt = $mysqli -> prepare("SELECT priv FROM testUsers WHERE username=? AND … |
 | I have done this a million times before. I dont understand why this is not working through the use of a class. It is telling me that the variable is "undefined" hence contains a NULL value which is a load of *((^&$#. Anyways my code(sections of it) is below, any … |
| | Hello everyone =) I'm a Java programmer who wants to do work with databases. MySQL seems to be a popular choice, but I don't know where to start. I messed around with Derby, but I didn't really understand what was going on. If anyone could point me in the direction … |
| | I use mysql to store some time values (infact 2 at a time) Startime & end time.... in two columns. I have another column called duration which stores the diffrerce of the above two time values... I want to fill that third column(duration) when I insert the values to the … |
| | Hi to All. I have this code: [CODE=php]$query = " SELECT *FROM tabela WHERE persons LIKE '%$search%'[/CODE] For example I have row in persons column which contains "John William Smith" If I type in search filed "John William" or "William Smith" it will return result. But how to make to … |
| | Hi I was searching through the net and found this exciting web-development forum. I need to design a database for "problem" section --one of the tab in our website. The contents are It has got Table of contents: list of all chapters chapter 1 - chapter 16 and each chapter … |
| | I want to create two tables with names group,phone group contains id,name,place,phone numbers phone contains id,phone numbers my query is that phone table should accept id and phone numbers that matches group table(id and phone numbers) can one please help me . |
| | Okay idk if it's possible but I want one of my fields to have 000 as a default value and to maintain this value whenever called for. Like if I use PHP to run a query that asks for that field I want it to return "000". I'm doing this … |
| | How to write a query to retrieve the [B]last record[/B] that is entered. ???  |
| | Hey all. This is the query I'm trying to run: [CODE]select * from url_0, url_1, url_2 where url_0.url = 'http://google.com' or url_1.url = 'http://google.com' or url_2.url = 'http://google.com'[/CODE] but it is returning things that are not [url]http://google.com[/url]. why? how can I get it to only return entries that are exactly … |
| | Hello everyone. I was wondering if you could help me out. I've setup a bridge between my gaming ladders script and my vbulletin. Basically so the people registered on my forums do not have to sign up twice to use my websites features. I can manually update the database by … |
| | I have two columns with stirngs ( "String1" and "String2) . How to make string inputed in text field ($search) to be comparative with sum of the both strings ("String1String2") Something like as: [CODE]" SELECT id, string1, string2, FROM table WHERE string1+string2 LIKE '%$search%' "[/CODE]  |
| | Hi, I have this question, having two numeric values field1 and field2, i need field3 by default to be the difference between field1 and field , any idea??  |
| | how do i select a row in a table columns i dont know the name of(and find the name of it)? but i know the cell/field of the column has a value of "55" i also have to EXCLUDE ONE COLUMN that i know the name of. does anyone know … |
| | Good Evening everyone. I work for a marquee firm and i am creating a php mysql components list for the assistance for loading equipment. SO far, the user can input a marquee size (eg: 6mx3m) in a form and we search the database and output the items required for said … |
| | Hello All, Don't know if this is the right place to put this doubt. Help if possible. I have a python file that extracts data from a file and adds the required part to the database. Now MySQL has certain reserved characters, whenever my update query comes across a reserved … |
 | Hi all, When you add integer ID primary key auto increment, it automatically makes ID for you. But I was pondering on what happens after deleting a record. Does the server automatically adjust all IDs for you or it remains un assigned? For example, I have inserted as follows +------------+-------------+ … |
| | I have created a very long code on my app for checking if a record exist then insert. Is it possible for a single SQLString to check if records exist then update or insert? Sorta like [CODE] IF NOT EXISTS (SELECT column1 FROM table WHERE column1 = [COLOR="Red"]'sample1'[/COLOR]) THEN (INSERT … |
| | All, Does anyone know if there is a package available to allow PHP programmers to store their PHP Objects / Instances into mySQL, and still allow them to be searchable? ie .. not serialized? Looking forward to your responses, E,  |
| | can someone help me identify the syntax error with this code [code] CREATE TABLE IF NOT EXISTS Persons ( id_number VARCHAR(13) NOT NULL , name VARCHAR(45) NOT NULL , name_2 VARCHAR(45) NULL , name_3 VARCHAR(45) NULL , surname VARCHAR(45) NOT NULL , date_created DATE , date_modified DATE , PRIMARY KEY … |
The End.