# General Database (Oracle, SQL Server, etc)

**URL:** https://www.phphelp.com/c/general-database-oracle-sql-server-etc/7.md?page=3

[Latest](https://www.phphelp.com/latest.md) · [Categories](https://www.phphelp.com/categories.md)

**Page:** 4

---

## [Please help Its urgent.....](https://www.phphelp.com/t/please-help-its-urgent/16045)

<div class="topic-metadata">

**Author:** [@jlmloves2007](https://www.phphelp.com/u/jlmloves2007)\
**Replies:** 1\
**Last updated:** [May 3, 2012, 5:37pm UTC](https://www.phphelp.com/t/please-help-its-urgent/16045 "2012-05-03T17:37:27Z")

</div>

Taking a variable from the login form and using it in another form and store the same variable in the database table, and retrieve the same values when that person logs in. For example if there are two users - user1 and…

---

## [updating profile information(mysql database)](https://www.phphelp.com/t/updating-profile-information-mysql-database/16819)

<div class="topic-metadata">

**Author:** [@suchait](https://www.phphelp.com/u/suchait)\
**Replies:** 1\
**Last updated:** [April 30, 2012, 10:14pm UTC](https://www.phphelp.com/t/updating-profile-information-mysql-database/16819 "2012-04-30T22:14:34Z")

</div>

i am working on a project in which i need to create a option for for editing a user’s profile… but getting error now … update.php (script for present the saved data) : \<?php include('lock.php'); $host="localhost";…

---

## [oracle stored procedure query](https://www.phphelp.com/t/oracle-stored-procedure-query/16760)

<div class="topic-metadata">

**Author:** [@jdd](https://www.phphelp.com/u/jdd)\
**Replies:** 3\
**Last updated:** [April 24, 2012, 8:28pm UTC](https://www.phphelp.com/t/oracle-stored-procedure-query/16760 "2012-04-24T20:28:40Z")

</div>

I am attempting to retrieve data from an oracle stored procedure. Read only. The retrieved data will be inserted into a separate mysql db. This is uncharted water for me. Reading many examples via google, but still …

---

## [mysql database ](https://www.phphelp.com/t/mysql-database/16646)

<div class="topic-metadata">

**Author:** [@suchait](https://www.phphelp.com/u/suchait)\
**Replies:** 2\
**Last updated:** [April 21, 2012, 5:04pm UTC](https://www.phphelp.com/t/mysql-database/16646 "2012-04-21T17:04:32Z")

</div>

I m working on private messaging in website but now i m facing logic errors in this code so check this code and plz help me… "pm and “userinformaton2” are the tables in mysql database here is the code: \<?php includ…

---

## [How do I paginate results from sql database](https://www.phphelp.com/t/how-do-i-paginate-results-from-sql-database/16710)

<div class="topic-metadata">

**Author:** [@bruceholt](https://www.phphelp.com/u/bruceholt)\
**Replies:** 0\
**Last updated:** [April 20, 2012, 3:34am UTC](https://www.phphelp.com/t/how-do-i-paginate-results-from-sql-database/16710 "2012-04-20T03:34:51Z")

</div>

Hoping someone can help me. I am trying to limit the number of results from a sql database and I assume that I should use pagination. How do I do this with the following code? Thanks in advance. \<?php if ($\_GET\[search\] …

---

## [Problem with db2 pecl](https://www.phphelp.com/t/problem-with-db2-pecl/16666)

<div class="topic-metadata">

**Author:** [@system](https://www.phphelp.com/u/system)\
**Replies:** 1\
**Last updated:** [April 18, 2012, 6:01pm UTC](https://www.phphelp.com/t/problem-with-db2-pecl/16666 "2012-04-18T18:01:11Z")

</div>

I executed the following steps: download ibm\_db2-1.9.3.tgz for use db2 by php (I have just installed DB2 Express C) tar xzvf ibm\_db2-1.9.3.tgz $phpize $./configure --with-IBM\_DB2=/opt/ibm/db2/V9.7 $make $make test …

---

## [e-mailing exported sql tables in excel file format](https://www.phphelp.com/t/e-mailing-exported-sql-tables-in-excel-file-format/16545)

<div class="topic-metadata">

**Author:** [@agon024](https://www.phphelp.com/u/agon024)\
**Replies:** 31\
**Last updated:** [April 17, 2012, 10:33pm UTC](https://www.phphelp.com/t/e-mailing-exported-sql-tables-in-excel-file-format/16545 "2012-04-17T22:33:24Z")

</div>

what I am trying to do is use this php script to load the data being submitted in the html form into my database and then populate the database into an excel (xls) file and then e-mail it to my address. Everything works…

---

## [PHP/mySQL based technical evaluation question webform/database](https://www.phphelp.com/t/php-mysql-based-technical-evaluation-question-webform-database/16196)

<div class="topic-metadata">

**Author:** [@rayray519](https://www.phphelp.com/u/rayray519)\
**Replies:** 9\
**Last updated:** [April 9, 2012, 5:55pm UTC](https://www.phphelp.com/t/php-mysql-based-technical-evaluation-question-webform-database/16196 "2012-04-09T17:55:09Z")

</div>

Hello, I am somewhat new to PHP and I am looking to create a technical evaluation web site & database. Set of questions, with a comments box for each question Each question has a specific % or weighting to it Would li…

---

## [Weird mysql\_query reaction](https://www.phphelp.com/t/weird-mysql-query-reaction/16553)

<div class="topic-metadata">

**Author:** [@subless](https://www.phphelp.com/u/subless)\
**Replies:** 1\
**Last updated:** [April 9, 2012, 10:58am UTC](https://www.phphelp.com/t/weird-mysql-query-reaction/16553 "2012-04-09T10:58:11Z")

</div>

All the small snippet of code below is supposed to do is take your ip address and query the db for any matches. If a match is found, it then checks to see if the match was created the same day. If so it increases the vis…

---

## [MySQL Table creation through PHP not working for me](https://www.phphelp.com/t/mysql-table-creation-through-php-not-working-for-me/16447)

<div class="topic-metadata">

**Author:** [@agon024](https://www.phphelp.com/u/agon024)\
**Replies:** 3\
**Last updated:** [April 7, 2012, 6:56pm UTC](https://www.phphelp.com/t/mysql-table-creation-through-php-not-working-for-me/16447 "2012-04-07T18:56:27Z")

</div>

Not an expert in PHP but here is my code: \[php\] \<?php define('DB\_NAME', 'fundtour\_info'); define('DB\_USER', 'fundtour\_rick'); define('DB\_PASSWORD', 'Fund.Tours'); define('DB\_HOST', 'localhost'); $link = mysql\_connect(…

---

## [sql table erroring out](https://www.phphelp.com/t/sql-table-erroring-out/16454)

<div class="topic-metadata">

**Author:** [@system](https://www.phphelp.com/u/system)\
**Replies:** 5\
**Last updated:** [April 2, 2012, 8:57pm UTC](https://www.phphelp.com/t/sql-table-erroring-out/16454 "2012-04-02T20:57:47Z")

</div>

im trying to display the sql table but i get these warnings please help im sorta on a deadline :o :o :o and how do you tell it to pull from table Warning: mysql\_result(): supplied argument is not a valid MySQL result…

---

## [Help with accessing mdb file: Linux server](https://www.phphelp.com/t/help-with-accessing-mdb-file-linux-server/16273)

<div class="topic-metadata">

**Author:** [@hungrybeagle](https://www.phphelp.com/u/hungrybeagle)\
**Replies:** 5\
**Last updated:** [March 19, 2012, 4:16am UTC](https://www.phphelp.com/t/help-with-accessing-mdb-file-linux-server/16273 "2012-03-19T04:16:09Z")

</div>

I have data stored on our web server running LAMP in a MySQL database. We need to be able to read information from that database (easy) and insert the data into an access .mdb file that can be mailed out to individuals …

---

## [Taking a variable from the login form and using it in another form and store](https://www.phphelp.com/t/taking-a-variable-from-the-login-form-and-using-it-in-another-form-and-store/16044)

<div class="topic-metadata">

**Author:** [@system](https://www.phphelp.com/u/system)\
**Replies:** 5\
**Last updated:** [March 2, 2012, 3:44pm UTC](https://www.phphelp.com/t/taking-a-variable-from-the-login-form-and-using-it-in-another-form-and-store/16044 "2012-03-02T15:44:38Z")

</div>

Taking a variable from the login form and using it in another form and store the same variable in the database table, and retrieve the same values when that person logs in. For example if there are two users - user1 and…

---

## [Complete newbie needs help please :x](https://www.phphelp.com/t/complete-newbie-needs-help-please-x/15883)

<div class="topic-metadata">

**Author:** [@Forfirith](https://www.phphelp.com/u/Forfirith)\
**Replies:** 0\
**Last updated:** [February 12, 2012, 4:09pm UTC](https://www.phphelp.com/t/complete-newbie-needs-help-please-x/15883 "2012-02-12T16:09:42Z")

</div>

Hia guys, Sorry to be bothering you all at phphelp, but since I can’t poke the code to do my bindings sad I thought to ask for help from some pros. So this is my situation: I’ve installed PHCDownloads from PHPCredo (a…

---

## [Getting Column Names from an AS400 Database](https://www.phphelp.com/t/getting-column-names-from-an-as400-database/15679)

<div class="topic-metadata">

**Author:** [@chersull\_99](https://www.phphelp.com/u/chersull_99)\
**Replies:** 0\
**Last updated:** [January 26, 2012, 3:32pm UTC](https://www.phphelp.com/t/getting-column-names-from-an-as400-database/15679 "2012-01-26T15:32:58Z")

</div>

Does anybody know why the following code: \[php\] //---------------------------------------------------- $q = sprintf(“SELECT \* FROM DB#LIBNAME.TABLENAME”); $conn = new COM (“ADODB.Connection”) or die(“Cannot start AD…

---

## [Search by two tables](https://www.phphelp.com/t/search-by-two-tables/15114)

<div class="topic-metadata">

**Author:** [@bushkid85](https://www.phphelp.com/u/bushkid85)\
**Replies:** 2\
**Last updated:** [January 25, 2012, 4:28pm UTC](https://www.phphelp.com/t/search-by-two-tables/15114 "2012-01-25T16:28:36Z")

</div>

Trying to search via two tables, this is what i have and i know the IF is wrong as you cannot do what i thought/hoped. any help? \[php\]\<?php session\_start(); $conn = mysql\_connect(“localhost”, “\*\*\*”, “\*\*\*”); mysql\_se…

---

## [Im new and Need help!!!!!!!!](https://www.phphelp.com/t/im-new-and-need-help/15523)

<div class="topic-metadata">

**Author:** [@mikekandf](https://www.phphelp.com/u/mikekandf)\
**Replies:** 0\
**Last updated:** [January 12, 2012, 12:48pm UTC](https://www.phphelp.com/t/im-new-and-need-help/15523 "2012-01-12T12:48:36Z")

</div>

Im new and trying to learn this stuff. I have an index a login a register but i cant register all it does is go to a blank screen. here is my code… \[code\] \[/code\] \[php\] \<?php if( isset( $\_POST\['user'\] ) && isset(…

---

## [Newbie help needed: Posting to PHP](https://www.phphelp.com/t/newbie-help-needed-posting-to-php/15479)

<div class="topic-metadata">

**Author:** [@markj](https://www.phphelp.com/u/markj)\
**Replies:** 0\
**Last updated:** [January 8, 2012, 7:56pm UTC](https://www.phphelp.com/t/newbie-help-needed-posting-to-php/15479 "2012-01-08T19:56:01Z")

</div>

Hello Thanks in advance for your help. I use coffeecup website search to build my site search engine. It produces a .txt file which hold all the search data and tags, a PHP file to process the search request and an X…

---

## [Email Problem with database!](https://www.phphelp.com/t/email-problem-with-database/15444)

<div class="topic-metadata">

**Author:** [@system](https://www.phphelp.com/u/system)\
**Replies:** 1\
**Last updated:** [January 6, 2012, 1:50pm UTC](https://www.phphelp.com/t/email-problem-with-database/15444 "2012-01-06T13:50:50Z")

</div>

Hello i am trying to make a simple email script but its not working! What i want it to do is Select the emails from a database and use that to send to those people! This is the code \[php\]\<?php $to = ‘Gjossep@gjosse.n…

---

## [UPDATE query not working, can u help?](https://www.phphelp.com/t/update-query-not-working-can-u-help/15063)

<div class="topic-metadata">

**Author:** [@canoman1](https://www.phphelp.com/u/canoman1)\
**Replies:** 4\
**Last updated:** [December 20, 2011, 12:37pm UTC](https://www.phphelp.com/t/update-query-not-working-can-u-help/15063 "2011-12-20T12:37:49Z")

</div>

Can anyone tell me why this fails? Value is passed from a form, and printing all the variabls shows they are correctly passed. if(isset($\_POST\[‘update’\])) (connection to database is here) $house\_number = $\_POST\[‘house…

---

## [Problems getting SQL queries to work in PHP](https://www.phphelp.com/t/problems-getting-sql-queries-to-work-in-php/14108)

<div class="topic-metadata">

**Author:** [@xXshadowXx553](https://www.phphelp.com/u/xXshadowXx553)\
**Replies:** 1\
**Last updated:** [December 20, 2011, 11:17am UTC](https://www.phphelp.com/t/problems-getting-sql-queries-to-work-in-php/14108 "2011-12-20T11:17:13Z")

</div>

Hi there ;D Shame my first post is a about a problem I’m having but then i guess if i wasn’t having it I wouldn’t have searched out the forum… I’m using WAMPSERVER to build just a mini job entry system to enter jobs int…

---

## [Attachment Paths](https://www.phphelp.com/t/attachment-paths/14192)

<div class="topic-metadata">

**Author:** [@MichiganJim](https://www.phphelp.com/u/MichiganJim)\
**Replies:** 3\
**Last updated:** [December 20, 2011, 4:10am UTC](https://www.phphelp.com/t/attachment-paths/14192 "2011-12-20T04:10:25Z")

</div>

I have a browser form in which items can be checked off for receipt by email. They may be images, PDFs or other file types. I seem to have it all in place with one exception. I can’t figure out how to specify the path fo…

---

## [ help with clarifying the   correct way to index data in a database](https://www.phphelp.com/t/help-with-clarifying-the-correct-way-to-index-data-in-a-database/15110)

<div class="topic-metadata">

**Author:** [@andreea115](https://www.phphelp.com/u/andreea115)\
**Replies:** 1\
**Last updated:** [November 25, 2011, 1:39pm UTC](https://www.phphelp.com/t/help-with-clarifying-the-correct-way-to-index-data-in-a-database/15110 "2011-11-25T13:39:16Z")

</div>

Hello everyone, sorry to bother everyone , but i am still new to databases and indexing and i am trying to build my first CMS system. i am building a database system in which members will be able to communiate with eac…

---

## [Tables - add job](https://www.phphelp.com/t/tables-add-job/15096)

<div class="topic-metadata">

**Author:** [@bushkid85](https://www.phphelp.com/u/bushkid85)\
**Replies:** 1\
**Last updated:** [November 24, 2011, 11:16am UTC](https://www.phphelp.com/t/tables-add-job/15096 "2011-11-24T11:16:52Z")

</div>

I have created a simple form for adding a job. Job id, Job\_notes, task\_name, job\_cost etc… I have set up the table with Job id (pri key) the the rest follow in seperate columns. How do I set up a search query so if som…

---

## [Can't get two open connections to work :S](https://www.phphelp.com/t/cant-get-two-open-connections-to-work-s/15033)

<div class="topic-metadata">

**Author:** [@Mavrik347](https://www.phphelp.com/u/Mavrik347)\
**Replies:** 5\
**Last updated:** [November 17, 2011, 9:07pm UTC](https://www.phphelp.com/t/cant-get-two-open-connections-to-work-s/15033 "2011-11-17T21:07:06Z")

</div>

Hello guys, I hope you can help. I can’t get my page to switch between two database connections properly :frowning: It seems to ignore the second connection. I’m trying to go through each group in database one and fin…

---

## [Server Help](https://www.phphelp.com/t/server-help/13157)

<div class="topic-metadata">

**Author:** [@snowfox](https://www.phphelp.com/u/snowfox)\
**Replies:** 4\
**Last updated:** [November 7, 2011, 8:53am UTC](https://www.phphelp.com/t/server-help/13157 "2011-11-07T08:53:47Z")

</div>

I have created a website in windows that uses mysql and PHP. I need to put this website on a USB stick. My problem is that I can not find a server that is cross platform. I need the database to be read by a Mac, Linux…

---

## [hey help with a register page and access database ](https://www.phphelp.com/t/hey-help-with-a-register-page-and-access-database/14793)

<div class="topic-metadata">

**Author:** [@stokie-rich](https://www.phphelp.com/u/stokie-rich)\
**Replies:** 0\
**Last updated:** [October 21, 2011, 7:09am UTC](https://www.phphelp.com/t/hey-help-with-a-register-page-and-access-database/14793 "2011-10-21T07:09:07Z")

</div>

hey guys can I ask a massive favour and for you to help me with this PHP code. I’m designing a website at the moment for a Uni project, at the minute I’m stuck with the register page, users have to register before they …

---

## [Generating a random image with php/sql ](https://www.phphelp.com/t/generating-a-random-image-with-php-sql/14701)

<div class="topic-metadata">

**Author:** [@kej](https://www.phphelp.com/u/kej)\
**Replies:** 1\
**Last updated:** [October 9, 2011, 7:42pm UTC](https://www.phphelp.com/t/generating-a-random-image-with-php-sql/14701 "2011-10-09T19:42:16Z")

</div>

Hi im pretty knew to php and more to SQL but i’ve recently started writing my own scripts, the most recent being one to display a random image using data pulled from the data base. \[php\] $dbcon = mysql\_connect (“localh…

---

## [Increment record from old record](https://www.phphelp.com/t/increment-record-from-old-record/12751)

<div class="topic-metadata">

**Author:** [@dixiestudent](https://www.phphelp.com/u/dixiestudent)\
**Replies:** 1\
**Last updated:** [October 5, 2011, 10:47am UTC](https://www.phphelp.com/t/increment-record-from-old-record/12751 "2011-10-05T10:47:23Z")

</div>

Hi all, im writing some php script to add records to my db. However, if a value thats about to be added already exists, then dont add that record. for example: In my table I have the options for the values of 71,72,73,…

---

## [Need help in inputting to phpmyadmin](https://www.phphelp.com/t/need-help-in-inputting-to-phpmyadmin/12881)

<div class="topic-metadata">

**Author:** [@system](https://www.phphelp.com/u/system)\
**Replies:** 1\
**Last updated:** [September 28, 2011, 9:19pm UTC](https://www.phphelp.com/t/need-help-in-inputting-to-phpmyadmin/12881 "2011-09-28T21:19:05Z")

</div>

Hi I have been trying to get my query to connect to my database. I first had a query to add table to the database and it would show an error then I went over my database info and resent and it updated to the table howeve…

[Previous page](https://www.phphelp.com/c/general-database-oracle-sql-server-etc/7.md?page=2)

[Next page](https://www.phphelp.com/c/general-database-oracle-sql-server-etc/7.md?page=4)