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
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.
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)...
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:...
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://...
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...
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...
Hello,
I am currently using the following MD5 function to store credit card numbers into a database:
---------------------------------------------------------------------------------
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...
I'm using Dreamweaver, PHP & MySQL in a website for my company. I have created an In/Out board for the company but now want to have it where you can click on a radio button and have it update...
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'...
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 am using the following PHP code to select data from a table called resi. Is it possible to also edito this code to search resi and another table called commercial? If so, can someone updat...
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 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, 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...
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...
I would like to know if its possible to decrypt a password in the database, that was encrypted with the password function
I need to insert dynamically populated checkbox values into multiple fields of a mysql database using php. I think I need a "for each" statement, but can't seem to get it right.
Here's the p...
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...
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(...
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" ...
