dont ya hate doing others' work?

jxn_sly

If not, I need some help on my very first use of php!

ok, here's how it goes.

I've got this little piece of code that extracts the date, city, & state from a table in mySQL. It shows all the records within the given limit. However, I want them to be sorted by the showDate column so that if I add another showing, it will appear in it's place chronologically, instead of at the end of the list.

mysql_connect("localhost","$DB_user","$DB_password") or die("Not yet connected to mySQL database.");
@mysql_select_db("$DB_name") or die("Unable to select database $DB_name");
$DateQuery = "SELECT date_format(showDate, '%a, %b %D') FROM $DB_table LIMIT $ShowListStart,$ShowListLength" or die('line 11');
$DateResult = mysql_query($DateQuery) or die('second query failed!') or die('line 12');
$sqlquery = "SELECT showState,showCity FROM $DB_table LIMIT $ShowListStart,$ShowListLength" or die('line 13');
$result = mysql_query($sqlquery);
$number = mysql_num_rows($result);
$i = 0;
if ($number < 1) {
print "<CENTER>No Show info right now.</CENTER>";
} else {
while ($number > $i) {
$ShowState = mysql_result($result,$i,"showState");
$ShowCity = mysql_result($result,$i,"showCity");
$ShowDate = mysql_result($DateResult,$i) or die('showdate is not valid!');
print ("$ShowDate @ $ShowCity, $ShowState - <a href=\"main.php?scene=0&show=$i\">More Info</a><br>") or die('line 26');
$i++;
}
}

thanks a lot.

Anon

Change your SQL statement to look like this ...

SELECT showState,showCity FROM $DB_table LIMIT $ShowListStart,$ShowListLength order by showDate

jxn_sly

I actually already tried that, but when I run it...php spits this out:

Warning: Supplied argument is not a valid MySQL result resource in /home/slyink/public_html/caligari/show_list.php on line 15

by the way, line 15 is this one:

$number = mysql_num_rows($result);

Anon

Try putting the ORDER BY before the LIMIT.

Diego

plasko

Whenever you do a mysql_query() or something similar, it can be helpful to include an or die() in there. I notice you are already doing that.

I like to do something like:

$result = mysql_query($sql) or die(mysql_error() . "in Query " . $sql);

That seems to be a little more informative when you have having trouble connecting to the server, or have other query specific problems.

Am I making any sense?

jxn_sly

It works! thanks very much for the help!

I've been having problems getting specific orders down for mySQL...maybe I should get myself a book or find a tutorial (until now, I've basically been bouncing all of my php off the compilier. Trial and error is probably a horrible way to train yourself, but forgive me...it's my first expedition into the vast world that is server-parsed scripting) Anyway, thanks for tip on the die() function; I am glad to know that I can get errors that are a little more helpful and will use them in the future. thanks!