Home
My Faqts
Contributors
About
Help
News: Faqts.com
search
is now functional again. Thank you for your patience.
Faqts
:
Business
:
Programming
:
Shopping For You
:
PHP
:
Database Backed Sites
: MySQL
+ Search
Enter your search terms
Submit search form
Web
faqts.com
Folders
Questions in search of an Answer
(45)
Links
MySQL: download: mysql
Tutorials
PHP: tutorial: database: MySQL: About
PHP: tutorial: database: MySQL: WebMonkey
Documentation
PHP Manual : MySQL
MySQL Manual
Share Your Knowledge
Ask a Question
Questions
Recently Asked Questions
Call to undefined function: mysql_pconnect(), but MySQL is enabled
I cannot connect to MySql when I use a password why! It is the right password too!
Fatal error: Call to undefined function: mysql_pconnect()
I am eager to know the difference between the mysql_pconnect and mysql_connect please with example.
How do I calculate a person's exact current age by his birthdate from mysql (type date)
Random Questions
Why do my quieries work for mySQL-NT but not for mySQL on Linux?
I've got MySQL connected, what do I do next?
Why can't PHP find my mysql.sock file?
How do I select the entries which where inserted during the last 28 days from a table which has a datetime field?
How can I restrict an INSERT if the two fields to be inserted exist?
Which one is faster, mysql_fetch_row or mysql_fetch_array?
Do I have to lock the table when using mysql_insert_id()?
Can I change the default socket that PHP uses for MySQL?
I've got MySQL connected, what do I do next?
Does PHP automatically free MySQL results when the script ends?
How can I return a limited number of the rows found?
How do I use LIKE in a query?
What sort of array does mysql_fetch_array return?
Why does each() return every column twice after a query?
How can I import a flat file into MySQL?
How can I store images in a database?
What does mysql_query return if the select returns no (0) rows?
When does mysql_query return false?
How can I export the results of a MySQL query into a text file?
Why does my continuously running MySQL script eat up memory?
How can I free the memory allocated for results by MySQL?
How can I create a column in MySQL that auto increments?
How can I insert data into MySQL with an automatic unique ID?
Can I rely on mysql_insert_id when using persistent database connections?
Does MySQL support subselects?
Can I do a subquery in a MySQL query?
Why won't AUTO_INCREMENT increment past 10?
What's the easiest way to move MySQL data between servers?
How can I move my MySQL tables and data up to my web host?
Can I connect to MySQL when running in a chroot environment?
How can I make columns in MySQL case sensitive?
What's the fastest way to return the number of rows in a table?
I can't convert TEXT in MySQL after retrieve to String in php3. String parse error occurs. How?
How can I select all rows that have a date column more than one week old?
Why can't PHP find my mysql.sock file?
How can I do a union in MySQL?
What does MySQL Connection Failed: Protocol mismatch mean?
I have php-postgresql installed, how do I configure for mysql in redhat 6.1?
How can I build a Yahoo-like link directory using PHP and MySQL?
After connecting to MySQL using PHP, only MYSQL_QUERY() works. If I try to use MySQL_num_rows, I get a parse error. What am I doing wrong?
What does the error 'Warning: 1 is not a valid MySQL-Link resource' mean?
How can I backup a MySQL database through PHP only?
What causes the error 'MySQL Connection Failed: Too many connections' ?
Can I have two IDs link to one record in a joining table?
Running Apache 1.3.6, MySQL 3.22.30, and PHP 3.0.12 on Linux, I get this error: "Call to unsupported or undefined function mysql_connect()". Why?
How do I select the entries which where inserted during the last 28 days from a table which has a datetime field?
How do I store the current date in a MySQL datetime field?
How do I create a table in MySQL from within a php script?
When do I need to use lock tables?
How would I create the syntext for a query like; select foobar like '%brown,charly%' ..If someone searchs "charly brown" how can I find it?
How do I write a query like this? I don't see a question mark starting the string. -> http://www.faqts.com/index.phtml/fid/13/lang/en
How can I restrict an INSERT if the two fields to be inserted exist?
I don't want to keep the password to my database on a php or any other file in my server. Is there any way I can connect to my db without doing it?
Why do my quieries work for mySQL-NT but not for mySQL on Linux?
Please tell me how to create a multi- discussion board using php3 and mysql?
how to integrate MySQL, PHP4 and Xitami for Win32 platform?
How can I keep text formatted after it has been inserted into the DB?
How can I create a table into a MySql database thru PHP?
Looping through an array to populate a table from a database, I wish to test the values and change the color of the tag accordingly....
I wish to test the values and change the colour of a <td> tag accordingly while looping through and designing a table from MySQL
Does anyone know of a good PHP/MySQL Group Calendar solution?
After getting:..undefined function mysql_connect(), i learned i needed php_mysql.so modules etc. How add this without reinstall apache and so on.
I can't upload to my database via php. My script appears to go thought alright, and I can echo the variables, but when I check the db, the info is not there. I can, however, get data from the db. I'm using root, so my permissions are ok.
How can I use images with a MySQL database?
What's different between mysql_db_query and mysql_query? And what's better?
How do I connect to MySQL database running on RedHat Linux from a Windows 95' Workstation using ODBC?
How do I use PHP to display rows from a MySQL database in multiples of 50 (1-50, 51-100, etc)? Thanks.
How can I get the column (field) name from a database query result row in MySQL?
How can I create a search for a MySQL database that will search ALL the words contained in the database?
How do I store a count on a thumbs up and thumbs down rating for a site?
How do I list 500 results in muliples of 10 without having to search the database for each result set(1-10,11-21, etc)?
How do get the number of columns in a MySQL query?
How do I format a MySQL timestamp into a readable date?
How do I create a link from mysql, but hide the actual directory and page name to prevent bookmarking? The link needs to be different each time.
How do you make a pop-up select menu in a php page that is made up of entries from a table?
why does my sql have \' instead of just ' ?
Can i use array for INSERT query?
what is phtml? in them, query is executed w/o dbname/port etc of MySQL? while in php they are must?
How do I lock and unlock tables using PHP and MySQL?
How to convert Date/Timestamp from a wwwthreads(perl newsboard) mysql database to human readable format?
A search for 'charlie brown' using two fields returns results for 'charlie brown','charlie' and 'brown' but how can I prioritise these results?
Why do I get Warning: 1 is not a MySQL link index in... when trying to execute a query?
How can I (GROUP BY field.date) as week, month, quarter or year?
Cannot connect through socket '/tmp/mysql.sock'
A newbie question: how is it possible to create a database-driven site? I would like a page which shows all the pages in a database, as links.
Insert multiple rows into MySQL
Is there a way to auto delete after a certain amount of time has passed?
How do I display all ENUM values defined in my database on a Pulldown menu?
how can 1 send an email to email address in database
where can I find some big scripts about PHP&MySQL ?
Why mysql_query, when I tries to do a query like "CREATE TABLE ..." or "GRANT ...", works at home (Lynx & mySQL 3.22.26a),not at work (IE5 & 3.22.32)?
mysql_query("CREATE TABLE" works with MySQL3.22.26a, but not with MySQL 3.22.32 . Why?
How do I write a PHP script that would add up numbers in fields that go with certain Names in a mysql table?
I couldn't use mysql_errno in PHP4 with mysql l3.24.14, that return "Undefined function". Why?
How do I loop twice through a result set from a mysql query? I don't seem to be able to use reset() to reset the pointer to the beginning of the set.
Doing a query with COUNT * , then showing only distinct values of the query with the count value attached, like "Yellow (23)", dropdown menu.
How do I extract records from an existing database using user input?
How do I use input from one form to output to another form for processing & display??
How can I compare form input (e.g., email) with existing database entries (existing email)?
How to speed up a like??
How do I display items in many columns and rows from mysql?
How can I generate a html file each day with content from MySQL, fully automated?
Is it possible to create a PHP script to backup a mySQL database?
I am not able to connect to MySql database from PHP.When I used mysql functions it is giving an error function not defind. Please help quickly
How can display multiple random database rows formatted as URL,IMG,ALT TAG?
How can I search a mysql database every 15 min using timestamp to see if there are new enterys
How can I query 2 MySQL databases on 2 different hosts (I have to join 2 tables on 2 different db)?
When fetching rows from multiple tables, how do I address columns with the same name in different tables using $myrow["whatever"]?
and on same point how do you reference something like sum(revenue) within $myrow($whatever)
how do I write a script to delete database entries over x weeks old?
How can I backup database via PHP3 ??
can PHP(Linux) access Mysql (WinNT)
How to convert MS-Access database to MySQL ?. Please give in detail.
How do I get a return that lets me know that a depulicate exists and cannot be inserted in mySQL using PHP?
How does one dump a csv file (on a local drive) into a mySQL web database using php3?
How do you convert MS Access table data to MYSQL table data
Is there a mysql_create_table function in php?
Why use mysql_fetch_object when the object returned is not a member of any class and consequently has no methods?
For a high traffic database site, am I making a mistake to use mysql_connect throughout many function calls, or should it be passed as a parameter?
php-4.0.3pl1, php-mysql, MySQL-3.23.25 on Redhat 7.0 installed using rpm. I keep getting 'Call to undefined function mysql_connect()'. Why?
I try to readout all fieldnames/values of a mysql table and create var's named like the fieldname holding it's value. but error when value = ”@”
How do I search a database for 2 variables in 2 columns (ie: SELECT from names WHERE firstname = $john AND lastname = $smith)?
How can I update a record of MySQL in Browser
How can we determine what MySQL errors mean? ie. error 1046 - what is it and how do you know?
Has anyone else had any problems with getting mysql_insert_id ($result) return a value using mysql 3.23.21 with Win98 and PHP 4?
Where can I find a php script to show mysql db results 20 at a time, with Next and Previous options?
How do you print the number of result from a mysql search?
How do you add User A to table A with ID A, then select table A and use the ID to add the ID of table A to table B all at once?
How can I insert multiple rows into a mysql table (in one go - from a form)?
I've got an array created by a multiple-item select box in a form. Now I want to submit it to a mySQL database using a "SET" fieldtype but not able...
How do I store an array in a MYSQL field
How can I call mysqldump inside my PHP script?
How 2 display tables name inside php. I've tried "show tables" query but not working. Please help.
I build a recordset of names ordered by lastname, I want to display that RECORDSET in blocks of 10. Not a TABLE. Help!
After grouping results by day, how can I print the date only once for all results matching that day?
Running Apache 1.3.6, MySQL 3.22.35, and PHP 4.0.3 on Linux, I get this error: "Call to unsupported or undefined function mysql_connect()". Why? Pls!!
How can I compare two queries that are generated from a MySQL database and specify the differences on the page shown to the page viewer?
Can I get the results of a mysql query listed for a specific column, as an array or comma-delineated list instead of looping over the rows?
I have a MySQL db with a column named "ID". When user enters ID thru form I want to make sure the ID exists and then perform a db query.
How do I get PHP to check a MySQL dbase for a password and username to ensure that users cannot choose identical names and passwords
Why I get this Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'(111) /path/a.php3
Im getting the following error : Warning: MySQL: Unable to save result set in /usr/local/apache/htdocs/index.php on line 29 Any ideas??
How do you print 2 HTML table columns from 1 select statement?
How do I drop a table?
Like to know how to sort data for a column over multiple tables ?
Warning: MySQL Connection Failed: Can't create TCP/IP socket (10106) : I need help with this.
table sorted by the addition of fields ??
Why doesn't this work? "LOAD DATA LOCAL INFILE 'c:\test.txt' INTO TABLE test ...";
How do I "parse" PHP code which is in a MySQL database?
INSERT statements via mysql_query() fail to add records to the database. How to troubleshoot?
How to convert MS-Access database to MySQL database?.
Why does mysql_fetch_array return a Resource instead of an Array?
Where can I find some examples(source codes) with PHP&MySQL ( not some functions , but a big program or a really running web site programes )
Is stored MySQL data Case Sensitive?
How do you delete a row using PHP code in a MySQL Database?
Apc1.3.22/PHP4.0.3/MySQL3.23,problem to get to MySQL interface, did i need PhpMyAdmin or else?
select FROM_UNIXTIME(now(),'%Y') gives me..2000 . this is stupid or am i stupid ?
How do I set a value into a MySQL database that will be displayed by PHP and have it decrement daily
How to add binary-data to a MySQL-blob with a query or something else?
On Win2k using Apache, MySQL, and PHP (all new), why would a query of >30 rows timeout?
How to run SQL Scripts or SQL file on mySQL with the OS Redhat Linux
How do you show all tables in a DB in PHP script?
Since upgrading to PHP4.1.1 queries of the form " mysql_query("Update . . . . ."); are giving error?
mysql_query with INSERT creates TWO new records without apparent reason (like while or so).
Can i send multiple queries in one function call? ie $query = "create table...; insert into..."
How do I insert a null into mysql using a php var? i.e. '$x' where $x could be null or have a value
How to connect to a MySQL db from inside a PHP extension ?
mySQL/PHP search - Is there a faster alternative to the 'like' query?
How do I build Next and Back links on a query return that is limited 1-10, 11-20, etc.?
In MySQL I have a primary key defined as a BIGINT. From a PHP page I pass the primary key of a recor
when my query returns more than 1 record. How do i loop thru it and display all records on page ?...
Why is my first record never showing up?
After I INSERT a record into a MySQL database, how can I get it's index (auto increment)?
Anyone have any ideas for generating a daily statistics page for database records?
How can I store sound clips in mysql (by using there url) and then listen to them on a php page?
How+do+I+calculate+differences+between+two+date%2Fdatetime+columns+in+MySQL%3F
passing varibles doesnt work i.e.web.php?t=3 (select *from tbl where t=$t) it isnt getting it
DB Error unknown error when inserting row into MySQL; Echoed SQL worked in console
How can I output the latest 25 rows from a table ?
How can I output the latest 25 rows in a table?
How do I add up numbers in a colum? IE SUM all the values in the colum.
How can I activate new sign ups sending them an email with a unique URL that expires in 72 hrs?
Does mysql_query return 1 or 0 on success?
search multiple fields within a record, how can i do that. I want to search for a couple of fields
If a query to a database returns records show that page but with no records show another
need script that counts entries with specific criteria then using output to decide to echo text
PHP4+MySQL+Apache : mysql_connect(): Client does not support authentication protocol req. by server
How to ./configure MySQLi y get the error wrong version or lib not found ?
solving the problem with message (error 1044: access denied for user: "@localhost' to database)?
how can i show retrieve data in diff. pages showing only by ten every pages user click next
How do I calculate a person's exact current age by his birthdate from mysql (type date)
How do I calculate a person's exact current age by his birthdate from mysql (type date)
How do I calculate a person's exact current age by his birthdate from mysql (type date)
I am eager to know the difference between the mysql_pconnect and mysql_connect please with example.
Fatal error: Call to undefined function: mysql_pconnect()
I cannot connect to MySql when I use a password why! It is the right password too!
Call to undefined function: mysql_pconnect(), but MySQL is enabled
Unanswered Questions
How to generate a simple calendar: Janyary\n events \n\n February\n events \n\n March\n events \n\n and so on - output to a html-table
Running Apache, Win98, and PHP 4.0 w/MySQL I get this error: "Call to unsupported or undefined function mysql_connect()"....
I compiled php as a DSO module for Apache. Now I get thesymbol mysql_free_result: referenced symbol not found error. What is going on??
What ANSI92 SQL functions are not supported by MySQL?
while connecting, using mysql_connect(), php.exe is shutdown by windows and the function is not carried out.
How can I send the results of a query to the user's computer not the server as 'outfile' does?
What does "Protocol Mismatch. Server version = 10 Client version = 9" in mysql_pconnect function mean?
When performing an INSERT into a table with two UNIQUE columns how do I know which column had a duplicate entry?
Has anyone else had any problems with getting mysql_insert_id ($result) return a value using mysql 3.23.21 with Win98 and PHP 4?
I didn't have a file MySql.so on my system. Please help me to connect to mysql database from PHP. I am using RedhatLinux.
I have a query with a ~ where something = $array[$index]~statement. A loop to display the array values works but not the query loop. Why?
How do I have to use «DROP TABLE» with PHP? When executing e.g. "DROP TABLE table" I receive an error "[...]error in your SQL syntax near 'table'".
What format of database must be choose in AMC Designor to generate a good script of DB Creation ?
I try to readout all fieldnames/values of a mysql table and create var's named like the fieldname holding it's value. but error when value = ”@”
I need some help in setting up a new database on my server, How do I do it?
I can't configure PHP to run a RPM package for Mysql. gives me header not found error
How can read the spanish chars like "ń" or "í" from a mysql DB ?
how can I use mysql database repication with php client (ie reads go to master and slave, writes to master only)
How to test if a record in a table has not been updated for a specified amount of time, and auto send email to owner of the record?
Using LIMIT clause with offset and #rows causes query to fail. LIMIT without offset works fine?
How do I sum and average numerical values from table columns?
Querying multiple databases simultaneously
Cannot connect to remote mysql (at server1) via PHP (at server2), but can do so using mysql command line on server2.
I want a number field to store imperial weights with pound ounce and dram separators e.g. 64-15-8 does MySQL have a command for this?
Trouble integrating MySQL, PHPmyAdmin and Apache. Help??
How can I force MySQL to display zero as the first digit in an integer field. The text data type or zerofill is'nt ideal.
How can I show one by one MySQL-record in a html form, using Navigation buttons to change between records?
How do I send a file in a mySQL DB to a client with the right mimeType and all?
How do i loop though a table getting the values for the fields. I'm using mysql_list_fields
How do I write the php coding to allow for multiple combination searches?
How do I make hot links out of email/website info from a search in php script?
How do you display the following on a search results page: "Showing results 1 thru 5"?
$v=mysql_query("show tables");echo $v; output "Resource id #2", from browser instead of table names?
Drop-down AND keyword search?
Query that searches columns from drop-down menus, AND searches the entire table with a keyword?
limit results
Is it possible to switch charsets on the fly, when the user switches a language on the site?
Is it possible to switch charsets on the fly, when the user switches a language on the site?
How do I access a database on another server (domains on same servers work fine)?
How can I compare a Timestamp(14) against the current time and use < 300 seconds as a filter?
Can someone show me the simplist way of dynamically generating links to records in php/mysql db ?
Update database from 1 form but have numerous fields with same name but diff values?How update?
Move data from one table to another ((table=A, column=user) copied to (table=B, column=member))?
Inserting multiple arrays - I need to insert multiple arrays into MySQL. Example: name[], phone[],
How do you change the PHP configuration to enable MySQL? PHP is already installed without MySQL.
Is there a better way to skip empty fields than 'if($myrow["X"] != -1) echo "<br>X: ".$myrow["X];'
I have a complex (?) MySql query that refuses to work. It returns wrong results from COUNT(*)...
How would I count the number of times someone has clicked on an image link?
Can't insert data from form
I have set MySQL and PHP4 but I cant modify data using PHP4 in the MySQL database only get data out?
A tricky Query!
The next record set is not displayed. Only the first five records of 121 show. Why?
I do not have file rights and cannot use LOAD INFILE, how can I load a CSV file from my C drive?
do i need to setup any usernames/pwds in mysql server to access database from external servers
how php, pws and mysql being intergerated
How do I get a php file to create a series of tables then tell me if each table was created success?
How to access MySQL different databases in different machines using php under redhat 7.1
If I update a my-sql database in a loop, then only one record has changed, how can i slower this pro
I want to fetch data after user selecting a member from a drop down list box using database
I am offering incentives for referrals and new users. How to prevent them cheating?
How do you detect a change in a file's modified time, and automatically update the mysql database?
i want to populate my table dynamically with all of my site's pages, titles, keywords??
What's better, hitting mySql for dynamic content or writing some of that into text includes?
My linefeeds don't show up when printed from a Long Text Field
Problems with "LOCK TABLES". MySQL error 1099, when using UPDATE after LOCK statement
INSERT 2D array into MySQL table
How do I INSERT 2D array into MySQL table
How can I extract metatag keywords from pages serving longtext mysql column info?
Anyone know an easy way to automatically extract metatag keywords from mysql longtext columns
Anyone know an easy way to automatically extract metatag keywords from mysql longtext columns
Warning: Host 'localhost.localdomain' is not allowed to connect to this MySQL server in /usr/local/a
Warning: Host 'localhost.localdomain' is not allowed to connect to this MySQL server in /usr/local/a
How can I make a search engine that searches a MySQL database?
Ýs there a way to be sure of sql statement is written with right syntax before it is sent to mysql
Automatic refresh of web page if new entry is inserted into MYSQL database, is this possible?
How can I copy text from MS Word > form > insert to mysql w/out chars like ' showing as ;#8217 etc
How I get data from two tables using mysql_fetch_objects function?
How I get data from two tables using mysql_fetch_objects function?
How can i find the name of a file uploaded by a user during the filling of a form stored in MYSQL?
howmanay maximum tables created in a single database in mssql 7.0
undefined function mysql_connect running php script from the shell, the same script it's ok from web
How can i merge 2 databases into one in mysql without losing any data
How can I join tables from two different databases?
How can I join tables from two different databases?
How can I join tables from two different databases?
How can I display the date a form was submitted using DATE as the col_type & how is DATE_FORMAT used
I have a table of users. Can I count how many males and how many females without multiple queries?
Why is mysql_error() not return anything when mysql_query fails?
Query: UPDATE tbl SET col = col+1... is it possible to do the same type of thing with text data?
Want HTML table with multiple row/column elements.What is best table design to make calls efficient?
How can I insert large amount of data into MySQL table quickly (from php running on remote machine)?
How do I pass a MySQL/PHP value to a javascript array ?
How do I pass a MySQL/PHP value to a javascript array ?
How do I read certain enteries from a large flatfile into a MySQl database using php?
Is there a size limit in mysql_fetch_array() ?
What would be the simplest query to select the three most recent records in a table?
What would be the simplest query to select the three most recent records in a table?
I can print all records in a data base but how do I print one record per page.
How di I create a query to show relationship between employees & supervisors in same table(recursive
insert statement inserts BLANK ROWS in the MySQL db
insert statement inserts BLANK ROWS in the MySQL db
insert statement inserts BLANK ROWS in the MySQL db
insert statement inserts BLANK ROWS in the MySQL db
I'm not able to open a local file
how do i delete dublicate data in a mysql database? I have an email database with multiple entries?
I'm have query coming from HTML form. Is there a way to find which table(s) were used in the query?
I'm have query coming from HTML form. Is there a way to find which table(s) were used in the query?
How do I store/retrieve Unicode characters from a MYSQL database ?
How do I store/retrieve Unicode characters from a MYSQL database ?
How do I store/retrieve Unicode characters from a MYSQL database ?
How do I create a user registration (with information and picture) system with login and a user menu
How can I auto skip to next record using Php and My sql so that I can show next record value
How can I insert data into a table that uses a SET field with checkbox forms in PHP
Can I Update a field in a table with a value from another table.
How can I select one row from a returned query in order to retrieve data relevant to that entry?
How can I select one row from a returned query in order to retrieve data relevant to that entry?
I got:undef. func. mysql_connect(), installed php-mysql rpm. Now I get : Warning: Lost connection
How do I define users with my ISP (no grant user table)
Saving form data to multiple tables in two different databases
How do I use values from dropdown boxes to perform query
How do I use values from dropdown boxes to perform query
How do I use values from dropdown boxes to perform query
Lmit results in a SQL query with links to 'next 25 results'
Lmit results in a SQL query with links to 'next 25 results'
I'm passing a string "M&E" for an id in the SQL statement through PHP which do not fetch results
can i put mysql command in javascript ?
database connection
database connection
I have PHP page that calls another to display data how do I display only one row from input text.
How can I SELCT THE NEXT RECORD from a table? (Like next record function in ACCESS)
What is important when handling multiple queries from one PHP page?
im using apache, php 4.3 and mysql on win2k adv server i got error undefined variable $[fieldname],
How can I store sound clips in mysql (by using there url) and then listen to them on a php page?
How do I "sort by click" table headers using PHP?
displaying from one table based on another
I have a PHP variable that is null, and when I try to insert it into a MySQL table, it doesn't inser
Inserting NULL PHP variables into a MySQL table
Why this can't work ? "Select * From table_name Where something='$array[$i]';" ?
How can you display the content of a table in MySQL using PHP script
Should I use BIGINT or INT in an autoincrement field if I have no idea of the final size of a table
Should I use BIGINT or INT in an autoincrement field if I have no idea of the final size of a table
Should I use BIGINT or INT in an autoincrement field if I have no idea of the final size of a table
Should I use BIGINT or INT in an autoincrement field if I have no idea of INSERT's amount in a table
Should I use BIGINT or INT in an autoincrement field if I have no idea of INSERT's amount in a table
how can I insert a row in relation to any table which I choose from my select form?
Does a successful mysql_query return 1 or 0?
Host 'localhost' is not allowed to connect to this MySQL server
I can't echo/print of the value of a variable, from an entry in MySql.
How do I change this into a link? <?php echo $row_rsLocations ['CODE'] ; ?>
How can I get Apache to parse my PHP file in database where site uses index.php?pid= structure
Trouble PHP/MySQL on Windows - After * accesses PHP cannot connect to MySQL
Using PHP/MYSQL under Windows. Why do I get mysql_connect fail after * accesses?
Using PHP/MYSQL under Windows. Why do I get mysql_connect fail after * accesses?
Using PHP/MYSQL under Windows. Why do I get mysql_connect fail after * accesses?
After starting from a random row in a selected record set, how do you limit # of records shown?
Merge records from different the same table (prod1,prod2,prod3)
Merge records from different the same table (prod1,prod2,prod3)
Merge records from different the same table (prod1,prod2,prod3)
Merge records from different the same table (prod1,prod2,prod3)
Merge records from different the same table (prod1,prod2,prod3)
How get rid of the integer and just display a max of two digits after the decimal point
Can I execute php-code stored in an mysql-database? And if I can, how?
uploading files > 1MB via http post and save in MySQL; how can i split files and save these combined
uploading files > 1MB via http post and save in MySQL; how can i split files and save these combined
mysql_fetch_row($result) problem
Using REGEXP in a SELCT-query, the $result will always be TRUE, even when nothing is found. Help!
How do i query more than one table IF i wont be knowing what each table name is...?
I would like to know the exact steps on how to compile PHP to use MySQL shared libraries. Thanks
How can I use PHP to email someone the moment an entry in made in MySql?
Where can I find info on the # of email existing users, # of emails sent/day & increase email use?
How to make a simple form from a query, and change info on several records, and update all changed.
I call mysql_list_fields and get an empty result? Why?
I have APACHE2 + MYSQL4.1.0+PHP5.0.0 Beta1.mySQL_Connect for Mysql in PHTML is disable.Help me !!!
How do I cross reference two arrays?
How do I cross reference two arrays that have been drawn from 2 different database tables?
My php codes (apache, redhat linux) perform nothing when using mysql functions, no error message...
Why primary key (null not allowed) field still accepts null/zero len string (using php+mysql)
Is it possible for me to query a text file whose data is organized into tabbed tables?
I am adding a new harddrive. How do I redirect the server to point to this new drive/directory?
'WHERE'
How do i pass a variable i.e.pg.php?t=s into a mysql query(select*from table where t=$t)
How do i pass a variable i.e.pg.php?t=s into a mysql query(select*from table where t=$t)
How do i pass a variable i.e.pg.php?t=s into a mysql query(select*from table where t=$t)
passing varibles doesnt work i.e.web.php?t=3 (select *from tbl where t=$t) it isnt getting it
(\'$var1\', \'$var2\')' just get aded as $var1 and $var2, not the defined variable
(\'$var1\', \'$var2\')' just get aded as $var1 and $var2, not the defined variable
(\'$var1\', \'$var2\') just get added as $var1 and $var2, not the defined variable
(\'$var1\', \'$var2\') just get added as $var1 and $var2, not the defined variable
(\'$var1\', \'$var2\') just get added as $var1 and $var2, not the defined variable
How do I display my query results in a nice bordered table with table headers?
What is a good PHP program for executing SQL queries to MySQL and then displaying the results?
I need help figuring out how to use a value passed from a form in a select statement.
I can connect to Mysql with php, but mysql_query won't work. They do work on the command line though
Is there any way to have a web page (PHP) that draws data from a database (MySQL) then populates a M
How do I use the variables from an HTML form "get" in php? I cannot seem to get$HTTP_GET_VARStowork
Call to undefined function mysql_connect(),Doesn't php4+ have mysql implemented on it?using windows.
How do I make a query to a database and filter the results using 2 search fields.
php.ini can't find the module directory when they are in the same folder.
php.ini can't find the module directory when they are in the same folder.
php.ini can't find the module directory when they are in the same folder.
how to insert more than one item with INSERT INTO
How can I use transactions in a php script? (php 4.3, MySQL 4.0)
how can I display database results from newest to oldest, & create a new page w/ every ten results?
How I Can upload a folder contents (pictures) into MySQL Database?
I need to export my site ( php + Mysql) on CD which work on Windows AND MAC , do you know a tool?
Why is my .sql file empty after I mysqldump my database?
Why is my .sql file empty after I mysqldump my database?
Why is my .sql file empty after I mysqldump my database?
Why is my .sql file empty after I mysqldump my database?
Why is my .sql file empty after I mysqldump my database?
Is there a limit to how long the hostname string can be in mysql_connect? Is there a workaround?
How do I debug "MySQL server has gone away" - There are many limits, how do you know which you hit?
How do I debug "MySQL server has gone away" - There are many limits, how do you know which you hit?
How do I debug "MySQL server has gone away" - There are many limits, how do you know which you hit?
How do I debug "MySQL server has gone away" - There are many limits, how do you know which you hit?
Notice: Undefined index: Type in C:\Apache2\htdocs\phpMyAdmin\tbl_properties_table_info.php on line
how do i find out the host name of my sql
How do I configure MySQL to work with PHP for Win 98SE?
How can connect to mysql from one PHP script and use this connection in another script
Can strings that contain text fromatting (i.e. line breaks) be printed properly from a MySQL query?
Can strings that contain text fromatting (i.e. line breaks) be printed properly from a MySQL query?
Client does not support authetication requested by server
I cant' get php 5 and mysql 4.0.21 to work together. (each works fine alone)
How can i insert an Auto id from a parent table into multiple child tables using web forms(php)?
Parse error, unexpected $ in line 79, there is no such line, where should I look for the error
Why cant I connect to tables within my database since I have no problem connecting to the database?
How to get the last 15 records from a MySQL table in the right order
How to get the last 15 records from a MySQL table in the right order
How to get the last 15 records from a MySQL table in the right order
Everytime i try to connect to my mysql database using PHP will not connect. At all
PHP and MySQL: Parse Error on connection attempt
Is this MySQL right?
Is this correct? SELECT cid,Name FROM InstaCounter_Counter WHERE titles.softwaretitle = Instacounte
installed php5 and mySQL latest. Can not insert data into mySQL. MS Server2003 help configuring?
Trouble with PHP, M
In trying to pass a URL variable to a MySQL db-connected page, it comes up blank.
How can I insert incode string in MySQL 4.1.x?
Is it possible (if so, how) to make results of a search visible to search engines such as Google?
Cant' UPDATE field in MYSQL if it's MENU LIST But Insert is OK
How do I compare existing MySQL results before an update to see what has changed? (in php)
MYSQL4+PHP5+APACHE2+WINXP - doesn't work. "undefined function error" Moved dlls etc...Still nothing
May i know what is the mysql function to get the value of an auto_incremented field value using PHP?
array values(which are taken in functions) to be sent into dropdownlists and save it into database
array values(which are taken in functions) to be sent into dropdownlists and save it into database
how can i link to a pag using a reference value that is store on DB on mysql?
query a field & compare for similarity - duplicate lettes, vowels, entry inside entry etc..
Database table comparision and update
i am getting - Fatal error: Call to undefined function mysql_connect() in Win 2000 Server, IIS4
How can I connect to a (remote) Mysql server that uses ssl, using PHP4?
mysql_connect fails in WinXP, says protocol mismatch. Code works in Win98. How To solve ?
HELP. I can't connect to database. PHP has encountered an Access Violation at 016573CD.
In my database the records are in Greek but when I retrieve them with php are unreadable
How do I take the information from a form, validate it on the same page and then show confirmation?
How do I get php to ignore records if blank, IF (form_field <> '') then run insert, else ignore
Can mysql support be loaded as an extension on php4 / linux or is mysql support an compile-time opti
Is it possible to do a bind on a statement with variable number og arguments i.e. an array of argume
how much row we able to insert in mysql table?
i have a web server in one location and a MYSQL DB in another and i connect to it using PHP
i have a web server in one location and a MYSQL DB in another and i connect to it using PHP
mysql_select_db(): supplied argument is not a valid MySQL-Link resource
How do you march thru a table and perform a operation on each record
I am using PHP4.0 and have just upgraded from MYSQL version 4.0 to MYSQL version 5.0Now when I call
i cant run two queries at once. i want to call a stored procedure and select the result. how to?
displaying eacute
undefine function my connection()
I have a SELECT Statement with two periods.....example:
How to setup PHP5 with MySQL5? OS is Fedora Core 4. Thanks a lot.
(How) Can I take an image contained in a MySQL Blob Field and Insert it into a PDF file w/ PHP?
How do I format the numerical output received from a query? 15digit number I want as a Percentage?
How do I display products stored in a MySQL database in a table on my website?
How do I display products stored in a MySQL database in a table on my website?
How to generate a link in RSS feed ( i.e. wyz.php?page=1) to an article. page is = row# of query res
no mysql_error() after stripcslashes($query)
I want to connect to mysql using php & Tomcat. But I gives "Fatal error: Call to ...mysql_connect()"
--with-mysqli=mysql_config_path/mysql_config. Where I should write that ?
How to change the value of $off in "select ... limit $off" from a hyperlink
Retriving data from a MySQL table in different array than the one offered by mysql_fetch_*?
how to import data from a csv file to mysql database in php4?
Cannot load mysql extension. Please check your PHP configuration. All paths OK,
mysql_fetch_assoc() only returns first row, how do I return all rows as an array?
I HAVE A QUERY THAT ORDER BY PRODUCTS_NAME FIELD THE RESULT DOES NOT SORT THE GREEK LETTERS PROPERLY
Delete rows in table after x time automaticly. Possible?
Does any one know of a solid classified ads script for jobs or employment site- reasonable $ or free
copying mysql tables toexcel using php
How do I move a selection of records from one table to another (identical) table?
I keep having problems connecting to my database, please contact if you can help!
I keep having problems connecting to my database, please contact if you can help!
How do you subtract the total of numbers in a table from the total numbers in another table?
How do you subtract the total of numbers in a table from the total numbers in another table?
how can i convert .mdb to .sql
Call to undefined function mysql_connect() under Apache, but worked fine using php.exe
Are there any Win2003 security settings that could cause a 10x speed slowdown on INSERT statements?
I have extension error "Your version of PHP 5 does not include MySQL support"! How correct it??
I have extension error "Your version of PHP 5 does not include MySQL support"! How correct it??
I have extension error "Your version of PHP 5 does not include MySQL support"! How correct it??
how do i format the results table from an executed sql query?
Slow speed - MySQL in stage "Sending data"
I cannot connect from php5 scripts to mysql5, even though i can connect from admin. installed rpms.
Class 'mysqli" not found
I want to find a php code that takes a simple data stream from mysql and writes a kml file
Can I put a MySQL INSERT in a loop so I can screen scrape lines and put a few columns into a table?
What would cause mysql_query to return NULL in PHP 4?
I need to know how to insert multiple lines to a database from an HTML form that is dynamic
I need to know how to insert multiple lines to a database from an HTML form that is dynamic
How to SELECT records WHERE the field includes a specified string?
Call to undefined function: mysql_pconnect()
how to map two columns which are in two different tables