$result = mysql_query... HELP!

Ham

I have this in my code which I got from a tutorial:

$result = mysql_query("SELECT * FROM discs",$db);

However, I DON'T want to list everything in my table but only that information that has the value 'Xbox' in the 'system' column.

I tried using this:

$result = mysql_query("SELECT system FROM discs WHERE column = 'Xbox'");

but it didn't work and only gave me errors.

What is the correct coding to make what I want happen?

jim_keller

'column' was probably just a placeholder for the example you used. Replace it with the name of the column (system) like so:

$result = mysql_query("SELECT system FROM discs WHERE system = 'Xbox'");

-Jim Keller
http://www.centerfuse.net

Ham

Sweet!... it weed out my Xbox games from all my other ones but all it printed was a list that was like:

xbox
xbox
xbox
xbox

Before that edit the list was like:

xbox halo
xbox tony hawk 4
ps2 grand theft auto 3
gamecube animal crossing

how do I get it to print the 'title', 'rating', 'discs', 'loaned' columns again?!

// this part happens if we don't press submit
if (!$discid) {

// print the list if there is not editing
$result = mysql_query("SELECT system FROM discs WHERE system = 'Xbox'");

while ($myrow = mysql_fetch_array($result)) {

printf("<a href=\"%s?discid=%s\">%s %s</a> \n", $PHP_SELF, $myrow["discid"], $myrow["system"], $myrow["title"]);
printf("<a href=\"%s?discid=%s&delete=yes\">(DELETE)</a><br>", $PHP_SELF, $myrow["discid"]);

jim_keller

$result = mysql_query("SELECT discid, system, title, rating, loaned FROM discs WHERE system = 'Xbox'");

Ham

Only the 'system' and 'title' are showing up. 'rating', 'discs', 'loaned' are being left off for some reason.

Also, it is possible to sort them so the results so that only items with system = 'Xbox' are showing (as they are now) but alphabetically by 'title'?

jim_keller

to order them, add an order by statement to the SQL query:

$result = mysql_query("SELECT discid, system, title, rating, loaned FROM discs WHERE system = 'Xbox' ORDER BY title");

You have to print them if you want them to show up. Also, you don't have to use printf, print or echo will suffice, and use substitution that's easier to follow:

echo "<a href=\"{$_SERVER['PHP_SELF']}?discid={$myrow['discid']}\">{$myrow['discid']} {$myrow['system']} {$myrow['title']} {$myrow['rating']} {$myrow['loaned']}</A>";

-Jim Keller
http://www.centerfuse.net

Ham

First off... thank you so very much. I have been at this for two weeks and I feel like the past 3 hours have been a major breakthrough. I have been coding in HTML for 7 years now and was really getting burned out. But now that I have found PHP it is like I am all giddy and excited about programming again!

As far as the printing out of the results, could I put them in a table (HTML) so everything lines up and is easy to read.

Instead of:
Animal Crossing (DELETE)
Biohazard (Import) (DELETE)
Resident Evil (DELETE)

More like this:
Animal Crossing (DELETE)
Biohazard (Import) (DELETE)
Resident Evil (DELETE)

It would also be cool if the table rows could alternate colors but that may be asking for way to much. hahaha

barand

After 7 years coding HTML I'd have thought coding a table would present no problem😉

while ($row = mysql_fetch_array($query)) {
$class=($class=="yellow")?"white":"yellow";
echo "<tr><td class=\"$class\">".$myrow["title"]."</td><td class=\"$class\">(DELETE)</td></tr>";
}

hth

Ham

hahaha... you would think! Acutally my question wasn't on how to code the table in html but if I should just use an echo tag so it would print out the code... blah blah. Anyway, I figured it out last night shortly after I posted that.

Now my site is running great... just how I wanted it!