7,368 Topics
| |
can u please provide me with a c/c++ program to add a user to MySQL and allow him to only insert into the database | |
hi, my table has following fields ForumPostsId(primary key),ForumPost,ParentPost parentpost can have 0(which means its parentpost) or ForumPostsId(which means its a chlid post related to parentpost) i need to generate a list which will the show parentpost and count of child post related to parent post Any suggestion!!!!!!!!! regards rajan | |
Hi all, I'm a java programmer but currently have a task to compare different list and output their common element in PL/SQL. In java this is very simple but i'm not sure how i would handle this in sql since I'm fairly new to it. ex l1='A,B,C,D' l2='B,C,D' l3 ='A' … | |
can someone help me with this pls.. [CODE]DELETE FROM site_post, site_comments WHERE site_post.id=$id AND site_comments.matchid=$id[/CODE] needing to delete two rows one from each table. | |
may peace on you !guys i am new to MySQL query. i am developing a student information management system and the way on to which i am stuck is i wanted to add fine on student fee if the remaining is not zero of previous month and next month arrives.the … | |
Hi Guys, Another puzzle for someone to try and crack... I have two divs inside the <body> that basically act as two versions of the same page. I need PHP to call one based on a variable retrieved from a database. As it stands, this is what I have... [CODE] … | |
I have 2 query which I want to make it as 1 query. Could anyone help me. Because the query is just the same. The difference is they have 2 condition which 1 query for same year and another query for different year. [CODE]If (bboard = "All") Then If (qter1 … | |
Hello, I am a computer science student working as a bartender in a restaurant. My boss was complaining that his monthly inventory audit was taking too much time (as he has about 2000 unique items to count) and I suggested I could build a mysql database to help him (and … | |
Hi guys, I'm wondering if there is a way to solve this problem. Currently, I have an SQL statement that goes this way: [CODE]SELECT distinct name,id from list [/CODE] My understanding is that it selects the things that are distinct on both tables. Example: id name 1 Joe 2 Joe … | |
how to lookup datasource which is created in glassfish with some jndi/dbname name. I am trying to get datasource writing code in a servlet like this Datasource datasource = (Datasource)initialContext.lookup("jdbc/customer"); Connection con = datasource.getConnection(); but it is throwing NameNotFoudExcepion for this context . how can access datasource created outside of … | |
Hi . I am building a live chat using mysql and the database is updated because of users entries . So the number ow rows in the table changes constantly . And need to use a query which will select the rows that hasnt been selected. SO how do I … | |
Hi everyone, I'm a beginner in working with PHP and I'm stuck with an annoying problem. With the help of a tutorial I've made a pagination for database results that works great. Now I'm trying to adapt the code and use the same pagination for a search-page on my website, … | |
Hey Everyone, hope all good. i have a problem with some php that is not randomly selecting an ip. I will try to explain my problem below. I have a state form [CODE] <select name="State"> <option value="0" selected="selected">Select a State</option> <option value="AL">Alabama</option> <option value="AK">Alaska</option> <option value="AZ">Arizona</option> <option value="AR">Arkansas</option> etc..... </select>[/CODE] … | |
help me update my database.. when i click edit it will add a new record.. i want to update a record.. to edit a new record it will be base on the cutsomer's nameu [CODE]Dim conn As ADODB.Connection Dim RS As New ADODB.Recordset Set conn = New ADODB.Connection conn.ConnectionString = … | |
Hye , I am having this kind of problem. Could anyone please help me why I am getting this error? [CODE]UPDATE company_alert SET company_alert.alert_value = company_financial.receivable FROM company_alert INNER JOIN company_financial ON company_alert.stock_code=company_financial.stock_code WHERE company_financial.year_id=company_alert.year_id[/CODE] You have an error in your SQL syntax; check the manual that corresponds to your … | |
Ok I am stumped so bad. I am using a form to insert a topic and comment into a table and if the topic is new it creates a new table specific to that topic. So I pass the topic name through the url and Im trying to retrieve it … | |
am geting this error while testing the login panel of my website that am currently developing. Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/smartie1/public_html/checklog.php on line 43 which is in red this is the php script used for login <?php session_start(); function session_defaults() { $_SESSION['logged'] … | |
hi guys, well.. i run my php program and the page just displays the following: [CODE]Parse error: syntax error, unexpected ';' in C:\xampp\htdocs\Azone\Azone\profile.php on line 160[/CODE] i checked line 160 more than 1,000,000 times and i got nothing to change! here is the whole code of the page, please help … | |
hi every1 i m using mysql as my back end and it runs on whole on intranet in my office. the error i m getting is Error: 1040 SQLSTATE: 08004 (ER_CON_COUNT_ERROR) mESSAGE Too many connections when users r trying to access the webpage. how can i remove the error. plz … | |
Hi, If any combination of these 3 (Name, Surname, DoB, Nationality) user inputs matches to database records then the query shouldn't stop to avoid duplication. If there any special function in MySQL because running 12 query wouldn't be nice for it! Thanks in advance | |
SELECT ExtractValue(bulk_custom_field_string,"//CustomFieldValue")as CatalogValues FROM candidate_work_profiles i am getting output as 'false No 36 January 2007 January 2010' i want output as Separate Column false|No|36|January 2007|January 2010 please help me | |
hi, am working on a bigger project than this, only using this as an example because i do not want to waste a lot of your time. i have this code, its supposed to write to the database, but have no idea as to what i should put under action= … | |
Hi, I have two tables. Payment and expense. 1. select sum(amount) from payment gives me total payment amount 2. select sum(amount) from expense gives me total expense. 3. I want to join payment and expense table. How can i subtract query1 minus query2 in one join query? Thanks. | |
Hello Everyone , I have developed a windows application with mysql database server. i have installed it to client machine also. Now,the problem comes when i restart mysql server or server computer. After i restart server,client application can not able connect to server . if i disable network and enable … | |
I have a theory about the design of a new site I am working on. If a user accounts table is in one database, and the site content tables in another database, then it would be impossible for a hacker to use SQL injections in a form unrelated to the … | |
Help, I have a big probem. I wanto to read data from an mysql table and then write this data into a form so that the user can update this data. The code could seem somethin like this, but it doesn't work [code] <?php include 'complete.php'; $user_name = "exa"; $password … | |
hey...i need to ask ..how to put two field in one column? let say, i have one field call Quantity for weight. Now i need to put the quantity unit which is store in other field call unit. how i concat two field in one column....? | |
i need help with my database. i always backup my database everyday.. but whenever i am doing this and when the backup is ongoing, all the system which connects to this database server always encounters hanging. now, i have no choice to stop backuping the database so that the users … | |
Hi. I'm trying to create a function which connects to a database, and then displays rows in it. I'm trying to use a function to connect, but it's not working. Here's my first code: [CODE]<?php define("SERVER", "mysql.example.com"); define("USERNAME", "username"); define("PASSWORD", "********"); define("DATABASE", "db"); function displayFunction() { $dbc = @mysqli_connect(SERVER, USERNAME, … |
The End.