nav33n

What's the error that you are getting ?

select idtransaction, customerID,debit, credit, (debit - credit) as balance, transDate from transaction where customerID='Cust001' ? Is that what you are talking about ?

I wish all these people(new programmers and sick people who aren't sick anymore) suffer from amnesia!

All you need is [url=http://www.wampserver.com/en/download.php]Wamp.[/url] Just install wamp and it will configure apache, mysql and php for you :)

24% :icon_rolleyes: I thought i was evil !

[QUOTE=jasimp;493747]Welcome! Only 50 with 500 mb. I find that hard to believe seeing as I can fit about 200 on 500 mb.[/QUOTE] It all depends on the bitrate of the mp3 file. @cjk93, Welcome to daniweb.

This thread was started more than an year ago and the OP, after starting this thread has never come back ! :-/

DML or Data manipulation language is nothing but "How do you manipulate the data in a table". You can manipulate the data in these ways. 1. Selecting the data from the table (Select) 2. Inserting the data to the table (Insert) 3. Updating the data in the table (Update) 4. …

How will it make any difference ? If someone hacks into your database, how will changing its name makes it 'unhackable' ? The hacker will access/delete the tables with the loopholes in your script. :)

:D Welcome to Daniweb ! I am sure you will learn a lot from this place !

[quote]Do need any software on my computer ?[/quote] Yes. You need a webserver (IIS or apache) , Php and mysql. To learn the basics, you can start [url=http://www.w3schools.com/php/php_intro.asp]Here[/URL]

If you have a counter or id field in your table which is unique, you can do this easily. [code=php] <?php $connection=mysql_connect($dbhost,$dbuser,$dbpass); mysql_select_db($dbname); $query="select * from tablename"; $result=mysql_query($query); $max=mysql_num_rows($result);//count the total records in the table $random_members=array(); while(count($random_members) <= 5){ // until 5 members are selected $random=rand(1,$max);//generate random number if(! in_array($random,$random_members)){ …

Welcome to Daniweb!

Hey ! System mechanic has this feature (i checked it sometime ago) to remove duplicate files. It checks the file size and also the dates to mark a file as duplicate. Welcome to Daniweb btw.

[QUOTE=briansmall;493000]Anyone care to define sub-human?[/QUOTE] Definitions of subhuman on the Web: * less than human or not worthy of a human being; "treated natives as subhuman"; "a subhuman spectacle"; "the subhuman primates" * unfit for human beings; "subhuman conditions of life". P.S It really doesn't make any difference if you …

Welcome to Daniweb. But i guess its against the community rules to promote your website this way :-/ !

First, you fetch the data from the csv file using [url=http://in.php.net/fgetcsv]fgetcsv[/url]. Its returns the value as an array. Access the array element where the date is stored and do as scru has mentioned.

[quote]Please post your problem in the correct Widows forum.[/quote] :D Bad typo there !

Welcome to Daniweb Bob.

Welcome to Daniweb !

Welcome to Daniweb :)

Umm.. I believe you are 'an instance' of [url=http://www.daniweb.com/forums/member214625.html]this[/url] user ? Why did you unearth a dead thread ? Well, I see a ban coming !

Search google for pagination in php. There is already a code snippet [url=http://www.daniweb.com/code/snippet612.html] here[/url].. I guess you can modify it to suit your needs.

I guess its looking in F:/billadelphia/Admin/images. Change the img src path to ../images/hdr.jpg . (You can right click the image placeholder and click on properties to check whether its path is correct)

Can you be a bit more specific ?

[QUOTE=Jicky;491756]ya the game is intresting[/QUOTE] Dude! What's with you and intresting ?

Shouldn't it be sqrt((x2-x1)^2+(y2-y1)^2)=distance ? You are just taking the sqrt of $H and not $H + $D.

What's wrong ? Are you getting any errors ?

You can use, sum(ifnull(points,0), points_added). If the 1st expression in ifnull ie., points is null, it returns 0 and if its not null, it returns points value. I too dont know much about joins and related problems, but, this link might be useful. [url]http://dev.mysql.com/doc/refman/5.0/en/control-flow-functions.html[/url]

Mr. Peace, can you explain a bit more on jihad ? can you also explain why some terrorists call themselves jihaadis ? [url]http://en.wikipedia.org/wiki/Jihadi[/url] ?

huh! What kinda game is this ? :-/

Send it as a gift to your foe. He will be happy that hes getting "something" from his "enemy". He will then stop hating you :D

No matter who you choose, they all come under the same category of 'politician'. And according to me, a politician is one who cheats people and eat their money !

extract rar files using winrar. Then watch/burn the movie.

Add sessions. If the user enters his username and password in the first page, add his username to the session(if he is a valid user). Then just add a condition,[code=php] if(! isset($_SESSION['username'])){ echo " You have to go back to page 1 and enter your username..."; exit }[/code]

It would be easier for us if you give us the structure of the tables and also the query that you are using.

If you have deleted rundll32.exe by mistake(or by virus attack), you will have problems w.r.t control panel. Try this. Put your windows xp cd in your cd rom, open command prompt and type the following. cd_rom_drive:\i386\rundll32.ex_ %Systemroot%\rundll32.exe (Eg. d:\i386\rundll32.ex_ %Systemroot%\rundll32.exe , if D is your cd rom drive name) It …

database php formatted ? Why not print the values using a table ? :-/

What is the error that you are getting ? I dont think you can use something like [inlinecode]User Name:<input type=text name=form[frstname]> Email:<input type=text name=form[email]>[/inlinecode] Edit: My mistake. you can specify an array as a name.

[URL=http://www.webcheatsheet.com/PHP/send_email_text_html_attachment.php]This[/URL] might help.

[quote]this is your error dude: $sql = "SELECT * FROM products;"; change that one to this one: $sql = "SELECT * FROM products";[/quote] It doesn't matter if you have a ; in your query.

Umm..what's so difficult about it ? I hope you know the query to fetch the records from the table ? [code=php] $subject="Test mail"; $from="From : yourname@domain.com"; $query="select * from tablename"; $result=mysql_query($query); while($row=mysql_fetch_array($result)){ $email=$row['email']; $name = $row['name']; email($email,$subject,$message,$from); } [/code]

I dont see a closing brace of [inlinecode]if (isset($_REQUEST['submit'])) [/inlinecode] . $username and $password is not declared. And, [inlinecode] $from="yourname@domain.com"; [/inlinecode] should be [inlinecode]$from = "From: [email]yourname@domain.com[/email]";[/inlinecode]

And why exactly did you create a duplicate thread ?

[quote]Asumming you have a hidden text area with the id "txarea" [/quote] How can you have a hidden text area ?

[code=php] <?php $date1="2007-11-04"; //date 1 smaller than the 2nd date $date2="2007-12-06"; $difference= (strtotime($date2) - strtotime($date1))/(24*60*60); print $difference; ?> [/code] Hope it helps.

[code=php] <?php $reg = '/(&.*?;)/is'; $data="&reg; This is a registered company. &nbsp; &gt; &lt; is replaced by a whitespace."; $rep=""; echo preg_replace($reg,$rep,$data); ?> [/code] This is an example in php. $reg is the pattern that you want to search for. $data is a string which you want to search for …

[url]http://www.daniweb.com/forums/thread99569.html[/url] Thats a simple example on how to sort records based on a column. And about the password, if you are storing the username/password in the database, ask the user to enter username and password. Check if that username & password are in the table. If true, then redirect the …

[quote]...for future reference, never declare a prefix, always leave this option blank.[/quote] May be they are talking about the prefix while creating a database. For example, if your host is somehost, it will add prefix somehost_databasename while creating a database. I guess thats what they mean by that.

Again, what is the error you are getting ?