2,403 Solved Topics
Remove Filter  | |
| | Hi, Fairly new to MYSQL, still learning. I have create basic web databases before but the project i am working on just now is slightly more complex than before and need some advice. i have had some help qith queries which has been great however i need some advice from … Databases mysql |
| | |
| | I've got a situation with minibus repair database design, where it looks like in the Repair table I could do with a 3-composite primary key: jobID from the JobType table (types of maintenance with price and time), mechanicID (Mechanic table), minibusID(minibus table). This way, I've got type of job performed … Databases database-design mysql |
| | Ok, I'm new to php and MYSQL aswell. I have a couple programs actually that are getting this error and I don't see what could be causing this at all. Here's the situation. I have a job interview page. The user enters the information from the candidate and submits the … Databases mysql web-browser web-server |
| | Hi, I have a query: [CODE=sql]SELECT h.id, h.creator uid, h.haiku, h.title, h.likes, h.approved, cat.name category, count(c.id) comms, h.anonymous, CASE h.anonymous WHEN 1 THEN 'Anonymous' ELSE u.username END username FROM haiku h left join categories cat on cat.id= h.category left join comments c on c.haiku=h.id left join users u on u.id=h.creator … Databases mysql |
| | Hi, I'm trying to code a league table system and I was wondering if there's an easy way of doing this: [CODE]$result=mysql_query("UPDATE Championship SET played="++1" WHERE team_name='$home_team'") or die(mysql_error());[/CODE] The problem lies in the played="++1" part, I can set it to be any integer, but that's not much use, I … Databases mysql |
| | Hello, I have a little issue getting what I want displayed from a single table. Basically, here is what I am trying to accomplish. I have the following type of table: Place Action B/S Qty Type City Full B 1 View City Partial B 1 View City Partial B 1 … |
| | Hi people, My issue is more of a MySQL issue than php. I am trying to store a 3digit integer value with a leading Zeros in front such as 001 i have a company table , which auto increments the id as 001, 002, 003...and so on... In the company … Databases mysql |
 | Hi guys , I am creating a timekeeping application to keep track of users. In my database I have a table which stores the time a user starts their break and finishes their break. I want to return the total time that the user is on break in minutes to … |
