Loading Only Tables That Contain Text

[hahaitwork]

Okey, my script is working mostly as I want. I need a line that picks top 50, and only choose those who submitted with name, if the name plate is blank.. the score should not come up.

Here is the line I guess you have to change:

 

$result = mysql_query("SELECT name, score FROM high_scores_avoidthecars ORDER BY score DESC ");

 

Things that should work:

 

1. Sort out who got the highest score BUT also who submitted it first (checks highest/lowest id) (The lowest id number is also the one that sumbitted first*)

2. Top 50 scores only

3. Only show scores that have a Name submitted as well.

 

The database contain: id, name, score

id = auto increase

name = the players submitted name

score = how much they scored

 

Extra note:

I have already a thread that is a bit the same, but will keep both open a little then close the other one.

Here is the second thread that will be closed in a few days

[Christian F.]

So... WHERE name != ''?

[hahaitwork]

So... WHERE name != ''?

Mind explaining it a little?

WHERE name !="?

The

!="? 

part

I guess it ain't hard to get what it do.. but I don't see the connection about the ! and the " and ?

[Christian F.]

It works pretty much the same way in all languages. Most importantly, MySQL and PHP are identical in this area (except for NULL values).

The MySQL manual also has all the information you need on this, though may be a bit harder to read.

[hahaitwork]

It works pretty much the same way in all languages. Most importantly, MySQL and PHP are identical in this area (except for NULL values).

The MySQL manual also has all the information you need on this, though may be a bit harder to read.

 

So I tried that "WHERE" thingy.. not 100% where to put it but I thougth and I guessed Behind OR in front of "ORDER by" and got errors hmm..

 

$result = mysql_query("SELECT name, score FROM high_scores_avoidthecars ORDER BY score DESC WHERE name != '' ");

[Christian F.]

The SELECT syntax is defined in the MySQL manual.

[Barand]

http://dev.mysql.com/doc/refman/5.6/en/select.html

[hahaitwork]

Will check those links out

 

Quick update:

managed to get the 1,2,3,4,5, etc working.. http://loff-production.com/highscores/avoid-the-cars.html

1. Name. score

2. name. score

3. name score