10,940 Topics
 | |
| | I just recently found out that I need a secure tunnel client in order to access an API, OK. Then while researching I find way too much conflicting info about what it is exactly. Could someone shed some light? Is it a subscription? Does it live in my PC or …  |
| | hi all! i'm new with php and i have problem. I have a submit form in which every user places code.when they submit it in database its displayed normally there, but when i try to view the data in php there are missing elements , as b<<c or <iostream> etc. … |
| | I would like to understand how to retrieve an Image stored in a mySQL database as a longblob. Once retrieved, assign that image asp.net image control. Heres the code that uploads the pic to the MYSQL database [CODE] If (Not myups.HasFile) Then Return -1 End If 'FileName.PostedFile.InputStream() Try Dim fs … |
| | i am at the <mysql dir> so i would do [code] scenario 1: mysql -u root -p [/code] i got prompt to enter password as expected. i typed a wrong password and got ejected.. type a right password and i am in. ok this is working fine. [code] scenario 2: … |
| | Hi I have two tables called client and booking, the primary key in client table is clientID which is autoincress number and it’s a primary key, in the second table (booking) the primary key is bookingID and its autoincress number and the clientID is foren key. I have a questions: … |
 | Hi All, In my php script i need to concatenate 4 tables from a foreign key of dev_id. It will be a select *. I know, for example that 4 tables have a value of dev_id=115, but when i run the script it gets no results. here is my attempt … |
| | Hi all, I have 4 tables that all have a foreign key of dev_id. I want to SELECT * from all of them but it keeps saying "ambigious column". Can anybody advise how to overcome this? Thanks |
| | I am building a website that uses php5 and mysql database. I want to upload images alongside other information. To get other information into the table of the database, this I can do very well, but to upload and display the images alongside other information(which may be done online by … |
| | Hi, I have a question regarding outer joins. Suppose I have the following 2 tables each having 2 columns. Employee: EmpId, DeptId Department: DeptId, DeptId EmpId is primary key in Employee and DeptId is primary key in Department. Also, Employee.DeptId is foreign key referencing Deparment.DeptId. My first question: 1. Suppose … |
| | hi guys, just wanna ask is there a good software which can help me plot data or draw a line graph in php? these data are dynamic, and will come from the database..just a simple line graph will do. thanks thanks.  |
| | Hi friends, In my project I'm using multiple tables to sotr the details.There is one main table and in the i'm storing the contact details of the family.And according to the number of members in the family I'm saving the member names and ages in different table.Now what I need …  |
| | Hi anybody has scripts for detecting users' country based on ip? |
| | hi, im making a vb.net app to make a backup of a mysql database on a remote server. i could do it easily with just one select and then a loop for all the inserts but the thing is, single inserts for lots of rows are really slow and here … |
| | Hey, I've come to a bit of a problem - I'm updating a website for users to upload their own games, animations ("toons") and artwork. The trouble is, I've made separate tables for each one, each with very similar structure What I want to do is show, say, the first … |
| | I want to combine the following select statements so I can have 1 export file rather than 2. This code selects student information along with their HomeRoom teacher. [code]SELECT students.last_name, students.first_name, students.grade_level, teachers.last_name, students.student_number FROM students JOIN CC ON students.id = cc.studentid JOIN teachers ON teachers.id = cc.teacherid WHERE (cc.course_number … |
| | Hi All, Can anybody put me in the right direction for counting empty cells in a row? Thanks |
| | Hello all, I have a set of IF ELSE validation code ECHOING onto a php web page through a SWITCH staement. Everything works fine all error messages show up correctly. The problem is, after going through 3 conditons it starts to allow entry into my DB(mysql) all other entries goes … |
| | I have two tables: [B]1st Table Name : country[/B] [B]Table data:[/B] [CODE]------------------ ID | CountryName | ------------------ 1 | India | 2 | Japan | 3 | China | 4 | Canada | 5 | Denmark | 6 | Egypt | 7 | France | 8 | Germany | 9 …  |
| | Hi, I deliberately do mistake on line [inlinecode]INSERT INTO table2.......[/inlinecode] but, it still commits despite variable of rowcount is set to 0. How can solve it? Thanks [code] BEGIN DECLARE rowcount INT; INSERT INTO table1 ……… SELECT row_count() INTO rowcount; IF (rowcount=1) THEN SET rowcount=0; INSERT INTO table2 …………….. SELECT … |
| | Friends, in my project(i'm using php and mysql & i'll be getting all the detail from th user) I've to create a seperate ID for each family. For each family I've to maintain the family members details and the contact details.Now wats the problem is how can I add or … |
| | Thank you Hi, I am Asha Bhatt I have created one table (Question) , which contain 500 of row and 6 column. column name are QusID , Question , Option1 ,Option2 , Option3 , option4 . and in asp.net i have one button and one lable . when i click … |
| | I am using MY SQL when I pulled the informaiton before adding the CUSTOMER_2.dea_license which comes from the other table Customer_2 table everything pulled ok now when I tried to join the other table I get this error Error: A syntax error has occurred. (State:37000, Native Code: FFFFFF37) What is … |
| | [CODE]Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/content/l/i/l/liles13/html/main/libraries/joomla/database/database/mysql.php on line 344[/CODE] Im trying to get a new portfolio site up and running, and I'm very new to PHP. I've read various topics about queries and dropping tables, but I still can't resolve the issue. [CODE]<?php … |
| | Hello. I am having trouble with a count col query I hope some one can help me with. I have six questions and I would like to count how many "yes" answers in each col and then group by that col. Here is my schema table:survey ||id || Q1|| Q2|| … |
| | I was hoping that there would be a readonly system or session variable such as @@username or @@user_id or similar Is there any way I can access username information inside an SQL database please? I am hoping to use it to render certain ROWS visible/invisible in views This would be … |
| | Hi all, (sorry, I am not sure of the technical terms and jargon) I am currently using MySQL for an "inheritance pattern" (please advice on the correct terminology) where I have a "base table" with auto_increment and "sub_type table" that has id that reference the base id. I see the … |
| | Hey guys I Really really need help with an sql query. Apparently I'm missing some big concept and can't figure it out. There are three tables: Customer([U]cust_num[/U], phone, address) Menu( [U]food_name[/U], food_type, price) Orders( [U]cust_num[/U], food_name, quantity) I need to find the phone number of each customer who ordered some … |
| | I have 2 tables, 1 called journeys, which contains the journeyID, the start station, end station, time to complete, and the distance. The second table is called connections and contains all the stations the train stops at along the journey. I need to write a query which extracts the correct … |
| | Hello everyone, I have a problem with my drop down list box on my edit page in php. I would like my drop down list box to show what the user has selected, then if the user wishes to, change their selection updating the DB(mysql) at the same time. I …  |
| | Hi! This is for a homework assignment, and I'm trying to do cascaded deletions on tables that refer to each other. [B] Homework question:[/B] Give an example instance of C and D, having at least 4 tuples in each of C and D, such that a deletion of a single … |
The End.