# General Database (Oracle, SQL Server, etc) **URL:** https://www.phphelp.com/c/general-database-oracle-sql-server-etc/7.md?page=2 [Latest](https://www.phphelp.com/latest.md) · [Categories](https://www.phphelp.com/categories.md) **Page:** 3 --- ## [help in msaccess2007 and php](https://www.phphelp.com/t/help-in-msaccess2007-and-php/20916)

**Author:** [@jeet.sinha](https://www.phphelp.com/u/jeet.sinha)\ **Replies:** 1\ **Last updated:** [August 31, 2013, 2:16am UTC](https://www.phphelp.com/t/help-in-msaccess2007-and-php/20916 "2013-08-31T02:16:11Z")

\[php\]\execute($query19); if($rs19){ $itm=explode(’,’,$rs19\[‘item’\]); $qty=… --- ## [mysql\_query not inserting into database](https://www.phphelp.com/t/mysql-query-not-inserting-into-database/20731)

**Author:** [@system](https://www.phphelp.com/u/system)\ **Replies:** 1\ **Last updated:** [July 26, 2013, 10:11pm UTC](https://www.phphelp.com/t/mysql-query-not-inserting-into-database/20731 "2013-07-26T22:11:39Z")

I’m trying to run an SQL statement that inserts client data into a database, however the row is not being inserted into the database. \[php\] \ **Author:** [@system](https://www.phphelp.com/u/system)\ **Replies:** 0\ **Last updated:** [July 9, 2013, 11:34am UTC](https://www.phphelp.com/t/selecting-data-with-multiple-priorities-and-limited-max-entries/20646 "2013-07-09T11:34:28Z") I need to create a PHP script that selects data from MySQL table with multiple priorities? Every MySQL row is an application for several “sports discipline” with sportsman score as the key for rating. Sports columns ho… --- ## [Random image PHP code problem](https://www.phphelp.com/t/random-image-php-code-problem/20505)

**Author:** [@system](https://www.phphelp.com/u/system)\ **Replies:** 1\ **Last updated:** [June 19, 2013, 9:14pm UTC](https://www.phphelp.com/t/random-image-php-code-problem/20505 "2013-06-19T21:14:40Z")

I am attempting to pull a random image from a folder using PHP. I am very new to PHP and understand the basics, but had to look up code to do this. The following code is the simplest of what I found: \

**Author:** [@ramparter](https://www.phphelp.com/u/ramparter)\ **Replies:** 5\ **Last updated:** [May 15, 2013, 2:52pm UTC](https://www.phphelp.com/t/php-and-remote-sybase-database/20237 "2013-05-15T14:52:27Z") Hi. I am trying to read from a remote Sybase db in a php script in my pc. I have the username, password, db name and the ip address and port where the database is located but I have no idea how to connect. --- ## [Inserting data from forms -- So simple?](https://www.phphelp.com/t/inserting-data-from-forms-so-simple/20180)

**Author:** [@oddmango](https://www.phphelp.com/u/oddmango)\ **Replies:** 9\ **Last updated:** [May 2, 2013, 11:23pm UTC](https://www.phphelp.com/t/inserting-data-from-forms-so-simple/20180 "2013-05-02T23:23:20Z")

Hello, I am a hobbist who has been struggling for a week on this code. I am making an rpg where users can create multiple characters per account. This code should allow them to do this through the UCP. Goal: Have users … --- ## [Warning: file\_exists() \[function.file-exists\]: open\_basedir restriction in effec](https://www.phphelp.com/t/warning-file-exists-function-file-exists-open-basedir-restriction-in-effec/20150)

**Author:** [@bkingery3](https://www.phphelp.com/u/bkingery3)\ **Replies:** 1\ **Last updated:** [May 2, 2013, 1:22pm UTC](https://www.phphelp.com/t/warning-file-exists-function-file-exists-open-basedir-restriction-in-effec/20150 "2013-05-02T13:22:24Z")

Warning: file\_exists() \[function.file-exists\]: open\_basedir restriction in effect. File(/usr/local/apache/htdocs/uploader/uploaded\_files/1367098953-back arrow.png) is not within the allowed path(s): (/home/:/usr/lib/php:… --- ## [Create a matrix from a list of values?](https://www.phphelp.com/t/create-a-matrix-from-a-list-of-values/19769)

**Author:** [@shane8514](https://www.phphelp.com/u/shane8514)\ **Replies:** 1\ **Last updated:** [March 6, 2013, 3:50am UTC](https://www.phphelp.com/t/create-a-matrix-from-a-list-of-values/19769 "2013-03-06T03:50:16Z")

Hello, I’m sorry if this seems like a basic question, but I’ve been pulling my hair out trying to figure this out. I’m an infrequent PHPer at best, and that makes even simple stuff difficult I have a list of values fo… --- ## [New form dropdown](https://www.phphelp.com/t/new-form-dropdown/19733)

**Author:** [@Burty](https://www.phphelp.com/u/Burty)\ **Replies:** 1\ **Last updated:** [March 1, 2013, 1:30am UTC](https://www.phphelp.com/t/new-form-dropdown/19733 "2013-03-01T01:30:02Z")

Hi, I’m trying to add a new dropdown to a currently working form. Not being very good with my PHP I’m really struggling! I’d appreciate any advice on how I could get this to work. So, I have a column in my table “addre… --- ## [Php 5 SQL ](https://www.phphelp.com/t/php-5-sql/19559)

**Author:** [@system](https://www.phphelp.com/u/system)\ **Replies:** 0\ **Last updated:** [February 9, 2013, 9:36pm UTC](https://www.phphelp.com/t/php-5-sql/19559 "2013-02-09T21:36:33Z")

Hi, am new to php and I has a query on using php with sql 2008. \ **Author:** [@fzhp1201](https://www.phphelp.com/u/fzhp1201)\ **Replies:** 0\ **Last updated:** [January 30, 2013, 10:01am UTC](https://www.phphelp.com/t/urdu-chartors-inserting-in-sqlserver-2000/19473 "2013-01-30T10:01:28Z") Hi, I am working on urdu software using php and sqlserver at backend, my problem is i am storing some colums in urdu in db, its working fine, and displaying characters back on web page as well, example ظا ھر پیر شھر b… --- ## [Update multiple records in one form](https://www.phphelp.com/t/update-multiple-records-in-one-form/18533)

**Author:** [@cracker](https://www.phphelp.com/u/cracker)\ **Replies:** 13\ **Last updated:** [January 29, 2013, 11:14am UTC](https://www.phphelp.com/t/update-multiple-records-in-one-form/18533 "2013-01-29T11:14:30Z")

I have a table that pulls records from mysql database. I am having trouble trying to make it possible to make changes to the input fields and submit the changes inside the one form. Can this be done? Here is my dynamic … --- ## [Connecting html form to access database](https://www.phphelp.com/t/connecting-html-form-to-access-database/19402)

**Author:** [@pgh06](https://www.phphelp.com/u/pgh06)\ **Replies:** 0\ **Last updated:** [January 21, 2013, 6:51pm UTC](https://www.phphelp.com/t/connecting-html-form-to-access-database/19402 "2013-01-21T18:51:18Z")

I have a session of variables that need to be input into a database. Here are all the fields I want input into a database. \[php\] \ **Author:** [@system](https://www.phphelp.com/u/system)\ **Replies:** 0\ **Last updated:** [December 1, 2012, 12:56am UTC](https://www.phphelp.com/t/this-extension-requires-the-microsoft-sql-server-2012-native-client/19021 "2012-12-01T00:56:19Z") Our web developer is getting the following error when trying to test a connection to SQL using PHP code: Connection could not be established. Array ( \[0\] =\> Array ( \[0\] =\> IMSSP \[SQLSTATE\] =\> IMSSP \[1\] =\> -49 \[code\] =\> … --- ## [Oracle Not Loading With Php5 Under IIS7](https://www.phphelp.com/t/oracle-not-loading-with-php5-under-iis7/18795)

**Author:** [@system](https://www.phphelp.com/u/system)\ **Replies:** 0\ **Last updated:** [October 31, 2012, 2:43pm UTC](https://www.phphelp.com/t/oracle-not-loading-with-php5-under-iis7/18795 "2012-10-31T14:43:33Z")

I have been using PHP5 under IIS on a Windows 2003 Server and everything was fine. I could use both Oracle and MySQL with PHP. Recently, I upgraded another server to Windows 2008 R2. I then followed some instructions … --- ## [Query help: avg on 2 columns for max values](https://www.phphelp.com/t/query-help-avg-on-2-columns-for-max-values/18769)

**Author:** [@pollewops](https://www.phphelp.com/u/pollewops)\ **Replies:** 3\ **Last updated:** [October 29, 2012, 6:13pm UTC](https://www.phphelp.com/t/query-help-avg-on-2-columns-for-max-values/18769 "2012-10-29T18:13:56Z")

Example: I have a table containing 2 columns called AVERAGE and AVERAGENETTO. I want to have an AVG on my AVERAGE column, but in case on a row the AVERAGENETTO is larger then the AVERAGE field, then the AVERAGENETTO sho… --- ## [Unlink problem](https://www.phphelp.com/t/unlink-problem/18614)

**Author:** [@system](https://www.phphelp.com/u/system)\ **Replies:** 1\ **Last updated:** [October 12, 2012, 3:33pm UTC](https://www.phphelp.com/t/unlink-problem/18614 "2012-10-12T15:33:08Z")

I have a image rotate system. but this script needs to delete the picture from folder and database been working on it but i can’t get it to work \[php\]$checkbox = $\_POST\[‘checkbox’\]; $delete = $\_POST\[‘delete’\]; for($i=… --- ## [accessing mysql with php](https://www.phphelp.com/t/accessing-mysql-with-php/17849)

**Author:** [@traydavid](https://www.phphelp.com/u/traydavid)\ **Replies:** 1\ **Last updated:** [September 25, 2012, 1:35pm UTC](https://www.phphelp.com/t/accessing-mysql-with-php/17849 "2012-09-25T13:35:21Z")

I built/tested my site on virtual server WAMP and works fine. Loaded through cpanel to actual server online and now the index.php code (specifically the login code referenced in that page) won’t access the database. An… --- ## [Confirm Request with messagebox before running a delete query?](https://www.phphelp.com/t/confirm-request-with-messagebox-before-running-a-delete-query/18105)

**Author:** [@wilson382](https://www.phphelp.com/u/wilson382)\ **Replies:** 3\ **Last updated:** [August 24, 2012, 5:21pm UTC](https://www.phphelp.com/t/confirm-request-with-messagebox-before-running-a-delete-query/18105 "2012-08-24T17:21:39Z")

Hello PHP Buddies, I used this simple php codes to have a section on my page to delete records. \[php\] \Delete \[/php\] working fine. I want to add an action so that i when i clic… --- ## [MySQL QUERY (group)](https://www.phphelp.com/t/mysql-query-group/17933)

**Author:** [@rhyandiansay](https://www.phphelp.com/u/rhyandiansay)\ **Replies:** 0\ **Last updated:** [August 6, 2012, 11:33am UTC](https://www.phphelp.com/t/mysql-query-group/17933 "2012-08-06T11:33:21Z")

hello, i want to query in my database by group (department). and i want to display in different table each department . output: department one 1 abc 2 def 3 ghi department two 1 abc 2 def 3 ghi … thank you so … --- ## [regarding mysql\_fetch\_assoc() ](https://www.phphelp.com/t/regarding-mysql-fetch-assoc/17731)

**Author:** [@chanu.sl](https://www.phphelp.com/u/chanu.sl)\ **Replies:** 1\ **Last updated:** [July 19, 2012, 10:55am UTC](https://www.phphelp.com/t/regarding-mysql-fetch-assoc/17731 "2012-07-19T10:55:03Z")

I’m new to the PHP and I’m stuck in php code, because of mysql\_fetch\_assoc(). I used php POST method to retrieve data from html form and it works. But when I use that POST variable inside the mysql query it shows a warni… --- ## [shop by price](https://www.phphelp.com/t/shop-by-price/17658)

**Author:** [@system](https://www.phphelp.com/u/system)\ **Replies:** 3\ **Last updated:** [July 15, 2012, 5:23am UTC](https://www.phphelp.com/t/shop-by-price/17658 "2012-07-15T05:23:25Z")

Hello On my website, I would like to have a shop by price, something like the following £0.01 - £2.99 £2.99 - £3.99 £3.99 - 6.99 £6.99 - £9.99 £9.99 or more How would I do that and get the results from the mysql d… --- ## [Sort Variable](https://www.phphelp.com/t/sort-variable/17169)

**Author:** [@unknown101090](https://www.phphelp.com/u/unknown101090)\ **Replies:** 1\ **Last updated:** [July 12, 2012, 3:47pm UTC](https://www.phphelp.com/t/sort-variable/17169 "2012-07-12T15:47:23Z")

if($\_REQUEST\[cmbNegeri\]!=’-’) // all district { $nilai\_sort = array(“Bil” =\> $j ,“negeri” =\>$namaNegeri\[$j\] , “daerah” =\>$namaHint\_daerah\[$j\] , “kodkos” =\>$codeHint\[$j\] , “kos” =\> $nameHint\[$j\] , “a” =\>$A\[$j\]\[$p\] , “b”… --- ## [MySQL database and pingback problems](https://www.phphelp.com/t/mysql-database-and-pingback-problems/17601)

**Author:** [@system](https://www.phphelp.com/u/system)\ **Replies:** 1\ **Last updated:** [July 7, 2012, 2:35pm UTC](https://www.phphelp.com/t/mysql-database-and-pingback-problems/17601 "2012-07-07T14:35:37Z")

Hello I’m trying to set up a pingback service for an online virtual currency (via paymentwall). I’ve attached the example code given by paymentwall with my codes in there to update the users credit balance. I am however… --- ## [Problem concerning a PDO statement in a simple webservice setting](https://www.phphelp.com/t/problem-concerning-a-pdo-statement-in-a-simple-webservice-setting/17502)

**Author:** [@system](https://www.phphelp.com/u/system)\ **Replies:** 0\ **Last updated:** [June 28, 2012, 11:51am UTC](https://www.phphelp.com/t/problem-concerning-a-pdo-statement-in-a-simple-webservice-setting/17502 "2012-06-28T11:51:11Z")