Network_ninja

is your server a windows? I also encounter that kind of problem but we are running in linux environment and sendmail is built in to it, we just need to configure it a bit.

is there a mail server in your machine? eg. sendmail

hi... forgive my elementary question. but how should I do that? Can u give some example code? tnx

I did not test out the code. but that's the only problem I can find... Hav a nyc day!

In your external stylesheet remove the open and style tag: <style type="text/css"> ...................... </style> your external stylesheet should looks like this: form.style1 fieldset { padding: 1em; font:80%/1 sans-serif; background-color: #f0f0f0; } form.style1 label { float:left; width:25%; margin-right:0.5em; padding-top:0.2em; text-align:right; font-weight:bold; } body { margin: 2em } h4 { margin-top:2em } input { font-size:100%; vertical-align:middle }

If anyone is interested you can visit this site: http://www.apachefriends.org/en/xampp-linux.html Pretty much easy package installation.

Sorry if I maybe in the wrong post but I cannot post Under Linux board.... Have anyone tried HTA + PHP? Does HTA run only on windows? How can I run HTA in linux flatform? (ubuntu 11.10)

tnx to everyone, i already found and answer at www.fdpf.org. A script submitted by a helpful developers. tnx

Tnx for the quick reply. but I am already using MultiCell in my code...

I would like to create a page in pdf format and I found it possible by using fpdf, but how would I create a page that looks something like this: 1 Flathead nails 3/4" 1,170.00KG @ 60.00 70,200.00 2 Drip edge using plain G.I sheet 3,304.00PCS @ 80.00 264,320.00 4" x 8" x Ga. #24 including cutting and bending (as per drawing). requirements : 472 sheets 1 sheet = 7 pieces 3 Wall flashing using plain G.I sheet 712.00PCS @ 70.00 49,840.00 4" x 8" x Ga. #24 including cutting and bending (as per drawing) requirements : 89 sheets 1 sheet = 8 pieces ********************* NOTHING FOLLOWS ********************* I really need something like this that shows no border because borders are already pre printed. Before posting here I googled it first And found a code that would possibly create my concern but I found some problem of the code and I need some help to make this working. Existing code: <?php require('fpdf/fpdf.php'); $pdf = new FPDF(); $pdf->AddFont('Bookman','','Bookos.php'); $pdf->AddPage(); $pdf->SetFont('Bookman','',14); $x=16; $y=26; $width=30; $height=35; $leftmargin=16; $content = "content"; //$content = "This is a very long content, this must goes to the next line. "; for ($r=0;$r<5;$r++){ for ($c=0;$c<6;$c++){ $pdf->SetY($y); //set pointer back to previous values $pdf->SetX($x); $x=$pdf->GetX()+$width; $y=$pdf->GetY(); $pdf->MultiCell($width,$height,$content,1,'L'); } $y+=$height; $x=$leftmargin; $pdf->SetY($y); } $pdf->Output(); ?> There are two problems with this code: 1.) Only the first page is working well. 2.) It will not create a newline in each cell if the content is long.... Tnx in advance to everyone..... pls.....

tnx.

tnx for the reply. its just that we have a database of our clients nd sometimes the encoder mistype the names. so if your going to search for the names it won`t come. So im thinking if its posibble to display the related words. tnx for all ur help guys.

Yes i did try that query... If there are also records that is somewhat similar to the word will be outputed: e.g Smiht Smiith Is my concern impossible to achieved?

tnx for that info... But thats not what I'm looking for: Say I have this value on my table firstname Smithe Smith Smoothe Smooth Smithe if i am going to use this query SELECT * FROM tablename WHERE MATCH (firstname) AGAINST ('Smith') It would only output : Smith The desirable output would be Smithe Smithe Smith I am looking for the MYSQL REGULAR EXPRESSION to do the thing but don't have yet come up with a correct one....

Hi everyone.. pls. help. I don't have yet a working code since i don't have an idea on how to do it. I just want to have a simple search query. Lets say that if I am going to search for the word 'smith' all firstname that is similar to that will be displayed: eg. Smithe Smit Smiht This is not possible using LIKE since the output would only be Smithe. Tnx in advance.

Ok... Lets make the numbers small... Lets assume that this would be my query SELECT fld1,fld2,fld3,fld4,fld5 FROM tablename WHERE datein < CURDATE() And will also assume that the query will return 30,000 rows... This will surely take a while rigth? I am looking if it will be possible in your code or mysql query that will pause a query and continue after 2 seconds....

hi everyone... What would I do or what will be the best approach if I have to extract a large data in a table.... Let's say that the query will extract 1 million records.. What will be the best way to extract it without affecting the performance of other systems... Let's just say that my table has a proper index... Tnx in advance....

Hi everyone I have a question on my query.... This is my current records of my table fld1 fld2 fld3 fld4 fld5 fld6 1 lastname1a firstname1a mi1a Address1a 2011-08-26 09:26:44 1 lastname1b firstname1b mi1b Address1b 2011-08-26 09:28:12 1 lastname1c firstname1c mi1c Address1c 2011-08-26 09:28:27 1 lastname1d firstname1d mi1d Address1d 2011-08-26 09:29:18 1 lastname1e firstname1e mi1e Address1e 2011-08-26 09:29:28 2 lastname2a firstname2a mi2a Address2a 2011-08-26 09:31:15 2 lastname2b firstname2b mi2a Address2b 2011-08-26 09:31:16 2 lastname2c firstname2c mi2a Address2c 2011-08-26 09:31:17 2 lastname2d firstname2d mi2a Address2d 2011-08-26 09:31:18 2 lastname2e firstname2e mi2a Address2e 2011-08-26 09:31:19 3 lastname3a firstname3a mi3a Address3a 2011-08-26 09:34:53 3 lastname3b firstname3b mi3a Address3b 2011-08-26 09:34:54 3 lastname3c firstname3c mi3a Address3c 2011-08-26 09:34:55 3 lastname3d firstname3d mi3a Address3d 2011-08-26 09:34:56 3 lastname3e firstname3e mi3a Address3e 2011-08-26 09:34:57 4 lastname4a firstname4a mi4a Address4a 2011-08-26 09:34:53 4 lastname4b firstname4b mi4a Address4b 2011-08-26 09:34:54 4 lastname4c firstname4c mi4a Address4c 2011-08-26 09:34:55 4 lastname4d firstname4d mi4a Address4d 2011-08-26 09:34:56 4 lastname4e firstname4e mi4a Address4e 2011-08-26 09:34:57 5 lastname5a firstname5a mi5a Address5a 2011-08-26 09:34:53 5 lastname5b firstname5b mi5a Address5b 2011-08-26 09:34:54 5 lastname5c firstname5c mi5a Address5c 2011-08-26 09:34:55 5 lastname5d firstname5d mi5a Address5d 2011-08-26 09:34:56 5 lastname5e firstname5e mi5a Address5e 2011-08-26 09:34:57 I want to extract 1 record per group(fld1) based on the latest date(fld6) The desired output would be: 1 lastname1e firstname1e mi1e Address1e 2011-08-26 09:29:28 2 lastname2e firstname2e mi2a Address2e 2011-08-26 09:31:19 3 lastname3e firstname3e mi3a Address3e 2011-08-26 09:34:57 4 lastname4e firstname4e mi4a Address4e 2011-08-26 09:34:57 5 lastname5e firstname5e mi5a Address5e 2011-08-26 09:34:57 I thought that this simple query would work: SELECT * FROM tablename GROUP BY fld1 ORDER BY fld6 DESC but this query is not giving me the desired output... tnx in advance

Yes.... I mean I will optimize the heavy queries... tnx for your help.....

by the way guys... there are a lots of error_reporting.. what do you usually use?

tnx for all your help guys...

Anyway, you have a good point there...... And I just realize that you can always add alias to your queries to make it short, like this: SELECT * FROM database_name.table_name AS a what do you mean calling the mysql_select_db() multiple times? Do you mean this? $hostname = "localhost"; $username = "root"; $pword = ""; $conn = @mysql_connect($hostname,$username,$pword,true); @mysql_selectdb("databasename1",$conn); $query = @mysql_query("SELECT * FROM tablename ",$conn); @mysql_selectdb("databasename2",$conn); $query = @mysql_query("SELECT * FROM tablename ",$conn);

tnx for the reply bro... the difference is very noticeable when i add index to that fields... but it's quite a big system so I will try to optimize them all... tnx a lot...

tnx a lot bro....

So in your example say that I will be needing to connect to 3 database in a script i will have to write something like this? $conn = conn('databasename1'); $conn2 = conn('databasename2'); $conn3 = conn('databasename3'); @mysql_close($conn); @mysql_close($conn2); @mysql_close($conn3);