I'm trying to insert the results of a form into a mysql database.
Here's my condensed form:
-------------------------------------------------
<body>
<form method="post" action="script....
I have an artist information update form, that has all previously selected values (i.e. name,gender,style,etc.) echoed in each of the form fields.
The only problem I have is with the dynami...
In MS Access, you can put "Now()" in a date field and it will automatically insert the date and time when you add a record to the db. Is there something similar for MySql? I have a datetime fi...
Hi,
I have this sql_query code on my message board front page:
$amount = mysql_query("SELECT p.*, t.ID FROM posts p, topics t WHERE p.TopicID=t.ID");
$num_rows = mysql_num_rows($amount)...
Hi
How can I do a query from a MySQL database and export to Excel/CSV?
Is there a class or function that can do that?
Thanks.
I'm trying to install a dll so my PHP can work with mySQL.
I think I have a problem with regsvr32 or maybe with my registry. When I try to register a dll it gives me the following message:...
Hi,
I'm inserting records into a mysql database through a form in php. Is it possible to catch an error thrown by the msql database and redisplay the form that is being submitted so the ent...
id like to incorp a popup date picker into a site i have and id like it writen in php i have found java ones here are a few examples
http://www.calendarxp.net/tt_pop.shtml
and
http://...
I run a PHP/MySQL intranet in a school environment. I wish to be able to allow teachers to change pupil passwords through an intranet page. The teachers are standard users, so I need to auth...
I have a very simple backend to a news section of a website. It is written in PHP in Dreamweaver using a MySQL database. It allows the user to add, amend and remove news items. The current fun...
Hi,
I have two simple questions on session arrays. I have created a session array for a shopping cart see below for the code [1].
When a user clicks on a url it adds the data to the session...
Hello,
I am currently using the following MD5 function to store credit card numbers into a database:
---------------------------------------------------------------------------------
fun...
There are several php scripts around to import csv into mysql, but each one I found requires that a table must be already created.
I'm looking for a script (or post me some code to complete...
I have a page in PHP which displays a SQL query output into an HTML table. What I need to accomplish is making the table sort-able by clicking on the headers (i.e. one click sorts acesnding, ...
I just upgraded linux suse 10.2 to 11.0. However when trying to access my joomla pages I am getting
an error:
Database Error: Unable to connect to the database:The MySQL adapter "mysql" ...
hi expert am using this code below to select the last row from my database:
$sql=mysql_query("SELECT * FROM client WHERE cus_id='".$_COOKIE["client_id"]."' ORDER id DESC LIMIT 1");
if(...
Hi folks I have the values from a .csv file being inserted into a mysql DB.
the csv looks like this:
04/29/2004,Ali,Islah,Alameda City,Quality Standards
04/29/2004,Dave,James,Alameda Ci...
hi all, i have a problem. when i run this page, all the output can be displayed correctly. but there will be a long list of undefined offset errors. i've read about undefined offsets, but i do...
Hi,
I have previously received an answer for looping through session variables to enter values into my MySQL table.
$_SESSION['username']
$_SESSION['password']
$_SESSION['applicant_name'...
Hi, I've been trying to set up a form using checkboxes to update multiple values into a field database (MYSQL) using php. Can multiple values be inserted into a single field name within a tab...
Hi all
I've turned on error notices and I'm getting one consistent problem throughout all my classes ...it doesn't like lines 17 and 18 where i use "$this" ...can anyone suggest what the pr...
My Error MSG is "Fatal error: Call to undefined function: mssql_connect() in D:\wwwroot\EMPLOYEE\Telephone\index.php on line 52
PHP Warning: Unknown(): Unable to load dynamic library 'C:\PHP\...
I am trying to insert multiple records from a form on a previous page with all values posted as arrays.
Example:
2 pages (modifyrecords.php / update.php)
- I have the form submitted wit...
Help,
I have a querystring, but have no idea of how to use it with MySQL. This is the error I get:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource i...
Hi,
Is it possible to clear table data from a MySQL database by clicking on a link? For example, lets say I have a table called:
TABLE_ONE
with the following fields:
field1
field2...
