Posts
 
Reputation
Joined
Last Seen
Ranked #168
Strength to Increase Rep
+11
Strength to Decrease Rep
-2
100% Quality Score
Upvotes Received
44
Posts with Upvotes
42
Upvoting Members
30
Downvotes Received
0
Posts with Downvotes
0
Downvoting Members
0
38 Commented Posts
4 Endorsements
Ranked #402
Ranked #157
~146.92K People Reached
About Me

Database Administrator. Web and database development professional. MCP: Microsoft Certified IT Professional: Database Administrator. Microsoft Certified Technology Specialist: SQL Server 2005.

Interests
rock music, web development, and databases
Favorite Tags
Member Avatar for keanan

Hello, I have been searching far and wide but am yet to find a solution, my php mail sends email to all addresses except hotmail (not weven junk). Code: $message = "Welcome to Sky Crew, Your personal account for the Skye Crew has been created! Your personal login ID and …

Member Avatar for swati_7
0
3K
Member Avatar for nikesh.yadav

hi all, i m working on the email validation i ve to check email id either it is correct or not but i cannt send mail on them. ie when i validate all email id client send newsletter and they should not bounce. thanx in advance

Member Avatar for pritaeas
0
6K
Member Avatar for Ravenous Wolf

i would like to know if php can replace javascript as a client side script. one can use javascript to do all kinds of things like computing values in textboxes and check them for errors and so on. is it possible to use php in its stead? lets say i …

Member Avatar for abexer
0
418
Member Avatar for ramseswar

i trying to write a script so that it does,nt allow the user to login again if already logged in...whether he tries from other browser.................. wat i m doing is setting a value in database to 1 if he logs in and 0 if he logs out .......den i check …

Member Avatar for cecece
0
1K
Member Avatar for cmgdev

Please help. I can not figure out how to add a simple link to an image when the image is called through PHP. I have tried making it work a number of ways but I am only intermediate in HTML and still trying to learn PHP basics. The code is: …

Member Avatar for JorgeM
0
827
Member Avatar for lydia21

i have a form which will display the details in a table,when edit button is clicked all the content in the table should come in a form(ie inside the textboxes)..so that the user can edit and save the content again in the database. [B][U]1st page[/U][/B] $link=mysql_connect($hostname, $username, $password); mysql_select_db($dbid) or …

Member Avatar for piyush16791
0
143
Member Avatar for agr8lemon

I'm a bit of a SQL newbie so I'm wondering if you can help me. I've looked on Google it for some time, but maybe I'm not using the proper terms. Here is my question: I have TableA that has the following columns: ID(PK), location, departA, departB. I would like …

Member Avatar for adam_k
0
1K
Member Avatar for solomon_13000

There are 5 columns in my table structure and they are: 1) Id - PK 2) Name 3) IdentityNo1 4) IdentityNo2 5) PassportNo Since duplicate records are inserted into the table I am attempting to remove the duplicate records. What makes the records unique is the IdentityNo1, IdentityNo2 and Passport …

Member Avatar for buddylee17
0
152
Member Avatar for Fost

Hi All, I'm having a bit of an issue with a stored procedure I have written which encrypts a value using ENCRYPTBYPASSPHRASE and DECRYPTBYPASSPHRASE. The problem is these functions return Varbinary data types which I need to append to a Varchar data type. Can anyone help with being able to …

Member Avatar for buddylee17
0
137
Member Avatar for MidiMagic

How do you make a style that affects the font attributes of [B]only[/B] the numbers in ordered lists (ol) without affecting the contents of the list items? No kludges please, and the solution must validate as XHTML 1.0 strict.

Member Avatar for JesusFreak83
0
2K
Member Avatar for pete harby

Hi I am really struggling here and cant see the syntax error. It is probably a " but could really do with a hand as to why I get the error: unsxpected T_STRING on line 14 My php code is as follows: [php]<?php include_once("php/library/lib.php"); include_once("php/library/template.php"); include_once("php/library/database.php"); // //$database = new …

Member Avatar for hoffmen99
0
4K
Member Avatar for wandie

Can someone please help me I have made an example, of an cookies I have added a value 45 but i have created another page that displays. This prob is when i run the code that has the value 45 its suppose to give me a blank page byut i …

Member Avatar for Ami_Bogus
0
167
Member Avatar for kimmi_baby

Hi, I'm having issues with the current page I'm working on. It works fine in IE, Chrome and Safari but not so much in Firefox. The problem I'm having is that the slideshow is positioned all the way off the screen (towards the right). It's supposed to be straight below …