| | I am New TO Programming Am HAving 2 Table One Table Having Coloum ID and NAmeOf Eventt And Other Table Having Coloumn ID and Imagepath I want To Retrive Id related the NAme Of Event and Want To Insert That ID into other Table at the same time i want … Databases mssql |
| | Hi, i've been working on this simple homework assignment and the only thing stopping me from finishing it is passing a c++ variable to a mysql query using mysql_query. I've searched around for about an hour and every potential solution I have found hasn't worked, so I figured maybe if … |
| | Hello, can you help me convert MS SQL DateTime to miliseconds since 1970? Thanks, Domen |
| | DOH spelt thread name wrong... should be query! This is surely simple... this is the end of my query [CODE]where CCM0300.dbo.Device.tkModel= '72' AND CCM0300.dbo.NumPlan.DNOrPattern like '31455' OR CCM0300.dbo.NumPlan.DNOrPattern like '38600' OR CCM0300.dbo.NumPlan.DNOrPattern like '36305' OR CCM0300.dbo.NumPlan.DNOrPattern like '36805' OR CCM0300.dbo.NumPlan.DNOrPattern like '38285'[/CODE] what this is meant to do is return … |
 | Just struggling through my SQL coursework, and already fallen over the first stubling block :( My case study tells me that i need to put a foreign key from my centre table (parent) to my salesman table (child) on a 1-1 relationship. Trying to add my foreign key, which is … |
| | Basically I'm a noob with database work andjust need a kick start to complete the rest of my other diagrams, seeing as the use case was the first step I thought I would ask for some help :D So this is my situation, can someone help me make a use … Databases |
| | hi, could anyone recommend a free mysql query builder? i have been working on a database and had some help with some small queries, however i need to create a large recordset through dreamweaver and wondered what tool i could use to generate my query visually? many thanks Databases mysql |
| | Hello , I am working on getting this Mortgage repayment calculation code to work for my Access07DB, the code for was copied from some 2006 post on a vb forum. But some things I cant get to work [COLOR="red"]I will put the bad lines in red[/COLOR] [CODE] Option Compare Database … Databases microsoft-access |
| | Hello, I have two tables--QUESTIONS, ANSWERS. I store the questions in one table and the answers in the second. Table Structure--QUESTIONS Field 1: Question_ID Field 2: Question Field 3: Question_Type (There are 3 types of questions) Field 4: Step_ID (There are 15 steps in the program) Table Structure--ANSWERS Field 1: … Databases data-structure mysql |
| | Hi everyone and thank you for helping me... again :icon_neutral: I am trying to perform a MATCH AGAINST sql query on one of my table called "what". [ICODE]id (int 11) PRIMARY org-id (int 11) keyword (varchar 100) FULLTEXT bid (DECIMAL 4,2)[/ICODE] I want to perform a search on the column … |
| | Hi, i am relatively new to mysql just learning the basics really. i have googled this but there is so many discussions on it. Could someone just give a simplified answer to what is the difference between using Union or Join and when would you use one or the other? … Databases mysql |
| | from mysql command line, what's the command to import query from a text file? does mysql has this ability? it would be handy if so.... does the text file have to have mysql file type? please be a bit specific. thanks very much. Databases mysql |
| | hi i need to create a query that will query my 6 tables that have an amount column & date paid column. i need to total up all the amounts due, so therefore the datepaid column would be null. can anyone help how i would be able to view how … Databases mysql |
| | Hello, i'm having 2 tables one is CLG and other is STUD. in CLG(columns CID-autoincrement and CName) and in STUD( three columns are ID-autoincrement,Name and CID) > im using this code to store the records into tables [CODE]$sql="INSERT INTO clg (Cname) VALUES ('$_POST[cname]')"; $id=mysql_insert_id(); $sl="INSERT INTO stud (name,CID) VALUES ('$_POST[name]',".$id.")";[/CODE] … |
 | Hey guys, this is probably a really simple question for you experts so I hope you can help..! Basically I have three separate html fields for the user's date of birth: "year" "month" and "date" All I'm trying to do is to take these three from the form and insert … Databases mysql |
| | Hi thanks for reply, I just tried that and it does the same - both phrases on the same line in the RTF memo field Ive used vbnewline in a msgbox before and works fine, but it stumped me as to why its not working in memo field. once i … Databases microsoft-access |
| | Hi there (Can DoCmd.openform allow formname from stored string value?) I am needing to vary the FormName part of the .openform based on a result looked up in another table. as I have 10 Different forms that will be specific to a certain kind of record. My code something like … Databases microsoft-access |
| | Hello guys help pls i'm trying to populate data from MS Database to list-view [code] string Collect_FULL = "SELECT FirstName, MiddleName, LastName, " + " Gender, DoB, Dependents, Address + ', ' + City + ', ' + State + ', ' + ZipCode AS Address, PhoneNumber, MobileNumber " Status … |
| | I was searching around but I could not find it: I'd like a tool(free or paid) that is able to manage multiple MySql servers from the same GUI. I know about a few thick-client apps that do this, but I need one that you can use it from internet(forget about … |
| | Hello' I'm using following code and getting mysqlerror Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs/..... Code is $query="SELECT ('$retfield') FROM ('$table') WHERE ('$givefield')=('$val')"; $res=mysql_query($query); if(mysql_num_rows($res) > 0){ } Upto my knowledge I'm using correct syntax bt I dnt where I'm going wrong. Can anyone help … Databases mysql |
| | Hi All, I am trying to convert the following access update query into TSQL without any luck: UPDATE tblCattle INNER JOIN tblFarmDetails ON tblCattle.strEartag = tblFarmDetails.EarTagNo SET curMartPrice = tblFarmDetails.MartPric WHERE (curMartPrice=0 Or curMartPrice Is Null); First I tried simply pasting in the query with no luck so below is … Databases microsoft-access mssql |
| | Please is it possible to have two where statement in an sql query? for example: SELECT * FROM Persons WHERE FirstName='Peter' but I want another condition which will also pass the query like: SELECT * FROM Persons WHERE house='duplex' or car='Honda' Is the second query correct if not how do … Databases oracle  |
| | Hi, When I register a member using my script, why one of the column have "Resource id #14"?? Below is the code: if($do->new_user($username, $encoded_password, $email, $alertpay, $referral, $country, $c, $referral2)) {mysql_query("INSERT INTO history (username,type,time,custom1,custom2,custom3,custom4,custom5) VALUES ('{$username}','joined',unix_timestamp(),'0','0','0','0','0')"); mysql_query("UPDATE users SET balance=balance+'0.20' WHERE username='{$referral}'")or die(mysql_error()); mysql_query("UPDATE stats SET users = users + … Databases mysql |
| | Please is it possible to have two where statement in an sql query? for example: SELECT * FROM Persons WHERE FirstName='Peter' but I want another condition which will also pass the query like: SELECT * FROM Persons WHERE house='duplex' or car='Honda' Is the second query correct if not how do … Databases mysql |
| | In my VB6 project i have a text area field, iwant to insert data which i give in that text area wants to insert into Access database. For that which data type i need to take for that column. 1) If i take Memo or text as datatype: only singleline … Databases microsoft-access  |
| | Hello everyone, I currently doing a database project, which is part of my coursework, and I am having some difficulties. So, I am making it in Microsoft Access 2003. In my form, I want have to tabs (Client and Music Store), and I already have 2 tables, for each tab. … Databases microsoft-access |
| | Running a SQL query from the following code: [CODE] <php if(sizeof($_POST['addcandidate'])){ foreach($_POST['addcandidate'] as $id){ $name= mysql_query("SELECT LastName FROM candidate WHERE Candidate_ID= '$id'"); while($rowz= mysql_fetch_assoc($name)){ $candidatename= $rowz['LastName']; $alter= "ALTER TABLE '$votertable' ADD '$candidatename' int"; mysql_query($alter) or die(mysql_error()); } } } ?> [/CODE] I return Im getting: [COLOR="Red"]#1064 - You have an … |
| | |
| | Hello folks, I'm getting the error message "Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING in /var/www/login.php on line 9". I've been at it for hours and my eyes are starting to bleed, I would greatly appreciate a code-weary traveller could spot my mistake. Here's the first 10 lines of my page. … Databases mysql |
| | l have got a table populated with data. l need to export and append the contents of the table to an existing table. l have got an auto_increment column which l need to change so it starts at 100 not one Databases mysql |
| | I am new to php/MySQL, so I apologize in advance for any stupidity on my part. I have a MySQL database for events, and the main table ("Brochure") has multiple Trip Leader fields, e.g., "Leader," "Assistant Leader," "Leader in Training," etc. All of these leader fields get their data from … Databases mysql |
| | Hi all, if anyone can assist I have a query which just will not resolve it self no matter what I have tried. I am testing this PHPmyadmin before I apply to the website if this helps Thanks in advance DJ The query that is being run produces duplicate row … Databases mysql |
| | im newbie on MySql... im trying to migrate my DB(MsAccess) to MySql.. i have this sql statement on my MsAccess [QUOTE]SELECT MI.MIDate, MI.WIStockNo, Month(MI.MIDate) & ", " & Year(MI.MIDate) AS Period, MI.MIStockName, MI.MIUnitM, MI.MIRequired, MI.MIUpdated, MI.MIBCQ, MI.MITo, MI.MISection, MI.MIPurpose, MI.MIJobNo, MI.MIItemNo, MI.MIEncoder, MI.MIRequisition, MI.MIStockman, ([MI.MIRequired]*[WItems.WIAmountUnit]) AS TotalReqAmt FROM WItems INNER … Databases mysql |
| | I am developing a database whre people can register and connect with friends. I am stack at how to store friends. Should I create a Table Friends with fields Friend_ID, Reg_ID, Reg_ID_2. Reg_ID and Reg_ID_2 are values from the Registration table which is the primary key. Thank you for your … Databases |
| | Hi I have a mysql table name ( Discriptions ) that holds many normal text discriptions (doh'). How do I write a mysql query to search this table! Example: the description 'red paint': If I enter 'paint red! My query will not find it! Thanks for any help! Paul Databases mysql  |
| | Hello I would like to create a reference field. I would like it ti have a fixed number of charaters/numbers, just like the videos reference of YouTube. Is there a mysql/php function to handle that? I mean a function that generates a unique string that doesn't exist already in the … |
| | I cannot find the mistake in the below code, I receive "statement ignored error" at the last line of the first select clause part of the code:[CODE]SELECT * BULK COLLECT INTO l_employees FROM employees;[/CODE] But I am not sure if thats the real problem. Here is my full code [CODE]declare … |
| | I'm not quite sure how to do this join: Table1: Products -------------------------- Prod_ID | Prod_Name | etc Table2: Images --------------------------- IMG_ID | Prod Name | Prod_ID | [CODE] Select Prod_ID, Count(i_Prod_ID) from tblImages right join tblProducts on tblProducts.Prod_ID = tblImage.i_Prod_ID [/CODE] Does not produce what I need..... The desired end … |
| | [COLOR=#000000]Can you help me to normalize Online Hotel Reservation System. In the database I will store information about the hotels (name, city, country, number of stars, room prices, total number of double rooms, total number of single rooms, number of available rooms, etc); customers (name, email, telephone, address, username, password, … Databases email |
| | In phpmyadmin and wanting to copy the mentioned rows below to within the same table. I am not copying the id so it is automatically incrementing. Why isnt it working??? Thanks in advance. INSERT INTO `table1` (title, alias, published, introtext, video, gallery, extra_fields, extra_fields_search, created, created_by, created_by_alias, checked_out, checked_out_time, modified, … |
| | Plzz help, all i have now is Warning: mysql_pconnect() [function.mysql-pconnect]: Lost connection to MySQL server at 'waiting for initial communication packet', system error: 95 in /home/plmzxsi/public_html/hull/Connections/stronaHull.php on line 9 Fatal error: Lost connection to MySQL server at 'waiting for initial communication packet', system error: 95 in /home/plmzxsi/public_html/hull/Connections/stronaHull.php on line 9 … Databases mysql |
The End.