955 Topics
| |
Hi guys having a little problem getting my brain wrapped around this, im new to php and need some help, on my homepage i have a product spotlight container. In this container i would like to pull information from a table in my database and display the relevant content. I … | |
hello. i have a contact page that has a table populated by data from database. when a user clicks on a name a popup appears with that names data so user can edit/update. in that popup there is one drop down named salutations. say that drop down is not edited … | |
| 1. What exactly is a surrogate primary key? 2. Is a surrogate primary key just a made up attribute inserted into a table by the database administrator? All I know is that you use a surrogate key when there is no primary key or the natural key may not be … |
“Magic Video Center” is a video rental company which rent outs Movies and Music videos to its customers. The rental fees for the Videos are calculated as follows. For Movie Video:- Rental fee = (Number of Days * Fee per day) + Extra Charge For Music Video:- Rental … | |
Hello, I need to make a script that will generate a spiral html table.. user should be able to enter number of rows and columns... and a spiral should appear... and I havent a clue... can someone give me some hints? some ideas? PLEASE! thanks | |
so.. Im having trouble wrapping my noodle around this... my initial thought: -- events create table Events ( id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, Title VARCHAR(512) NOT NULL, Description TEXT NULL, StartDate DATETIME NOT NULL, EndDate DATETIME NULL ); create index StartDate_OnEvents On Events (StartDate); create table EventFrequency ( … | |
hey guys, so i'm trying to insert data from one table to another. table 1: |event_id|event_name|start|end|event_venue| table 2: |guest_id|guest_name|event_id|event_name| $event = mysql_query("INSERT INTO event VALUES('','$name','$dstart $tstart','$dend $tend','$venue')"); $insertg = mysql_query("INSERT INTO guest(event_id, event_name) SELECT event_id, event_name, FROM `event` WHERE `event_name` = `$name` "); i get : > Column count doesn't … | |
//exporting to csv file. // this is my code. <?php // Database Connection $host="localhost"; $uname="root"; $pass=""; $database = "db_name"; $connection=mysql_connect($host,$uname,$pass); echo mysql_error(); //or die("Database Connection Failed"); $selectdb=mysql_select_db($database) or die("Database could not be selected"); $result=mysql_select_db($database) or die("database cannot be selected <br>"); // Fetch Record from Database $output = ""; $table = … | |
Hi,im trying to insert into table student_acedamic_history but I get this error.Heres my code. CREATE TABLE Student_Acedamic_History( S_id INT, Degree_Title VARCHAR(30), Institue VARCHAR(30), Year_Of_Comp INT, Total_Marks INT, Obtained_Marks INT, PercentAge FLOAT, CONSTRAINT fk_S_id_students FOREIGN KEY student_acedamic_history(S_id)REFERENCES students (S_id)ON UPDATE CASCADE ON DELETE CASCADE ); And the data: INSERT INTO student_acedamic_history … | |
i had develop a phonegap application with my woocommerce store. now i want to create order manually. So anyone can tell me when new order is created in woocommerce store how many data inserted in which tables in database. i mean data at the time of new order generation in … | |
Hello i have a textarea on a form when i submit it it returns [object HTMLTextAreaElement] so does on the field of the table. WHat can i do to fix it? | |
Hello Am using the window.print function on a page, but it does not print the background color which I've set in my stylesheet for table cells. Any way to fix this issue? | |
I Have one table in sql Date Day Start Time End Time Subject Teacher 2014-06-02 Monday 2:30 PM 04:30 PM Maths Mr.Smith 2014-06-10 Tuesday 2:30 PM 04:30 PM Science Mr.Ayar 2014-06-16 Monday 2:30 PM 04:30 PM Maths Mr.Smith 2014-06-02 Monday 3:30 PM 04:30 PM Maths Mr.Smith I want to make … | |
| I have a table that extracts data from a mysql database, I want the table to be centerd on the screen. I have used text-align: center; but obviously it only centers the text inside the div. here is my css .tableOuter { text-align: center; } .tableInner { text-align: center; margin-left: … |
I have this database and I need to display data from koncerti (koncertnaziv,karte,mesto,datum) based on what grupanaziv is sleceted before, and grupanaziv is in different table called grupe, grupa_id from koncerti has same id as id from grupe, so that is connected in that way, so I need to match … | |
I have a few questions. Server-client code with a (distributed) hash table. Give the peers their own port, own node-ID, predecessor and successor ( node-ID, IP and port of them). That's a snippet of it. port= argv[1]; ownNodeID = atoi(argv[2]); sucNodeID = atoi(argv[3]); sucIP = argv[4]; sucPort = argv[5]; preNodeID … | |
I want to show some mysql results in two different areas... I thought I would do two queries, and show a certain few (1-5) or whatever on one area, and the rest on another, however I need them split even.... how can I do this? I thought about doing something … | |
| I have 3 tables --Ticket_Lines (parent), Labour_Items (child), Part_Items (child). Table Ticket_Lines has 2 primary keys (ticket_number & ticket_line_number) I know that you cant have two seperate primary keys in one table so would this mean that ticket_number and ticket_line_number is a composite primary key? if that is correct, is … |
Hello i cant understand what this variables mean havent seen them before $ser=$_SERVER['HTTP_HOST']; $ref=$_SERVER['HTTP_REFERER']; $url = $_SERVER['SCRIPT_NAME']; $host = $_SERVER['SERVER_NAME']; $url = $_SERVER['SCRIPT_FILENAME']; $ura = $_SERVER['SCRIPT_NAME']; $host = $_SERVER['SERVER_NAME']; this script connects with its own database but i want it to connect to a database that i have already. i … | |
Hi, I have an array as: $data = array ( array ('add1','add2','May 2014','ascascascasc',160), array ('Framework','hii','May 2014','ascascasc',161 ), array ('Framework','test framework 1','May 2014','asdasdasd',159 ) array ('Framework','test framework','May 2014','asdasdasd',149 ) array ('OS','other OS skill','May 2014','ascascASC',162 ), array ('Databases','test db skill 3','May 2014','bnmbnmbnm',158 ), array ('Databases','test db','May 2014','bnmbnmbnm',18 ), ); I want to … | |
hi all; again i have a little bit wired problem here what i'm trying to achive here is that i would like to to a search query to search an employee and after that change the depatment and after that update the data into access database and as you can … | |
| I have a php/mysql project and I am currently trying to display a table into an html table through PHP how ever Only the headers are getting returned not the actual table data, here is my query plus html table <?php $result = mysql_query("SELECT * FROM store"); echo"<table border = … |
i have an array names skills in which there are various skills now i wanna create aquery like select * from tablename where skills regexp ""skill1" and skills regexp "skills2" and skills regexp "skills3"; how could i do this.. upon defining a string for concatenation php shows error....`$s=select * from … | |
I want the field entries to be posted to a new row on the table on the same page [without refreshing] but I have no idea what to do. Please help. <!DOCTYPE HTML> <HEAD> <style type="text/css"> body { background-image:url('http://s3.amazonaws.com/br-cdn/temp_images/2014/03/03/bcada532fad70fea292c3dfacdd14e7b.gif?1393878752'); background-repeat:repeat; width:750pt; margin:0 auto;} p {font-size:12pt; font-family:Trebuchet MS;} form {font-size:12pt; color:blue; … | |
Hi ! I need to have a single mysql query which should get COUNT of two different values in a single field, suppose i have a field in a table 'approved', and there are only two values ie. approved=0 or approved=1, and have suppose 100 rows for them,so how to … | |
I have a small code utilizing a hash table. Now I want to convert it, basically, to a distributed hash table. Hoever, I can not find out how you actually code one or what changes you make to an existing hash table...??? Can anyone please help me, please? I can … | |
Hello thanks in advance i working on project i used query select project_table.project_id as proid,resource_request.*,sum(resource_table.resource_budget)as resourcecost,resource_table.* from project_table left join resource_request on resource_request.project_id = resource_request.project_id left join resource_table on resource_table.resource_id = resource_request.resource_id GROUP BY proid ORDER BY proid DESC its worked but resourcecost is displaying for all project id if … | |
Sir, i have a little problem regarding my queries.. I try to display data from two different table using left outer join. but I found some error.. here's my code please check and tell me what is wrong.. f(isset($_GET['id'])){ $id = preg_replace('#[^0-9]#i','',$_GET['id']); $result = mysql_query("SELECT A.cus_id, A.complaint, A.admin, A.datetime, B.firstname, … | |
Question. Name the law given and verify it using a truth table. X+ X’.Y=X+Y My Answewr give below X | Y | X’ | X’.Y | X+X’.Y | X+Y 0 | 0 | 1 | 0 | 0 | 0 0 | 1 | 1 | 1 | 1 | … |
The End.