Member Avatar for buddylee17
0
228
Member Avatar for aodpreacher

Hi i am currently a Computer Science undergrad and i was just doing some thinking for a Master degree. I like software and web development and i am leaning towards more of a web development specific for my masters but what are the options i have for trying to get …

Member Avatar for bjelline
0
292
Member Avatar for allena
Member Avatar for ibpet11

Code Warriors, I need to set a value in my SQL database as (1 or 0 ) (true or false) so that when i click a button to insert into the database the column register 1 and when i click the button delete the column register 0. do any warrior …

Member Avatar for buddylee17
0
87
Member Avatar for Srcee

I want to create menu structure from a database. For example, the database is the following: id name parent 1 x null 2 y 1 3 z null 4 a 3 5 b 2 The result should be: -x --y ---b -z --a Now, the algorithm I have on mind …

Member Avatar for buddylee17
0
226
Member Avatar for jacksantho

I have a stored procedure. This proc returns some data that needs to be put in an excel format. Is it possible to create a excel file to have the result of a select statement from the database? please help me out. Thanks

Member Avatar for buddylee17
0
317
Member Avatar for webguru07

is there a way that i can check to see if a mysql table exists and if not add the table to the database with a session_id as a table name

Member Avatar for Vonzarovitzch
0
2K
Member Avatar for dominic23jones

Just a quick question, I already have a basic understanding of Web Programming but I am yet to get to grips with Web Design. I am planning on doing some tutorials on either GIMP which is free image editing software or Photoshop which will cost me, is it worth paying …

Member Avatar for IkramMirza
0
322
Member Avatar for enzogoy

Hi all I'm a newie to PHP. I have a html form which will passed 6 value to a php file and from a php file, I would like to write these value on to 2 rows in the excel. Therefore each person submit the form, it will write 6 …

Member Avatar for mafhh14
0
5K
Member Avatar for Silent-Regret

Okay, I have a table called InGameTime with the following columns: CharName varchar(30) InTime datetime OutTime datetime HH int MM int SS int I am trying to make a trigger, that will once data is updated, it will update the HH,MM,SS to add the total hours, minutes, seconds spent in …

Member Avatar for Silent-Regret
0
233
Member Avatar for waqar100

in a table having the fields of starttime & endtime ,I want to fetch only the records having starttime & endtime of same days.

Member Avatar for buddylee17
0
104
Member Avatar for moone009

create table #TempRouting( id int, routetype char(4), routesequence int) insert into #TempRouting (id,routetype) values (1,'MON') insert into #TempRouting (id,routetype) values (1,'MON') insert into #TempRouting (id,routetype) values (2,'MON') insert into #TempRouting (id,routetype) values (3,'MON') insert into #TempRouting (id,routetype) values (4,'MON') insert into #TempRouting (id,routetype) values (5,'MON') insert into #TempRouting (id,routetype) values …

Member Avatar for moone009
0
182
Member Avatar for hhaannyy

I have a program that works access 2003 and i convert tables to sql Server 2005, but the problem is that program works only on the server but does not work on client .the internal network is workgroup and system is Windows XP . what can i do to get …

Member Avatar for hhaannyy
0
198
Member Avatar for AngelicOne

I'm having a hard time to return a string value. I usually do this by passing an int, which works just fine. Now, I need to pass a string but couldn't. Is this possible? Or int is only type that SQL can return?

Member Avatar for buddylee17
0
131
Member Avatar for axman1000

I would like to retrieve the previous date (i.e., current date minus 1) and use it in a query through an = operator. I got the following query to retrieve the previous date: [icode]select DATEADD(DD, DATEDIFF(DY, 0, GETDATE()), -1)[/icode] It gives: 2011-03-14 00:00:00.000 I would like to get only: 2011-03-14, …

Member Avatar for axman1000
0
225
Member Avatar for f_atencia

Hi all, I'm a newbie when it comes to SQL and I have 2 tables that I need to update. Let's say, for argument's sake that the first table (Products) has an identity column (automatically incremented) with the name of ApplicationValueID. It stores a bunch of data about a product …

Member Avatar for buddylee17
0
103
Member Avatar for aplee

Hi everyone, I am getting this error: [CODE]Msg 512, Level 16, State 1, Line 1 Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. The statement has been terminated.[/CODE]please …

Member Avatar for buddylee17
0
169
Member Avatar for judithSampathwa

hi i have a question in getting values from two table i ave two tables Table1 and Table2. table 1 have data and table 2 may have the same data as table 1 and more. and also table 1 may have the same data and some which is not in …

Member Avatar for buddylee17
0
120