456 Topics
 | |
 | I'm thinking of going down the route where members can actually get paid to answer questions. Here's how I am thinking the concept might work, and you tell me if you think it makes sense: Currently, when you create a new thread, you can donate $1 to have the article … |
 | Hi Everyone, Got a really strange problem with a mysql select query not displaying results in select dropdown. I have a small db table id,position,name and I am trying to display just the names where the position is GK Here is my query $result_dglass = mysql_query("select name from team where … |
 | i have a simple php login script with session but all i get is just a white blank page after running my login,php script. Here is the login,php page <?php error_reporting( E_ALL ); ini_set( 'display_errors', 1 ); include('connect.php'); session_start(); if (isset ($_POST['submit'])) { $UserName=$_POST['uname']; $Password=$_POST['pswd']; $result=mysql_query("select * from bizness_profile where … |
| | Hello everyone, So I have a quick question. Back when there was something written by BoFen and it was called codegenie and I have a copy of it and i've been using it with some success. What I'd like to know is are there any good api spies that generate … |
| | Hi Team, I have a piece of code like below which works correctly in Windows Xp (Ie 7) but when i try it in W7(IE 11) rendering is wrong, when the application first loads the select menu is rendered correctly but when i select an option and again try to … |
| | I am building a url shortner application in php and mysql and i am using the follwing logic to create short urls, pls tell me how is it First i fetch the last id from the database using select max(id) from urls then suppose if it returns 100 then i … |
| | hey guys. i have this table that lists contacts that are stored in database. the data is selected from 2 tables using join which i have already got working: SELECT c.contact_id,c.salutation,c.fname,c.lname,c.dob,c.houseadd,c.personalno,c.officeno,c.email,c.spouse,c.child, s.spouse_id,s.s_salutation,s.s_fname,s.s_lname,s.my_spouse FROM contact1 c LEFT JOIN spouse1 s ON c.contact_id = s.my_spouse what im having trouble with is selecting … |
| | hello. I have a table populated by name. The names are links when clicked will pop up a form for editing. each input (for editing) is populated by the equal value from database but im having trouble with one particular text box. this text box is for date of birth … |
| | Hello All. Been playing around with some linked dropdowns. It seems to be a recurring theme here on DW, so I thought I'd offer this up as a possible solution or for discussion, to see how it could be improved. The premise for this set of linked dropdowns is that … |
| | hey guys. I've always had problems when it comes to getting data from multiple tables in a database and so now I have another one. I want to get data from 3 different tables: contact1, child1 and spouse1. columns in contact1 where i want to get data from: contact_id | … |
| | Hi, I need to retrieve only 1 row for each 'message_id', with the Latest Date('sent_date'): ------------------------------------- message_id | sent_date | ------------------------------------- 805 | 2010-08-04 17:48:24 | <--- 805 | 2010-08-03 17:48:24 | 1007 | 2010-08-07 17:48:24 | 1007 | 2010-08-09 17:48:24 | <--- 1007 | 2010-08-08 17:48:24 | ------------------------------------- The … |
 | hi i am a vb with datagrid view on it displays all the data from my database however i want to put a option to add where the user can select the date from when to when and it displays the data. at the monet i have use this code … |
| | Hi guys I tried to to use inner join on 5 tables it worked but the problem is instead of getting the exact sum values it got doubled. Here's my code cmd = New OleDbCommand("SELECT om_list.invoice_no as invoice_no, om_list.internal_id as internal_id, om_list.customer_id as customer_id, om_list.account_name as account_name, om_list.seller_name as seller_name, … |
| | Whats wrong with this query? For example $brand holds the value 'apple' Then I get the error 'unknown column 'apple' Can anyone see the problem? if(isset($_GET['brand']) ? $_GET['brand'] : 0){ $brand = (isset($_GET['brand']) ? $_GET['brand'] : 0); $sql = mysqli_query($link, "SELECT COUNT(id) FROM products WHERE brand = $brand AND status … |
| | I have this assignment due this weekend and I was able to figure it out but for some reason the last part of my output is going up to 38 and I have no clue to way it would be doing that any thoughts to way. my output: output: PRINTING … |
 | Is it possible to change the default color (blue) supported by browsers when you hover an <option> on a <select>? |
| | Hello World, I have a problem. I want show 2 images or 2 link videos or 1 images 1 link videos together but image/videos not appear, because 2 difference class. class "img1" and "img2" #image <img alt="" title="" class="img1 or img2" src="images/<?php echo $vx->picture?>"> #video <a href="http://www.youtube.com/watch?v=<?php echo $vx->video?>" class="img1 …  |
| | **Parse error: syntax error, unexpected T_VARIABLE in this line "$validate_user_information = sqlsrv_query "select * from `userinfo` where `badgenumber` = '"$user_ssn"'";" //Login Page Starts here elseif($_POST["page"] == "users_login") { $user_ssn = trim(strip_tags($_POST['badgenumber'])); $validate_user_information = sqlsrv_query "select * from `userinfo` where `badgenumber` = '"$user_ssn"'"; if(sqlsrv_num_rows($validate_user_information) == 1) { $get_user_information = sqlsrv_fetch_array($validate_user_information); $_SESSION["VALID_USER_ID"] …  |
| | Hi, I want to display the department no. and the no. of employee in each department from EMP Table.(in a Single Row). Pls help me how to write the query for that. I had one query which display the result in 3 rows. select deptno, count(*) from emp group by … |
| | I have two tables with column name price I want to order by price from both columns so if is in first table 100eur and in second is 200eur I want to order results like this: 200, 100 SELECT a.price, b.price FROM table1 AS a INNER JOIN table2 AS b … |
| | Hi, Could anyone please tell me how to apply conditions on columns whihc are not a part of 'group by' clause? For example, I wish to filter out those sections wherein the eldest member of a family is a male and has the value 'M' in its gender field.... select …  |
| | hi i need to show employee attendance based on device logins with employess various information like department,designation,device_person_id,person_id,logid etc..... joining 3 tables i.e dbo.tempdevicelogs,dbo.employee_settings,dbo.persons_profile i tried this one Select Device_Person_id,personal_id,Date1,( cASE WHEN eXISTS( SELECT Device_Person_id FROM tempDeviceLogs AT WHERE T.personal_id=AT.Device_Person_id AND T.date1=AT.logDateTime ) then 'P' Else 'A' End )as Status FROM …  |
 | hy i have question i have this code and i whant to print it one by one not all the page the script is <?php $qry=mysql_query("SELECT * FROM articles order by articles.id DESC ", $con); if(!$qry) { die("Query Failed: ". mysql_error()); } /* Fetching data from the field "title" */ … |
 | Hi All, As usual I here with a PHP & MySQL problem. Most of you know, I am developing Music Download system. Today I have created Widget to display last 5 songs. <?php include('datab.php'); $get = "SELECT * FROM `songs` ORDER BY `id` DESC"; $getres = mysql_query($get) or die(mysql_error()); if(mysql_num_rows($getres)> … |
| | Hello please help me troubleshooting this. i got this error in my login.. pleaaaaase. below is the **error** that prompts me when i login: PHP Warning: Cannot modify header information - headers already sent by (output started at D:\HostingSpaces\spindev\spindev.spinweb.ph\wwwroot\YPS\login\login.php:9) in D:\HostingSpaces\spindev\spindev.spinweb.ph\wwwroot\YPS\login\login.php on line 71 PHP Warning: Cannot modify header information … |
 | Hi Everyone, I have been asked to write some ASP that will interface with an MS SQL 2008 R2 database; with the intention of simply reading data from several tables (using SELECT). This is meant to be an easy task, however after delving into ASP .NET today I have quickly … |
| | I need to make echo for each next situation if points typed is <0 echo can't be negative number if points typed is 0 echo clean 0 if points typed is > 50 echo you passed test if points typed is 100 echo you finished with best result and all … |
| | I have error with this line while($row = mysql_fetch_array($pregled)) in line 42 here is part of code that has problem, can anyone check this out? I need to fix this as soon as possible thanks in advance <p align="center"><font color="#0000FF">Pregled grupa</font></p> <p align="center">Grupa kojoj koncert pripada: <select name="grupa_select2" id="grupa_select2"> <?php … |
| | Hey guys, i'm a bit of a new programmer taking a class.So in my code what im trying to do is to select three random numbers, and see if it matches with the numbers that the lottery throws out. The problem is where the 1st number and 3rd number selected … |
| | Salam all :) anyone can help me to understand this query in venn diagram SELECT e.id, e.name FROM emp e INNER JOIN deptid D_X ON e.empid = d_x.empid AND deptid = 'X' LEFT JOIN deptid D_Y ON e.empid = d_Y.empid AND deptid = 'Y' WHERE d_Y.empid IS NULL |
The End.