[queries] Forum Topics

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!";}

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 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 …

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 …

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 …

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 …