- Upvotes Received
- 1
- Posts with Upvotes
- 1
- Upvoting Members
- 1
- Downvotes Received
- 0
- Posts with Downvotes
- 0
- Downvoting Members
- 0
16 Posted Topics
 | [QUOTE=almostbob;1153911]put the files in a folder put the uri of the files in the database smaller faster[/QUOTE] hi, may i know the step u do it. My problem is how to save url on database... thanks in advance.  |
| | Hi, I'm sorry if I had post duplicate post. I had join this 2 table (dt_dict_tbl - store dictionary, sdn5_5 - store accumulate value for reporting). Here the table structure **dt_dict_tbl** CREATE TABLE `dt_dict_tbl` ( `dtDictCode` VARCHAR (30), `dtDictDesc` VARCHAR (600), `rptCode` VARCHAR (30), `rptSubCode` VARCHAR (30), `dtCreatedDate` TIMESTAMP , … |
| | Hi all,thanks for example.It help me. I need a little help here. I'm stuck on how to SELECT rows In a Month Range. The month is take from date yyyy-mm-dd stored on database. I manage to select record on particular month and year using this below example. [CODE] Select * … |
| | [QUOTE=jcarbillon;1692081]you need to consider not just months but year as well, you can get month and year from a date column using month(datecolumn) year(datecolumn) by using "between" and these 2 code above you can get your problem solved, we may not know what exactly your problem is but we hope … |
| | Hi all, Sorry if I post duplicate thread. I'm using windows batch program and still very beginner. I'm having a problem to read record from database. I'm planning to automated read folder name(folder name as reference number of project) from specific root folder and compare the folder name whether exist … |
| | Hi all, First, apology if we created duplicate thread. we try to find relevant topic but no luck to find match and sorry we newbie with ireport but have basic with java. Here is my case. We manage to read ireport generated from jsp file with below code. The report … |
| | Hi, I try to search related title but can't find any match. Here my case. I'm planning to allow user to insert record. If user put 3, mean 3 row of table will expand. Each row have textfield, select menu. Can refer to attachment. I'm using javascript to do that. … |
| | Hi all, Sorry if I post same thread. I cannot find any similar post to handle my problem. I manage to show/hide tables(which I put on DIV tag) by using 2 radio button which is Kes and Lot. But I'm having problem by starting click on either Kes and Lot.The … |
| | Hi, Sorry if i create thread on wrong topic. I don't know where to put this question. Anyway here is my problem. I had accidently hit button on keyboard while doing development(but I forgot which button) and later on my Find and Replace function on Macromedia Dreamweaver 8 not working. … |
| | Hi @cwarn23 , i want ask something if you dont mind. I had look to your example code. It simple and nice ;) but it is useful for resizing image that will store to db as blob? I try to apply it, but not working :'(. Hope you can give … |
| | Re: php upload mysql hi, it might be late, but i already manage to store 5 image at one time in blob. Can refer to below code..Can refer to attachment for full code.hopefully might help you. [CODE] if ($submit == "Simpan Aktiviti") { //insert into event table $sqlm = "INSERT INTO event (bilangan_e,tarikh,keterangan_e,turutan) VALUES … |
| | mmm...i also try same thing.i had successful store it in db as blob type,but having problem to view it... here my code [CODE] global $strDesc; $max_size = 1000000000; $fileUpload1 = $HTTP_POST_FILES['fileUpload1']['tmp_name'] ; if($fileUpload1 != NULL) { $fileUpload_name=$HTTP_POST_FILES['fileUpload1']['name']; $fileUpload_size=$HTTP_POST_FILES['fileUpload1']['size']; $fileUpload_type=$HTTP_POST_FILES['fileUpload1']['type']; $fileHandle=fopen($fileUpload1, "rb"); $fileContent=fread($fileHandle,filesize($fileUpload1)); $fileContent=addslashes($fileContent); fclose($fileHandle); $sqls = "INSERT INTO table(file_content,file_type) VALUES … |
 | Re: PHP and PDF [QUOTE=leopardsag;390856]Ok dear. I have some examples but did not try yet. I intend to tonight and then i will post these in this thread for you. Lets help ourselves then. See you with couple of scripts soon. Regards[/QUOTE] hi, may i know ur example.i'm having same problem. thanks in advance |
| | Hi all, I try to view latest date and amount from history table for each branch (branch table :viscawangan). But accouter problem to view [B]amount [/B]value. [CODE] SELECT b.kod_cawangan,b.nama_cawangan, MAX( a.tkh_data ) AS tarikh_data,[B]a.amount[/B] FROM history a, viscawangan b WHERE a.kod_caw = b.kod_cawangan GROUP BY kod_caw [/CODE] Here i give … |
| | Hi guys, Need your help/advice/opinion for below sql. I try to select all count record that exist in tables between to date insert by user.Currently, just put dummy date to test. The result is ok, but it only view for match data. How to include the record that not match … |
| | Hi, I having problem to fix this problem. Already search for related thread, but cannot find a solution. The case is like this. I have 2 system that intergrate each other. Let assume as system A and B. User need to login from system A and can use system B … |
The End.