futhonguy

Hi i have created a website for my client using PHP and mysql . The client need to backup a table in database as excel file every day. Well he had no idea about coding and all ... He need to backup using a simple way. Please anyone let me …

Hello All, I want to make a CD/DVD Library where by an admin can do all the operations while any other norma user can do limited operations (simply browsing and searching). I'm still organizing and doing simple design and I need your opinions on this: 1. What is the best …

Hi i am trying to display on the web browser to allow user to see information before the latest data is been updated. Hence, it will show: [B](1)previous existing data, (2)latest data and (3)data which is not found on the latest data list[/B]. To make things clear to solve the …

Hi I am trying to join 2 sentences together using php and mysql. How can i do so? I am doing this as i need to add an update of a new remarks to the existing remarks. For example, $first = '[B]Hello[/B]'; $second = '[B]world[/B]'; To get the string '[B]Hello …

Hi, i am trying to extract number out from a text which i grab from the database. [B]EG: ACK9734N[/B], I would like to extract just the number [B]9724[/B] from the text, how can i do so? i understand about using preg_match() but when i tried to do that, the number …

Hi, I am wondering if i am able to insert 2 entries from a form to mysql. for example: [CODE]</tr> <tr> <td bgcolor="#eeeeff"> Is it a shared devices?<br> <font color='#F62817'>** If yes, please indicate the shared device num. </font> </td> <td bgcolor="#eeeeff"> <SELECT name="shared"> <option value="No"SELECTED>No</option> <option value="Yes">Yes</option> <INPUT type …

Hi I am trying to write/modify a script to read from a spreadsheet into mysql database using php. I did a search on google and found phpExcelReader. However i wasnt able to use that to do so. ALso managed to find an open script to read from excel spreadsheet onto …

Hi people, I have a huge data stored in my database server and am currently trying to work out a script in order to update my data in the server. This update comes from an Excel spreadsheet. I did search on Google/Yahoo and found websites like PHPExcelReader or PHPExcel. My …

Hi, I am trying to save my query results into MS Excel format by using the following code. It works on the 1st attempt, but however when i tried to save it again by making another query, i received this warning message: [B]Cannot modify header information - headers already sent …

Hi, I tried to work this query out for a while but till now i still couldn't find what actually went wrong. This search query has 2 search query option. 1) wildcard text search box 2) drop down list option A user can either choose to search by (1) or …

Hi, I stuck on this query for quite a while. will appreciate if someone can help me to look at this query and correct me where i had done wrongly. [CODE]$val_d = $_GET['val_d']; $sql = "SELECT * FROM device"; $sql .="WHERE device_num LIKE '%$val_d%' ";[/CODE] the error message prompted was: …

Hi, I am tryin to store the time a user logged in into a session. However everytime the user logged out, the time stored is the logged out time. Can someone advise me how i should done it in order to store the time the user logged in? Thanks [CODE] …

Hi, I am currently trying to work on a multi search post method on my php script and incorporate with the pagination script too. At the moment, my single post method works well with the pagination script. However when i tried to add another search query where user is able …

Hi i found this script from google search (PHPSense) on pagination. It's a wonderful script. However i wasnt able to do search query on this script. Can anyone help me to figure out how i should go about to modify this script if my search query contains WHEREBY field LIKES …

Hi, I had developed a viewing table from mysql database using php and it is showing me the whole list of contents in a single webpage. I would like to know if there anyway i can actually split the contents into multiple pages for easy viewing?? Your help is greatly …

pagination works well, it even displays the rows i wanted, however, my problem now is that i cannot access or it does not display the next rows from my database, i think there is some problem with regards to my next/previous/last/first links,, please help me asap, tnx! [code=php] $result = …

Hi I am wondering if i can move a field (with contents) from Table B to Table A. If so how can i do it? Any advise ?? Thank you very much..

I would like to make some query using the SELECT function. However i wasnt able to get the results i want. My code is as follow: [CODE] $sql = "SELECT * FROM device WHERE ((device_num like '%$val_d%') OR (dib like '%$val_dp%')) ";[/CODE] can i write it in this way? pls …

Hi, Currently i have 3 Tables - A, B and C. All 3 tables have their unique IDs (which are auto increment) and Table B and C are a foreign keys to Table A. says: Table A = A_id, A_fname, B_id, C_id Table B = B_id, B_add, B_pcode Table C …

Hi, I am trying to get the primary key (which is number) from a field of the same table. however i encountered "Undefined index" shown on my screen. [CODE] $orange_insert = "INSERT INTO orange (orange_id, orange_name, orange_add) VALUES (NULL, '$val_name', '$val_add')"; $result = mysql_query($orange_insert) or die (mysql_error()); $orange_sel = "SELECT …

Hi What i want to do is using php code to write to delete the entire row in the db. each row has its own id, field and content. instead of deleting the row with the id, can i do by the field name? how would i do this?

Hi What i want to do is using php code to write to delete the entire row in the db. each row has its own id, field and content. instead of deleting the row with the id, can i do by the field name? how would i do this?

Dear all, I am trying to submit my data on a php created form to mysql database where it is separate by 2 tables (device) and (location). As some of the devices shared the same location, 2 tables are created as below. For location table, i had created 2 fields: …