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 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,
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 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...
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
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.
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'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...
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...
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 have a php page with a standard table dynamically generated. I need to figure out a way to have a button export the page to PDF instead of default printer. Can anyone suggest a product out...
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 Experts, I am looping through a database to display records.
I am gettin the following error; unterminated string literal - not sure how to fix it
The line of code that is generating th...
Which of the following two methods would perform best?
/////////////////////////////////////////////// mysql_query
$query = "SELECT COUNT(`page`) FROM `book` where `text` like '%$term%'";
...
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\...
Hello,
I am currently using the following MD5 function to store credit card numbers into a database:
---------------------------------------------------------------------------------
fun...
This question is intended to be open ended, and references to online or published manuals are very welcome. What are the best practices for MySQL documentation?
In other words, if I crea...
?php
//database specification information
DEFINE (DB_USER, "root");
DEFINE (DB_HOST, "localhost");
DEFINE (DB_NAME, "mqs_test");
//Connect to MySQL:
$db_connection = mysql_connect (DB_...
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 am using PHP and MySQL to insert rows into my database. I have a textbox that I want to use autosuggest with a drop down box. I have the code working fine when I only have one row that I a...
Hi, I've got a mysql field called birthday of type date : It seems to display in the form YYYY-MM-DD. Now I want to extract the year, month and date and store them to seperate variables
//g...
i have a php file that have some ckeckboxes in table, that are 'checked' or 'unchecked' by database value at the time of form load.
now i want 'check' or 'uncheck' the checkboxes and click a ...
How do I get PHP to report back errors like in the following:
<?
// SCRIPT ERROR REPORTING
ini_set('display_errors', '1');
error_reporting (E_ALL); // Report everything
$first_name = ...
Hi expert,
I've got this site that does not results in errors on my test server but does have errors on the production enviorment.
The error I get is:
Parse error: syntax error, unexpe...
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...
