[mysql] Forum Topics

how can we check whether the primary and foreign key are working in the database in mysql

Hi, I need to retrieve the max and min values of the price field in my db. I have a item table and a category table. I am using $_GET['category'] to get the category name and then I need to retrieve the min and maxvalues only for the items in …

I have a small database, at the present time, built for basic tracking and it has 5 rows ... trackid datetime uid emailaddress orgcodetrack It's populate with 10 records test data from 3 users (uid)... I need to return the total visits from each uid... Here's what I have so …

hey, I am having some trouble with this one. I am doing a student web organiser.The user registers details which goes into userinfo and sem1week1. My three tables are: 1.userinfo: firstname, lastname, e-mail, username, password, coursecode, courseyear. 2.courseinfo: subject, time, day, semester, coursecode, courseyear. 3.sem1week1: username, coursecode, courseyear, day, time, …

hai i want a shell script to load data from a csv file into mysql table plz reply me soon urgent

Hi Ive reached my own limit with this one... hopefully its not that tricky. I have a products table, each with a unique id. I then have a complimentary_items table which links two products as 'matches'. The complimentary items table has three columns: id, prod_id1, prod_id2. Can I write 1 …

i had a table categories(cid int primekey,name varchar,description text,parent_id,created date,updated date) i want a script for insertion like this insert into categories(...) values(cid value,name value,..desc, parent_Id..); can i write the statement as insert into categories(....) values (1,'aaa','some text',[U]select parent_id from categories where parent_id=id[/U],date,date); just i wana know how can i …

I use MySQL-Front tool create and call Stored Procedure successfully, but in my PHP code and phpMyAdmin it fails. How can i figure out this problem when i run on phpMyAdmin the error show #1305 - PROCEDURE joomla1.5.9.save_orders does not exist this is my code of procedure [code=sql]DROP PROCEDURE `save_orders`// …

I have a query [code=language] SELECT radcheck.id, radcheck.UserName, radcheck.epost, radcheck.fylke, MAX( radacct.AcctStopTime ) AS AcctStopTime FROM radcheck LEFT JOIN radacct ON radcheck.UserName LIKE radacct.UserName WHERE AcctStopTime LIKE '%2009-03-19%' GROUP BY radcheck.id[/code] I'm looking for a way to use wilcards, > <, NOT LIKE etc on only the highest date value …

i have a database and it has a column thats id its auto incrementing and one called download_link i want to have that autofill with a url thats concatinated with my id so localhost/upload/downloadtest.php?id= adds the id and becomes localhost/upload/downloadtest.php?id=1 localhost/upload/downloadtest.php?id=2 localhost/upload/downloadtest.php?id=3 etc how could i do that be done

i have a table holding files and each has a unique id eg. 1, 2, 3 etc. i have a column in the table i want to contan the link that should be <a href=\"localhost/upload/dltest.php?id=(number) eg. <a href=\"localhost/upload/dltest.php?id=2 i want that link to be auto created from the other information …

I have two tables, question_table and answer_table. i want to be able to select a certain number of questions in a random order and have the answers that relate to the selected questions also display. IE: question_Table: ID: Question_Text 1 Who are you? Answer_Table: ID: Question_ID: Question_Answer 1 1 Me. …

I would like to create a table in mysql, with one of the fields being images. Can any one tell me what type i should call the field, and also if i have to put in any special commands. thank you

i had a table categories category_id parent_id industrial null automotive null petrol industrial bikes automotive diesel industrial tankers automotive ....so on ihad another table CATEGORY_PRODUCT with fields(category_id) in this table i want to insert the category_id from category table as if parent_id=null then insert category_id as parent_id if parent_id !=null …

I have three tables in the mysql database. Let's say: Table: Human -> Fields: human_id (primary key), name Table: Attribute -> Fields: attribute_id (primary key), name Table: Human_Attribute -> Fields: human_id (foreign key to human table), attribute_id (foreign key to attribute table) Cardinality: Human Table to Human_Attribute Table (1 to …

I have a registration page that needs one final thing and I'm a little stumped... In one table I have email, pass, gender, dob and the other I have company... In the registration page, I want to check that the company exists before I submit the form... Since I'm using …

Hi I have the code below and I just simply want to return the results from another table ant the same time. I thought I could just add FROM member, members2 or add a join but nothing seams to work, I just get a blank page. [code] $sql = mysql_query("SELECT …

Hello, I am just starting to get into mysql and have a quick question: I have a table that has a datetime field, and i simply want to store that datetime into a variable and be able to print it, and also compare it to the current date to see …

Okay, I don't understand this at all. Maybe someone more polished could help me. I am trying to enter a group of numbers into the database using PHP and it works on my personal server, but then when I try it online it only takes the first number of the …

Hi, I am currently developing a website which uses MySQL with PHP, and right now i wish to upload all files and DB to my server, but am stuck with the connection path... Server: Windows Database: MySQL Webhost C Panel: Helm Web Host Database name: hotel Can anyone provide me …

Hey Everyone, First post to the forum so go easy on me... So here's the deal... I am writing the php/mysql for a page that updates my database with the values of a member who's membership details have been edited. I am having problems getting the values to update into …

i had a table productcs with stucture as pid,name,description,applications,created_at as datetime,updated_at datetime. i will load the data from a csv file.now i want to insert the current timestamp while loading the data i.e the present time at which i am loading the data .is it possible to insert the current …

Hello, The problem is I have made a second user account for my databases, every time I open the MySql monitor it doesn't prompt me for a username, it just assumes I want to log into the Root and asks for my Root password. It doesnt ask for a username …

Hi everyone, I am inserting value in a table in a database through query but it is giving some error as like this :- Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near …

Hi, I'm not sure if this shpould be in PHP or here so apologies if I'm in the wrong place. I'm trying to encrypt a password and insert it into my database along with other data. Everything works when I remove the md5 password encryption. It doesn't work when I …

Though the directories and files still appear to be there, I don't see any of my MySQL databases when using the tools I normally use. This happened after I restored yesterday's backup. Need help.

I give two parameter like year & period. For example year = 2009 & period=3 Result : 22 working days in this month Plz help me.

i want to insert data into third table for two tables that is first table:table struct: pid -->int,name-->string ..etc second table :cid -->int,parentid-->int....etc third table struct is:pid-->int,cid-->int now iwant to insert data into third table from the other two tables pid from first table is a prime key and pid …

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 …

i am trying to mutiply and add 2 dnamic texts on a php form, but i do not seem to get the reply, but i get the following results "sum (4 + 1)" This is the code that i typed in [ICODE](<?php echo $row_standings['w']; ?>+<?php echo $row_standings['d']; ?>[/ICODE] The 4 …