1. Help with mysql query not working in PHP

I have a query that works fine when run directly in phpMyAdmin, but when run from the php template doesnt give any results. The example query below should return this article: "Battle for ...

2. php, mysql 4.1.1 and utf8 problem

Hi all, I am trying to internationalize my website for asian and european countries. I have php 4.3.6 and mysql 4.1.1-alpha on redhat linux. I can display utf8 directly from php webpages, ...

3. Unable to resolve call to undefined function-now Apache cant find php_msql.dll

Seems to be a common beginner issue, but I cant figure it out to save my life. I have read every thread before posting this question. Solutions supplied in other threads are all over the place ...

4. PHP-MySql database examples.

Is there anywhere that I can view examples of using PHP to connect to a MySql table and extract information. I just want my website users to be able to extract from the whole table,census, ...

5. Adding info from file to MYSQL

Hello (: Im having trouble trying to say submitting information on a website, submitting, and then executing it into the mysql database. My example is, I have a country field in my ...

6. Searching MySQL with PHP

I have been playing with this a while now, and tried a few examples on the net with no luck. Can anyone point out where Im going wrong. When I submit I only get a blank page. Am able to ...

7. MYSQL: How best to select a column before looking for a string match?

I have a mysql database containing information about photos. Each row is something like so: Location|Photographer|Subject|Caption How do I most efficiently single out a particular column ...

8. many mysql queries a bad idea?

Im developing something that will be my first experience with php+mysql used in a somewhat high traffic setting. I am looking at my code and thinking it might not hold up with high traffic.  ...

9. mysql_fetch_assoc question with multiple tables

Lets say a multiple table query is ran $info=mysql_fetch_assoc(mysql_query(SELECT blah.deleted,blah2.deleted FROM blah INNER JOIN blah2 ON blah.whocares=blah2.noone)); How would you ...

10. combining OOP and MYSql

I would like to use OOP principals in my php project. However, it seems that as i am developing my modules, its becoming very linear... I want to know how i can use OOP and mysql together. ...

11. Dates, PHP and MYSQL help!

Hi, Ive got two date field in my db, one is startdate other is enddate. example: $start = "2005-07-30"; $end = "2005-08-06"; thats y/m/d what i want ...

12. mysql_fetch_array returns 2x the amount of fields in table

Greetings, I am using mysql_fetch_array() in conjunction with a for loop to write a CSV file with all of a single tables data. My problem is that the function is returning an array with a ...

13. mysql_connect with PHP 5 on IIS causing error (was Help My Please With This Error)

Im using IIS and PHP, both are working correctly, for example if y type PHP Code:  $i = 0;  while ($i<5)   it ...

14. Pulldown from MySQL Question

Hey Everyone, I have this code running but I was wanting to set a predefined "selected" id so as when it printed out the pulldown data from the database, it would be selected. Example, ...

15. Validation using MySQL

I have looked around and cant an answer to my solution, so I turned to you guys for help. I am trying to learn how to validate a user with MySQL database. For example, I have put a username ...

16. Ranking data in MySQL by record count of user-specified field

I read the required posts and searched, yet couldnt find any similar questions close enough to my question, so here goes... Ive been handed the task of writing a survey app in PHP/MySQL ...

17. Populating second Dropdown from Mysql

hi i know that this is probably a redundant post, and i have even scoured all of this site looking fo an example or something here is my code PHP Code: <form name=combo>  ...

18. Analysing a MySQLDump file

Can anyone help with a regular expression to extract the table names and the number of rows in each from the output of a SQL file produced by MySQLDump? Im using this to verify the output from ...

19. Fun with Arrays and MySQL

Alright, its late and Im a bit fuzzy but Ill try to explain my problem. Ive got a table in mysql that contains many testimonies. There are roughly 7 column in this table. Name, Age, Location, ...

20. Filtering Mysql Results

Hello everyone, I am at the moment trying to put together a small php chat script and am trying to put in an ignore feature. At the moment i have a checkbox next to every persons name  ...