10,938 Topics
 | |
| | 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 … |
The End.