mysql, php, tables, help, me

zudo

<html><head><LINK REL=stylesheet HREF="style.css" TYPE="text/css"></head></html>
<?php

mysql_connect ("localhost");

mysql_select_db("pokemon");

$query = 'SELECT * '
. ' FROM colorless LIMIT 0, 30';

$result = mysql_query($query);

echo $result;

?>
I need to know how to get the info into tables, and also the result always turns out result id #2 or something like that, what's wrong?

LordShryku

You need to fetch the results. mysql_query just creates a resource for the query. mysql_fetch_array is probably the easiest to use.

zudo

ok this is my new one, but one thing, for some reason it doesn't pick up the type or name

<html><head><LINK REL=stylesheet HREF="style.css" TYPE="text/css"></head></html>
<?php
//Host and then the database
mysql_connect ("localhost");
mysql_select_db("pokemon");

$query = 'SELECT * '
. ' FROM $type where name like "%$name%"';

$result = mysql_query($query);

//Get the number of rows so we know how many times to loop
$num_row = mysql_num_rows($result);

//Start the table
echo '<table width="100%" height="100%" border="1" >';

echo"<tr><th>Name</th> <th>How many</th></tr>";
for ($a = 0; $a < $num_row; $a++) {

//Get the next row
$row = mysql_fetch_array($result);
echo "<tr></tr><td>$row[0]</td> <td>$row[1]</td></tr>";
echo "<br>";

}
//close table
echo "</table>";