Go to Google, type in "mysql manual" and click on the first result.

So you're saying the field 'stl' can be like 1 or 2 or 3 or 4 instead of where is was only like 1 before? Couldn't you group several like statements with OR?


((stl like '$st1') OR (stl like...

similar and the same are two different things. If you know for sure they will be the same then you can link the two tables together.

Give this a try. It will, however assume that the same product...

I used the following book, it covers just everything you need to get started:...

First thing is to determine a common technology that your pc, pda, and phone all share. If they all can display webpages then you have several options. If not, possibly java as its on most cell...

This is more of a PHP question, or whichever language the website is being written in. I'll use PHP.

Assuming you already know how to do your database search and get results displayed, it's...

I'd use Apache, it's easier to work with than IIS in my opinion.

You should be able to export your current database on your local machine as a CVS file, then import that into the other database on the server. I'm sure there's free software out there to handle this.

I think this will work. I'm not positive if TOP is in MySQL.

SELECT TOP 5 *
FROM table
ORDER BY id DESC

(assuming 'id' is the primary key in the table)

It might return an error if the result of the SELECT contained no rows, but I could be wrong. The code looks ok, I'm not sure what the problem could be.

I understand what you said, its how I ended up doing it anyway. I'm just used to thinking more along the lines of OOP (classes). Stupid Java!

Is there a way I could create a variable that belongs to a table much like a static variable belongs to a class? So it "thing=1, person=2" were variables belonging to the table structure (not each...

wouldn't this question be better asked in the phpbb forums on their website?

select votes, rating, votes/sum(votes) as percentage

if that doesn't work, then you may need to do a nested select statement, where the inner one gets the sum() first.

and whats client code?

Visit http://dbspot.com and email the guy that owns it. (Jimmy) The server is mainly for a few of us using DBP, but if you explain to him that you need a server with mysql support temporarily for a...

well if it works on localhost, then the code is fine. There's probably a problem with the server you're trying to connect to. What error do you get?

I believe there's a php command to get a user's IP address. Store that in a variable and compare it to all the values in the database where you have blocked IP's stored.

Something like this in...

Still cheaper than Oracle's.

can you have an IF statement in a SELECT?