[sql] Forum Topics

I want the post_delete column to generate unique id's so that when I want to delete a comment for e.g. I can refer to the post_delete's value. [B]Here is my users TABLE[/B] [CODE]CREATE TABLE users ( user_id INT(8) NOT NULL AUTO_INCREMENT, user_name VARCHAR(30) NOT NULL, user_pass VARCHAR(255) NOT NULL, user_email …

Hi! So I managed to upload the picture via php to a folder BUT my problem now is that I want to INSERT the location path of the uploaded picture to the user's pic_location in the database and I don't know how the query will look if I want to …

Can sumone please give me a helping hand here am trying to do a simple sql search were it will look all items in SQL database and pull up the names that match but am having a abit of trouble with it it brings all my accounts up regardless of …

I'm using sessions to receive my info from my database table... But I'm not quite sure how to get a image because if I just say this: [CODE]echo "<img src='" . $_SESSION['pic_location'] . "' />";[/CODE] I only get like a little black dot thingy. I don't know if one could …

I'm creating a link sharing website and I want the user that registers to upload an avatar and use that avatar throughout the website. I got so far that the user can register but can't find a way for him/her to have an avatar. Here I have the signup.php (for …

Hi all, just wondering what the best way is to structure time in sql database. For example, at present i use this format ; 19/08/2011 (which is day/month/year). when i call this in a sql statement, it shows all results, but not in a chronological order. Can any body solve …

From where can I download sql plus 8.0? Please help as I have to submit the project tomorrow..:scared:

Good morning, Firstly, let me say that I have zero experience with database, servers, etc. Now that I have prefaced this long question with that tidbit let me ask the most basic questions. What is the difference between MySQL and MS SQL? I think they do the same thing but …

Hi! I'm start learn php and i have few problems what i can't fix it. Before i say what is my problem, YES i have search for my problem in google and other. So my question is how to make 1)table with few data column and after few column i …

Hello, I'm using MySQL for a database containing 1 table with 10 columns. The point is to get a view of a few columns and use it in a web application So, I need 2 columns from this table - Pad(varchar) and Sequence(integer), then I create 8 views like this: …

Hi i just want to know that how to connect php with sql server..because i have database in my sql server.... regards.. Farhad

i have a query is to lookup CREDIT_CARD table using CREDIT_CARD_ID and get the MIN_REPAY_AMT. if SUM(AMOUNT_DEPOSITED) < MIN_REPAY_AMT for that month Then populate 1000 else 0 i have attempted the query below kindly help me out and i am getting the following error. Error: [CODE]ERROR at line 2: ORA-00923: …

Hi am really new with php mysql, i need help pls. I have created a email software in my server, there is a field for inserting email data info. Right now i am inserting these data one by one, but this is annoying and taking hard time. Pls help me …

hi guys, i'm having an SQL Error in my CMS, somebody please have a look i get this error: "Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\Program Files (x86)\VertrigoServ\www\portal\estrutura\publicidades\exibe.php on line 73" my code: <? $variables=(strtolower($_SERVER['REQUEST_METHOD'])== 'GET') ? $_GET : $_POST; foreach ($variables as $k=> …

Hi everyone, First of all let me just tell you that I have never done database programming myself, and this is the first time I'm setting up a MySQL database via phpMyAdmin, so I could be missing something small but I'm sure someone will know the answer, anyways... I have …

I'm sorry if this should have been posted in the c# forums..... I have created a database for my website and am using MS SQL. This database will need to be accessed by users on the site itself, and from a .NET application. I am comfortable using MS SQL through …

Hi all, I have this code that seems to work fine for the order but cant get it to pass the invoice side of things. the trouble im having is when i do the order its fine, but when i do an invoice it sends me back to the order …

Hi Guys, I have imported an excel document into MySQL to tidy up and make better use of the data but I am having problems running an update. All tables used as examples below; [U]Tables[/U] asset_register phone sim team The asset_register contains the following cols; [CODE] id INT, serialNo VARCHAR, …

I have one Access Database and in one of the column I need to store image file, how can I do that? Can anyone help me. I know how to do this is MS SQL Server Database but not about Access Database.

This is homework. Here is the problem: Produce a list of employee last name, first name and department name. Use appropriate, user friendly column aliases. This is from the tables [ICODE]DEMO.EMPLOYEE[/ICODE] and [ICODE]DEMO.DEPARTMENT[/ICODE]. The relevant column names are [ICODE]LAST_NAME, FIRST_NAME, DEPARTMENT_ID[/ICODE] (from [ICODE]DEMO.EMPLOYEE[/ICODE]) and [ICODE]DEPARTMENT_ID, NAME[/ICODE] from [ICODE]DEMO.DEPARTMENT[/ICODE]. As you …

hi, i am using sm sql express 2008 and this does not have the backup feature. so i have to create a application to back up the database everyday automatically, does anybody know a way to do it,please reply thank you.

I want to build a web app that student be able to enter his/her student id and shows his/her assigned advisor. I think that I 've to build a table in SQL with two attributes 'studendID' and 'advisorName'

This is probably obvious to someone who is familiar with Oracle, however, I'm writing a script file for a class, and it throws an error on the line [CODE]ALTER TABLE FACULTY ADD CONSTRAINT FACULTY_Locid_fk REFERENCES LOCATION;[/CODE] where the table is FACULTY, the column is Locid, and I'm trying to create …

The following code is a part of my project and the output of this code is that i get all the title of the posts in the database and a delete hyperlink in front of all enteries now when i click delete for a respective title it should be deleted …

Hello all. I am in the process of piecing together a software project that I plan to use in the day-to-day operation of my service business. I'm sure this will be a simple question for someone here. I will be tracking employees, service tickets, clients, & client IT Assets. I …

Dear All i need help how to insert data into sql database form a datagrid... this is the example.... i have view data from tabel sales in a data grid product name sales jan sales feb sales mar MILK 10 15 20 Biscuit 7 6 9 Tea 5 15 30 …

Hey, I am very new to php. I have a PHP script (modified from [url]http://woogley.net/misc/Highscore/)that[/url] I call from a my Java code to access a database in order to read/write records. The SELECT part of it was perfect. However, i can't write to the database when I try to UPDATE. …

I have a webpage that builds an html table if there is any data in a mySQL table. That works fine, the html table is populated with data from the mySQL table. My problem is when there is data it populates the html table but lists the first mySQL table …

Hi all, Im starting to program in java with sql. The problem im having is that when im trying to complete a combo box with data from a table in sql i get this error: [U]"null error in cargarComboProvincias()"[/U] when i run the program, and i cant find the error …

Having problems with the TypeError below: [code]order_list = ['25459 ', '12381 ', '25375 '] cursor.execute("SELECT WVGID6 , WVWHID, WVITNO, WVLOCA FROM WMRSV WHERE OHORNO IN (%s)"% tuple(order_list)) TypeError: not all arguments converted during string formatting[/code] The correct SQL should look like: [CODE]SELECT WVGID6 , WVWHID, WVITNO, WVLOCA FROM WMRSV WHERE …