DouglasAWh
October 18th, 2007, 06:44 PM
There's a couple things I want to do.
First off, I want to turn URLs into active links, either at the input layer or the export layer...doesn't really matter to me.
Secondly, I want to arrange a MySQL query to look like items like an online business (though this isn't for a business). What I mean, is I'd like to pull an item name and a picture and have a list of the said items displayed appropriately.
Right now, my code looks like:
$fieldsHandle = mysql_list_fields ($dbname, $table);
$numFields = mysql_num_fields ($fieldsHandle);
/* submit the query */
SetType ($query, "string");
$query = "SELECT * from " . $table;
//set resultHandle
$resultHandle = mysql_query( $query, $conn ) or die ("Could not get DB");
/* table headers */
echo "<table border='1'>\n";
echo "<tr bgcolor='red'>\n";
$i = 0;
while ($i < $numFields) {
//set fName
$fName = mysql_field_name($fieldsHandle, $i);
echo "<td><b>$fName</n></td>\n";
$i++;
}
echo "</tr>\n";
/* table rows */
$numRows = mysql_num_rows ($resultHandle);
$i = 0;
while ($i < $numRows) {
echo "<tr>\n";
$j = 0;
while ($j < $numFields) {
$fName = mysql_field_name($fieldsHandle, $j);
$fieldValue = mysql_result ($resultHandle, $i, $fName);
echo "<td>$fieldValue</td>\n";
$j++;
}
echo "</tr>\n";
$i++;
}
echo "</table>\n";
This works just fine, but doesn't give me the option to exclude fields. I'd actually like to exclude several fields and the URL field I think I want to put in the item name field and make the item picture a link. I could potentially move things around with CSS but my CSS (as well as Javascript and PHP) are somewhat weak (I'm learning!). To me, it seems like there is probably a function that will take certain fields and display them in some ordered fashion. I know I can return one field at a time with
$query = "SELECT eid FROM emp";
$result = mysql_query($query);
while($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
echo "EID :{$row['eid']} <br>";
}
The problem with this approach, of course is that the rows will be one after another, which is where a CSS solution might come in. I'm just wondering what people think the best solution to this is.
Thanks!
First off, I want to turn URLs into active links, either at the input layer or the export layer...doesn't really matter to me.
Secondly, I want to arrange a MySQL query to look like items like an online business (though this isn't for a business). What I mean, is I'd like to pull an item name and a picture and have a list of the said items displayed appropriately.
Right now, my code looks like:
$fieldsHandle = mysql_list_fields ($dbname, $table);
$numFields = mysql_num_fields ($fieldsHandle);
/* submit the query */
SetType ($query, "string");
$query = "SELECT * from " . $table;
//set resultHandle
$resultHandle = mysql_query( $query, $conn ) or die ("Could not get DB");
/* table headers */
echo "<table border='1'>\n";
echo "<tr bgcolor='red'>\n";
$i = 0;
while ($i < $numFields) {
//set fName
$fName = mysql_field_name($fieldsHandle, $i);
echo "<td><b>$fName</n></td>\n";
$i++;
}
echo "</tr>\n";
/* table rows */
$numRows = mysql_num_rows ($resultHandle);
$i = 0;
while ($i < $numRows) {
echo "<tr>\n";
$j = 0;
while ($j < $numFields) {
$fName = mysql_field_name($fieldsHandle, $j);
$fieldValue = mysql_result ($resultHandle, $i, $fName);
echo "<td>$fieldValue</td>\n";
$j++;
}
echo "</tr>\n";
$i++;
}
echo "</table>\n";
This works just fine, but doesn't give me the option to exclude fields. I'd actually like to exclude several fields and the URL field I think I want to put in the item name field and make the item picture a link. I could potentially move things around with CSS but my CSS (as well as Javascript and PHP) are somewhat weak (I'm learning!). To me, it seems like there is probably a function that will take certain fields and display them in some ordered fashion. I know I can return one field at a time with
$query = "SELECT eid FROM emp";
$result = mysql_query($query);
while($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
echo "EID :{$row['eid']} <br>";
}
The problem with this approach, of course is that the rows will be one after another, which is where a CSS solution might come in. I'm just wondering what people think the best solution to this is.
Thanks!