[queries] Forum Topics

i am trying to write a script that stores information from a html form into a mysql db. i have had the code work to stoer the information into the db but have since modified the code to accomodate the image up load also. i wan the code to stoe …

Hi I'm using whatsmy.browsersize.com to get my browser size for adding mediaquries to my css files. For some reason when i write a media query for max-width: 1229px the query gets applied at 1350px! I'm writing my queries like this @media screen and (max-width: 1229px){ .galleries > ul > li …

Hello guys, I created two database in derby: DB1 with one table Customers and its columns id,name,last And DB2 with one table Purchases anf its colums CustID, total I would like to makes queries from data in both of these database. I tried SELECT C.name, C.last, U.Total FROM DB1.Customers C …

hi my name is vishal for past 5 days i have been nuts of how to combine data from multiple tables into single table using sql select query (join query) Given below i have tried solution but i get error message data not found. But in table i have datas …

Please help! i am troubling about on how can i execute my sql script properly. Thanks!Here's my code $sql="INSERT INTO inventory(account_number,serial_number,locator,remarks,`date_assigned`) VALUES('$accountno','$serial','$locator','$remarks',NOW())"; $sql.="INSERT INTO action_log(action,username,`date`) VALUES ('assigns the box($serial) to $accountno','$user',NOW())"; $sql.="INSERT INTO account_logs(action_log,account_number,username,`date`) VALUES('Assign','$accountno','$user',NOW())"; if(mysql_query($sql)){echo "Successfully Assigned!";} else{echo "Insertion Failed!";}

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 …

now i set insert query and reject query like this ALTER procedure [dbo].[sprejectapprove] @UserID int, @DocID int, @ApproveType nvarchar(50) as Insert into Approval(UserID,DocID,ApproveType) values(@UserID,@DocID,@ApproveType) Reject ALTER procedure [dbo].[spinsertapprove] @UserID int, @DocID int, @ApproveType nvarchar(50) as Insert into Approval(UserID,DocID,ApproveType) values(@UserID,@DocID,@ApproveType) and i call this sp's in this codes protected void GrdFileApprove_RowCommand(object …

This is a school project which I am a bit lost on. I have two tables with a relationship between course +-------------+----------------+ |id(primary) |coursename | +-------------+----------------+ enrolled +-------------+----------------+----------------+ |id(primary) |studentName |courseid(FK_from| | | |course.id) | +-------------+----------------+----------------+ I can insert a new course into the course table using the INSERT syntax …

Hello. I am having a bit problem with the insert query, Every thing is fine but don't know why its not inserting the queries. Have a look onm code; function insert() { var table=document.getElementById("myTable1"); var table=document.getElementById("myTable"); <?php $con=mysqli_connect("localhost","root","","bsc_db"); // Check connection if (mysqli_connect_errno()) { echo "Failed to connect to MySQL: …

A lot of questions in the VB.NET forum are database related. Most of the code that gets posted result in one or more comments like "use parameterized queries to avoid SQL injection attacks". I won't describe the nature of a SQL injection because it is easily looked up via google. …

Hi All, I'm having a go at SQL queries and have the following: SELECT b.vSeries_Table_Number, b.vSeries_Number, b.vSeries_Geography, b.vSeries_Type,b.vSeries_Unit_Type, a.Variable_Date, a.Variable_Value FROM tblPopulationSC AS a INNER JOIN tblVSeriesList AS b ON a.vSeries_ID = b.vSeries_ID and b.vSeries_Geography='Manitoba' --and b.vSeries_Unit_Type=' 15 to 64 years' and b.vSeries_Type=' Both sexes' and b.vSeries_Unit_Type=' 65 years and …

Hi! I have a problem... I need to make simple upload script which for me as a novice php programmer isnt so simple aat aall! So if someone could point me to a good tutorial or solve my problem, it would be great! Ok, this is what i have now. …

Hi, I am trying to use mysql select query in a shell script but i need to know how to store a particular value from the output of the query in a script variable. my script file is given below. I need to store the value under field CheckSum in …

I doubt this is the right place to post this question, but I didn't know where else I can put this. It does kinda involve PHP, but I've asked this question on Stack Overflow and didn't get much help. If this is the wrong place to put this, please do …

I have three table that are linked like this. Each content is linked to a category and each category is linked to a section. Like this sections_table -section_id -section_name categories_table -category_id -section_id -category_name contents_table -content_id -category_id -content_title -content_description I want to write a query to display only content from a …

Greetings to the Community, I need some assistance with a MySQL query that is running very slow. I must admit that I am not a MySQL expert and I wrote this query with hints from several postings on Daniweb, so I'm looking for some hints to speed it up. Here's …

hey guys, i have a query wherein one table has the same id as the other using inner join.. SELECT c.cat_name, g.maxscore, g.description FROM grp_performance INNER JOIN category ON g.cat_id = c.cat_id Is it possible to use inner join when deleting a row? like.. DELETE FROM grp_performance INNER JOIN category …

I have this page that you can do a search on the site. However, if I do a search that contains an apostrophe ('), it breaks and doesn't display anything although I have entries that have them. Does an easy fix exist for this problem? This is an example of …

I have these two queries which i want to run together and not one by one. How can i do that? Or can it be modified to be one query. [CODE] UPDATE runquery.table1, runquery.table2 SET runquery.table1.`Column1` = (runquery.table2.`Col1`/runquery.table2.`Col2`*100) Where runquery.table2.`itemid` = 3 and runquery.table1.`Userids` = runquery.table2.`userid`; UPDATE runquery.table1, runquery.table2 SET …

Hi, I have this code that adjusts the position of the subjects and the pages in my site. This is working where the value of the radio button = 1 (which is = showing, in the database - And 0 = Not showing) And I am talking about pages for …

Hi I have a c# console app that calls some access 2007 queries. One of these queries throws an error "Undefined function 'MonthName' in expression". I understand that some functions that are available in VBA cant be called from c# and if i comment out the 'monthname' function the call …

I am fairly new to MySQL and having some problems figuring out how to format a couple queries using the following database: branch ([U]branch_name[/U], branch_city, assets) customer ([U]customer_name[/U], customer_street, customer_city) account ([U]account_number[/U], branch_name, balance) loan ([U]loan_number[/U], branch_name, account) depositor ([U]customer_name[/U], [U]account_number[/U]) borrower ([U]customer_name[/U], [U]loan_number[/U]) I need to find all customers …

I have the login page created that captures the userid & also an edit page that shows all info of a certain table in database. Trying to figure out when a user views the edit page to have it only show the info the user created. Making it only possible …

Im trying to get the queries and results to load quicker. I have 10 of these after each other with slightly different queries, how can i optimize this please, i have tried removing select * and entering the field names require (which is about 9 rather than the 40 with …

Hello, I am building a search filter, but I don't have much experience using AJAX. What I want to do is select a subject from an initial list then return a list of tutors which I have already done. Then I would like to return a list of centres, year, …

I'm trying to write this query, but I don't know how to go about it. Say you have a table with a bunch of listings, with multiple listings per company. You have a status field in the table that is either complete or active. What I want to do is …

Hi there, I have built a simple CMS that is generally working well, the issue I'm having is with building dynamic navigation. On the site the content for the individual pages is fine but getting the menu data and creating the menus is causing problems. I have 2 possible structures …

ok so i have to tables and i want to have a query that selects all from "table a" and "table be" where "a certain variable"="$x".. how do i select all from 2 tables at once?