Hello, I run a non profitable charitable project and I have just installed a new workflow management system which is open source. I have found that there is a bug but that the developers have long since closed the projec…
---
## [MOVED: Hello from Queens](https://www.phphelp.com/t/moved-hello-from-queens/14327)
This topic has been moved to Greetings. \[iurl\]http://www.phphelp.com/forum/index.php?topic=13629.0\[/iurl\]
---
## [Error in your SQL syntax?](https://www.phphelp.com/t/error-in-your-sql-syntax/14125)
i just want to show that record not existing table {tbl}mailtemp \[php\] select en.id as en\_id, en.title as en\_title, mt.id as mt\_id, mt.subject from {tbl}noticelogs nl, {tbl}expiration\_notice en right JOIN {tbl}mailtem…
---
## [Query works in phpMyAdmin but doesn't when using php code](https://www.phphelp.com/t/query-works-in-phpmyadmin-but-doesnt-when-using-php-code/13875)
Hi all, I’ve been trying to get this sql query to work from php, but i cannot seem to get it to. I am hoping that someone else has experienced this and knows a solution or can point out my mistakes. I have a table in m…
---
## [mySQL database php form](https://www.phphelp.com/t/mysql-database-php-form/13892)
Hello, I am trying to set up an email newsletter for my website. When the user enters their email address it gets saved in my database. Then the user will receive an email to confirm the subscription. The code I have…
---
## [page\_id in database](https://www.phphelp.com/t/page-id-in-database/13644)
Hi all, To make comments appear on different pages of your website (without getting mixed up), you’ll need to add a new column to the database, something like ‘page\_id’. After this you will need to assign each page a un…
---
## [The Mystery of the Vanishing MySQL Results](https://www.phphelp.com/t/the-mystery-of-the-vanishing-mysql-results/13319)
Good evening, I’ve been tearing my hair out over this issue. It must be something simple I’m missing, but, for some reason, I’m not able to track it down, so I thought I would enlist some assistance. I have some code t…
---
## [SQLite -\> MySQL Vise Versa...](https://www.phphelp.com/t/sqlite-mysql-vise-versa/13251)
Ok - I have been racking my brain for about 22.5h trying to figure out how to proceed with the next part of my project… Basically, I have a main MySQL Database which handles the majority of the data, and multiple SQLite…
---
## [odbc\_connect causes scripts to delay terminating, AFTER they are done](https://www.phphelp.com/t/odbc-connect-causes-scripts-to-delay-terminating-after-they-are-done/13165)
Hello, I have searched but cannot find anyone else even asking this question. By calling an ODBC connection to an MS Access database, the PHP server seems to wait several seconds to terminate the script after it has re…
---
## [Question before start( rebuilding add form to a Update form )](https://www.phphelp.com/t/question-before-start-rebuilding-add-form-to-a-update-form/13071)
Hello phpjers Before i start i want to thank everybody who helped me in previos post, or in general al the helpers… Now i finisht my form for adding an image file with some text fields and some dropdown fields… My new…
---
## [Error, query failed: Column Count Does not match value count at row 1](https://www.phphelp.com/t/error-query-failed-column-count-does-not-match-value-count-at-row-1/13067)
Hi. I am querying a table from SQL Server 2005 and seem to be unable to use the data I get back from my query. I have double checked that there is information in the table and am able to query any other table EXCEPT fo…
---
## [Why do I get this error message](https://www.phphelp.com/t/why-do-i-get-this-error-message/12882)
When I test in the browser it shows the error message. insert.php Insert Data Into mySQL Database Name : Lastname : Email : \
**Author:** [@Ruchiwebsolutions](https://www.phphelp.com/u/Ruchiwebsolutions)\
**Replies:** 0\
**Last updated:** [February 7, 2011, 10:19am UTC](https://www.phphelp.com/t/counting-and-summing-previous-instances/12626 "2011-02-07T10:19:39Z")
Hi All. I have a table: CREATE TABLE games ( game\_id INT NOT NULL AUTO\_INCREMENT, date(datetime), home\_team VARCHAR(30), away\_team VARCHAR(30), home\_team\_goals INT, away\_team\_goals INT) with the following data: …
---
## [PHP MSSQL and IIS7](https://www.phphelp.com/t/php-mssql-and-iis7/12432)
Hi, I am working on windows server 2008 iis7 platform. I am trying to connect to ms sql database from php. I have made the required changes to the php.ini file to enable mssql dll. When i do a phpinfo() command through …
---
## [Expiring Domains list](https://www.phphelp.com/t/expiring-domains-list/12351)
Hi I want to fetch all Expiring Domains with relevant record through php. like http://www.dropday.com/ is there any API? Please help me…
---
## [Subtract From and Update mysql database field via php](https://www.phphelp.com/t/subtract-from-and-update-mysql-database-field-via-php/12299)
Hello Peeps, I am trying to do the following receive input via a form From the submitted variables, check the email in the database table and then pick the number field i want to subtract from subtract the value from …
---
## [JOIN questions & many-to-many db relationship](https://www.phphelp.com/t/join-questions-many-to-many-db-relationship/12125)
Hey all, Ive been working with php for a little while now and have just discovered the world of database normilization. whilst i totally understand how to structure my database conforming to 3NF im having trouble getti…
---
## [Querying MySQL database via user input](https://www.phphelp.com/t/querying-mysql-database-via-user-input/12057)
Here’s whats happening, I’m have from where a user selects a service they want via drop down. It is then parsed to the next page via javascript where it tells them what it selects. I want it to then query the database…
---
## [How to output results from MySQL query that gives multiple results?](https://www.phphelp.com/t/how-to-output-results-from-mysql-query-that-gives-multiple-results/12016)
Hi, The title was probably kind of vague. Basically, I have a query that gets all domains assigned to a username from a specific table: \[php\]SELECT domain FROM domains WHERE username = ‘" . $\_SESSION\[“myusername”\] . "’…
---
## [php /mysql connection issue](https://www.phphelp.com/t/php-mysql-connection-issue/11980)
Dear Friend, I am a beginner in php/mysql and trying to connect my database from a php script to add some info. But the script doesn’t deliver the info to mysql, your further assistance will be appreciated. Ercan
---
## [Error in recalling Data from Link SQL statement](https://www.phphelp.com/t/error-in-recalling-data-from-link-sql-statement/11976)
Ok today i have been running into a problem in PHP MySQl. PHP will not query the information out of the linking statement in the query line. Query Line: \[php\]$data = mysql\_query(“SELECT \* FROM bs\_cat,bs\_forums WHERE b…
---
## [Random number/letter total of 6.](https://www.phphelp.com/t/random-number-letter-total-of-6/11876)
I am trying to create a system that will generate random numbers/letter combo. I am working with this tutorial. http://www.talkmaster.net/showthread.php?72-tutorial-Short-URL-Script I would like to set it up where the…
---
## [New server - suddenly argument is not a valid MySQL result ](https://www.phphelp.com/t/new-server-suddenly-argument-is-not-a-valid-mysql-result/11806)
Hi and thanks for even reading this far! My database driven book store works fine on my hosts server. I have just moved it to a new but very similar server and am getting \>\>\[font=Times\]Warning: mysql\_num\_rows(): supplie…
---
## [Need help with a simple hit counter...](https://www.phphelp.com/t/need-help-with-a-simple-hit-counter/11745)
Hi all college student here, coming to you guys for some help because I think my instructor to an early vacation…(Sent him an email 2 weeks ago about this and still no response). The assignment is to make a basic hit co…
---
## [Issue Adding Variable Fields](https://www.phphelp.com/t/issue-adding-variable-fields/11705)
The issue I am having is that I want to be able to add all of the rows that start with “event\_”, here is what I have so far. \[php\] $result = mysql\_query(“SELECT event\_\* FROM students WHERE studentid = ‘$sid’”) or die(m…
---
## [Sorting a database from two colums ... HELP!!!](https://www.phphelp.com/t/sorting-a-database-from-two-colums-help/11695)
Hi, i got a minor problem … trying to sort a few things out. I’m saving a time stamp in my DB, where the hours and minutes are stored in eachh their own row like: Hours in column: timehh Minutes in column: timemm My …
---
## [Code to Edit Flat File Entries](https://www.phphelp.com/t/code-to-edit-flat-file-entries/11624)
Hello everyone, I am currently working on a control panel for some people who know nothing whatsoever about webpage editing to be able to edit the menu I have posted on their website. I use text file includes to display…
---
## [insert data to replace data already there](https://www.phphelp.com/t/insert-data-to-replace-data-already-there/11502)
not quite sure if theres a better way to describe that but im trying to insert data into a field thats set to be default ‘NULL’ (i’ve also tried just having it say “none”) and i’ve gotten this to work in a register setti…
[Previous page](https://www.phphelp.com/c/general-database-oracle-sql-server-etc/7.md?page=3)
[Next page](https://www.phphelp.com/c/general-database-oracle-sql-server-etc/7.md?page=5)