Ok, so it seems it's the server setup. I've tested the same pages on one of our own servers and it's working fine with special characters.

Thanks again to all of you that posted.

Hi guys

Thanks for all the input. My suspicions lie with the hosting company. We've had numerous issues before and the problem was always something that they hadn't setup correctly.

I'm going...

Am I the first person in MySQL's entire life to need this sort of thing? o.O
Surely someone before me has run into this problem. I thought utf8_unicode_ci would do the trick or utf8_general_ci but...

I have a database that needs to hold names of people from all around the world. Some names have special characters in them such as é and ¢

Is there a character set I can use that will accept any...

I solved my problem by using the following:

WHERE ref BETWEEN 1 AND 50

As the title says, I'd like to select a certain number of rows from a table starting from a specified row.

So for example, I have a table with 250 rows and the rows are numbered incrementally...

Hi cgyrob

Thanks for the response. My original statement is actually correct. I was being blonde and didn't change a class variable on my display page which was causing the issues.

As the title suggests, I'm having trouble sorting the results of a union statement. I'm trying to sort the results by date descending and it's coming out ascending.


(SELECT a, b, c, d, e, f,...

Ok, seems I've managed to sort my problem.

Adding "DESC LIMIT 1,1" to the end of my MySQL query selects the second last row in the table.

I did some fiddling with this and it seems that adding...

Hi all

I've been trying to find a way of doing this and have come up dry. Is this possible? If so could someone tell me how to go about this?

Much appreciated
Venom Rush

Thanks davidn. I managed to sort out my problem with a join though. But I'll definitely keep your method in mind the next time I run into something similar. ;)

@ cwarn23
Thanks for the help. Much...

Hmmm, I've tried joining the two tables with a normal join, left join and a right join but they all come back with the error of "Column 'code' in field list is ambiguous"

I think this may be...

Hi cwarn

I've never gone further than doing simple select, update and delete requests but if I understand this correctly JOINS join two tables together, so when I do the while loop for the initial...

EDIT: I just realized I should have posted this in the MySQL section. If a mod can move it there I'd appreciate it. Thanks :)

Hi all

I have two tables. The first one has the details of each...

Hi all

Is it at all possible to do this? I have a number of records that I need to recover.

Any help would be greatly appreciated

Yes I did, and the I spoke with my hosting company and they assure me the user I'm using has full privileges.

Hi there

I posted this problem in the php forum thinking the issue was something I had done wrong with my PHP but is now looking like a MySQL or possibly a technical computer error altogether:
...

Once again nav33n saves the day...thanks ;)

Hi there

I'd like to know if it's possible to combine an update and insert query into one query. What I'd like to do is insert new data into one table and update a colum in another table at the...

Can't give u more rep nav33n. As much as I'd like to it's telling me I can't give you more rep today :|

I'll make a point of doing it tomorrow ;)

*Venom Rush gives nav33n a virtual high five* ;)
Thanks a lot nav33n. Another rep point for you :cool:

I have a standard SELECT query as follows:
SELECT eid, title, content, thumb_image FROM diary ORDER BY eid DESC LIMIT 3
...and a SELECT SUBTRING query as follows:
SELECT SUBSTRING(content, 1, 200)...

Thanks hollystyles. That worked perfectly ;)

Hi guys and gals

Just curious to know if it's possible to select the 3 latest entries in a table. Would be an added bonus to my project.

;)

This one worked perfectly for me. Haven't tried the rest though. Thanks so much for the help.

Hmmm, I was also a bit perplexed by Xsimulator.net's post.

Hi Sulley, thanks for your post. Going to give it a try a little later. ;)

P.S. Love the avatar sulley ;)

Hi there

What I'd like to do is store a paragraph in a column and pull roughly the first 200 characters of the paragraph and display them on a page as a snippet. Is this possible? If so could...

Thanks so much trudge. That info is of GREAT help. ;)

Hi everyone

I'm looking for advice on building up a database. Any sort of general do's and don't s. The one and only thing that I realize is that putting ALL my info into one table is not a good...

Used this for putting the date back into the db so I didn't actually need to pull it out with the zero.

if ($_GET['startDay'] = $row[0]) {
$day = $_GET['startDay'];
if ($day < 10) {
...

Didn't try it out, managed to sort my problem out with some php code.

Thanks for the help ;)

Much appreciated

Is it possible to select day from the DATE field in a db so that it includes a zero in front of it if the day is less than 10?

If so could you post the code please.

Struggling and...

Hi sulley

Thanks for your help. I managed to solve it with the following code with help from ryan_vietnow:

$query = "SELECT heading, day(date), monthname(date), year(date), description FROM...

Hi Sulley

I've tried what you gave me and the only date I get is today's date. Here is my code:

$query = "SELECT heading, date, description FROM event ORDER BY date";
$result =...

No, because I want the month to be shown as a word and not a number which is why I made the date column VARCHAR.

05 June 2007

I was told a little while ago that there might be a way through php...

I've tried that but what happens is it gets sorted by the days eg:

5 June 2007

7 April 2008

29 January 2006

Hi there

I"m building a page that displays events for example:

Event heading
05 June 2007
Event Description

Another Event
19 June 2008