aquatsr

Thanks!

Oh that looks useful! Hmmm fortunately I don't need to use it, thx tho!(My project is in my sig, u can take a look at it)

What's the best way to backup my database? (I use PHP MyAdmin thru CPanel)

This site helped me out.http://www.php-mysql-tutorial.com/install-...e-php-mysql.php

I don't need to. Each field that enters into the database automatically has the first letter of each string made into an uppercase, so I only need to select uppercase.(and actually, the query works whether a lowercase or uppercase letter is used, at least in my case)

It gives an error:Could not query the database:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'UNIQUE genre FROM songs WHERE genre LIKE 'I%' ORDER BY genre ASC' at line 1(It's the same whether it's I or r or any letter, regardless of case.)

How would I rework this query? SELECT UNIQUE genre FROM songs WHERE genre LIKE 'r%' ORDER BY genre ASC because it doesn't work.(I'm not good at SQL)

Thanks!

Thanks! I'll be sure to try that!

You're right. Thanks for pointing that out.

Hmmm no... it's not that. I don't think the problem has been solved completely .

OK so in my databast driven site I like to give the user a variety of choices in sorting by starting letter and catogory. The problem is that when I say, like "Sort by album starting with letter P I get:Phobia - Breaking BenjaminPhobia - Breaking BenjaminPhobia - Breaking BenjaminPhobia - Breaking BenjaminPhobia - Breaking BenjaminPhobia - Breaking BenjaminPhobia - Breaking BenjaminPhobia - Breaking BenjaminPhobia - Breaking BenjaminPhobia - Breaking BenjaminPhobia - Breaking BenjaminBasically it shows every entry that has that... which is good if I was showing the individual song titles - but I'm not. How can I show that my database has Phobia, but not have it show every entry?

PHP Nuke, maybe? It's pretty popular from my POV.

I don't know exactly how to do what you want but I do know that you can use javascript to achieve your goal.

Interesting! Thanks a lot! That will save a lot of code-writing!

I'll try that, if it really does work it won't be a problem as I don't have any blank entries (yet).thx.

I have a URL, sayhttp://mywebsite.com/thispage.php?page=a&sort=titleand in my php page I have<?php$page = $_GET['page'];$sort = $_GET['sort'];/*and I want to get all entries with titles starting with the letter A sorted by title, for now*/if ($page == 'a' && $sort =='title') {$sql = "SELECT * FROM songs WHERE title LIKE A%";}else if ($page == 'b' && $sort == 'title') {$sql = "SELECT * FROM songs WHERE title LIKE B%";}...else { /*whatever*/}?>Will this code work?

So I have a table called books and I want to select all titles that start with a number (any number), how would I do such a thing?

I see. I was just offering a suggestion

And to add to that, unless it is stated otherwise, all images, text (media in general) is automatically copyrighted by the author when created according to U.S. copyright laws.So when in doubt, ask for permission.

lol. I know what you mean.You can only user the Location: blah blah at the beginning of the document. (Actually you can only send the header once, is what I mean)Check there for more info: http://sk.php.net/manual/en/function.header.php

Thank you. I had forgotten about that (I'm still new to sql queries).

The sites below contain non-copyright photos which you may use freely.www.freestockphotos.com, www.geekphilosopher.com, www.bigfoto.com, www.firstgov.gov, www.sxc.hu/index.phtml.And in general, you can use pictures from Google as long as you ask permission and give credit for the picture where due.

Ditto. As a college student I'm always looking to get something for free.