7,368 Topics
 | |
| | Hi,i have this tblProductAttribute with ProductAttributeID|ProductID|AttributeID|AttributeValue| 1|1|Blue 2|2|medium (AttributeID 1 = Color,2= size) i want to get result from select query like this ProductName|Color|Size sampleproduct|Blue|Medium inshort i need to get row data to be the column name please help me.thanks :-) |
| | Example 1 below works: echo "<p><h2>".$results['title']."</h2>".$results['shortdesc']."</p>"; I need to make the title linkable to the page url. I'm probably putting the ' and " in the wrong places for the link part. Example 2 - I've added the url code but does not work: echo "<p><h2><a href=http://www.example.com/".$results['url'].".$results['title']."</a>"</h2>".$results['shortdesc']."</p>"; Any help would … |
| | Is it possible to populate my Jcombobox with my database column names? the name of my jcombobox is 'jComboBox_AReport' and the db_Table is 'asset_report'. please am still learning so i will appeciate the help THANK YOU! |
| | please do help me to use prepared statement to load the result in datagridview. Please give me some examples.thanks in dvance :D  |
 | Hey everyone, So I am having trouble getting my head wrapped around a php script I need to build. What I am trying to do is pull data from a MySQL database table (dynamic content) and match it to an html table with static content. I guess an example of … |
| | Attach above is my question & answer(not correct) can someone edit it for me :) MY QUESTION : develop an online application called ‘mylibrary’. The purpose my ‘my library’ application is to record all the books that you have purchased. Information that you have to record are International Serial Book … |
| | Hello , I am a new user of this site and also new to web development.Recently while developing my site on tourism by php/mysql i thought of placing a search bar at the top of my website where users can search topics and results would be provided according to the … |
| | Hi I was taught not to use global variables and one of my friend is using global variable for database handle for his website... could you please explain if there is an issue if he uses global variable for database handle? he is using it to access database from anywhere …  |
 | in my db have 20+ columns. i added 19 columns throught input form and stored in db succesfully. i fetch few details from db in my main page. in my main page 1 more column is there. that is status column, it is a combo box. if i click status … |
| | Hi All, Firstly I will say that this exercise is for my learning experiences through an online course. However I have spent a combined total of about 6 hours working on this question and I am completely stumped on how to get the correct answers. The question: > List the … |
| | Hi, I want to know that how can I get the timestampdiff return as zero instead of null. For example I have a query in which both dates are exactly same but the query returns me null instead of 0. My query is SELECT (TIMESTAMPDIFF(HOUR,'2012-12-01 11:15:00','2012-12-01 11:15:00')) And this code …  |
| | i stored few values through input form. (for example tax and rate field) if i entered tax = 777.77 and rate = 10000 it stored the details to db successfully. retrieve function also done successfully. but i want to show add these two values(tax+rate = total) from db when i … |
| | i have the db with serial no and reference no. serial no is auto_increment value. it is worked perfectly. but i want ref no column also as auto_increment value start with 0000001,0000002,0000003...., how to do that? i cannot able to add two auto_increment values in mysql.  |
| | OKay so this my have been asked before but I have more of a general question than an issue. I don't understand Mysql_num_rows() becuase I don't have any information within my database table so the number or rows should be 0 but what happens is I get an error and … |
| | i created main.php page. this page includes these following php codes, <?php $user = ""; $pass = ""; $db = ""; $connect = mysql_connect("", $user, $pass); if(!$connect) { die ("Could not connect to MySQL"); } mysql_select_db($db, $connect) or die ("Could not open $db: " .mysql_error()); $sql = mysql_query ( "SELECT … |
 | Hello, I am trying to update 3 tables that i have in my db. the second and third INSERT commands there is a specific field that needs to have the ID of the first table last row inserted. first table, admin: +--------------------+ |id username passcode| |1 admin test | +--------------------+ … |
| | i am making a reservation system and i am having a a problem with time conflicts(the system must not accept a reservation where in there is already an event reserved art that time. . my table looks like this   |
 | **Can anybody help me??? I'm newbie in php, I'm trying to make this code as one below.But it always gives me an error. Any help would greatly appreciated ** my table name is trans ![Fields[1] * *$id = $_POST['id']; if(isset($_REQUEST['command']) && $_REQUEST['command'] == 'update'){ $name = $_POST['name']; $email = $_POST['email']; … |
| | Hi **I have doing the project for my purpose. it is working properly on localhost engine. after i have uploaded to server(cpanel) it is not working. i have posted my code here for reference: Please help me anyone!!!** ** Login.php** `Inline Code Example Here` <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 …  |
| | Hi, I am creating a function in mysql and I want to make the order by and limit section dynamic. What I want to do is to call the function and enter the limit and order by condition dynamic. How can I achieve this. Thanks in advance |
| | Hi, I have a table named as appointment. In appointment there are two fields appointment_date and person_id. There can be multiple appointment for same person. What I want to achieve here is that the date difference of both appointments for the same person should be greater or equal to 90 … |
| | hello i just want to ask if how to echo value/details using this API link that have given - http://themesnmotifs.com/api/wp/f6f60a0e7091a627641f01b9d1dd7536ea4b8496/list_wp - for example i want to echo all the companyand wp_cellphone -- . thank you  |
| | Here i am uploading data through a form which contains some input fields and one image. But i want to upload multiple images here instead of one image. I am attaching my php code here to upload the data and single image. Can anyone edit this code to add mutliple … |
 | Hi, i have successfully stored a link to docx and pdf files into mysql db. I'm trying to retrieve it from db and display it similar to pictures. Now when the user click on it, it should open the file and display it. If any one have a code sinppet … |
| | i want to calculate the depreciation of an asset and i want my accumulated value to automatically add the previous monthly depreciation value with the current one any time the user calculates for the monthly depreciation, the accumulated value should pick the results from monthly depreciation and add it to …  |
 | Hello, Recently I am trying to make a php file than when it is opened it should backup a database and promt the user to save the .sql file... This is a feaure that has phpmyadmin but I want something very simple, just clicking http://mywebsite.com/backup.php and the file should be …  |
| | I want to populate my jtable with columns from different table in mysql database but it only displays the column names and not the data or information under those columns. i hope this code helps u undertand what i mean. thanks private void Update_table(){ try{ String sql = "select Date_Acquired …  |
 | Hi. I'm confuse on how I will create my temporary table. Need some clarification here. I want to create a temporary table that will hold some column and values. And later on I would alter/update the table to add another column and data with respect to the existing columns. ammm... … |
| | Hi all, i have a table in db which contain some pdf and docx files. Am trying to display it in a way, so that when the user click on it, it will load the pdf and/or docx file from db in another/same window. this is what i have done …  |
| | Please how can i insert into two different tables in mysql using java. i tried this and its only for one table. so how can i insert into branches and items table simultaneously in the same code? try{ String sql = "Insert into asset_update (Date_Acquired,Item_Code,Serial_Number,Cost_Of_Acquisition,Estimated_Useful_Life,Depreciation_Start_Date,User,Status,Disposal_Date)values (?,?,?,?,?,?,?,?,?)"; pst=conn.prepareStatement(sql); pst.setString(1, ((JTextField)date_aquired.getDateEditor().getUiComponent()).getText()); String … |
The End.