PHP - Checking Id's To Create Or Append Tables

I am trying to create seperate tables from this. Maybe a div class will work. I want each cat variable 'catname' to be in seperate tables at the top of each table with the subcats for that cat in 1 or 2 rows under the cat. I want to be able to also choose whether to use 1 or 2 table rows for the subcats under the cat. any ideas? Will appreciate your help.



// Categories
$sql = "SELECT catid, catname AS catname FROM $t_cats WHERE enabled = '1' $sortcatsql";
$rescats = mysql_query($sql) or die(mysql_error());
$catcount = @mysql_num_rows($rescats);

$percol_short = floor($catcount/$dir_cols);
$percol_long = $percol_short+1;
$longcols = $catcount%$dir_cols;

$i = 0;
$j = 0;
$col = 0;
$thiscolcats = 0;

while($rowcat=mysql_fetch_array($rescats))
{
if ($j >= $thiscolcats)
{
$col++;
$thiscolcats = ($col > $longcols) ? $percol_short : $percol_long;
$j = 0;

echo "<td valign=\"top\" width=\"$cell_width%\">";
}

$i++;
$j++;


    $catlink = buildURL("ads", array($xcityid, $rowcat['catid'], $rowcat['catname']));


$adcount = 0+$catadcounts[$rowcat['catid']];

?>

<table border="0" cellspacing="0" cellpadding="0" width="100%" class="dir_cat">
<tr>
<th width="25" valign="top"><img src="images/category.gif" border="0" align="absmiddle"></th>
<th><a href="<?php echo $catlink; ?>"><?php echo $rowcat['catname']; ?></a>
<?php if($show_cat_adcount) { ?><span class="count">(<?php echo $adcount; ?>)</span><?php } ?>
</th>
</tr>

<?php

$sql = "SELECT scat.subcatid, scat.subcatname AS subcatname
FROM $t_subcats scat
WHERE scat.catid = $rowcat[catid]
AND scat.enabled = '1'
$sortsubcatsql";

$ressubcats = mysql_query($sql) or die(mysql_error()."<br>$sql");

$subcatcount = mysql_num_rows($ressubcats);


while ($rowsubcat = mysql_fetch_array($ressubcats))
{

    if ($shortcut_categories && $subcatcount == 1 
            && $rowsubcat['subcatname'] == $rowcat['catname']) {
        continue;
    }

    
$adcount = 0+$subcatadcounts[$rowsubcat['subcatid']];


        $subcat_url = buildURL("ads", array($xcityid, $rowcat['catid'], $rowcat['catname'], 
            $rowsubcat['subcatid'], $rowsubcat['subcatname']));


?>
<tr>
<td>&nbsp;</td>
<td>
<a href="<?php echo $subcat_url; ?>"><?php echo $rowsubcat['subcatname']; ?></a>
<?php if($show_subcat_adcount) { ?><span class="count">(<?php echo $adcount; ?>)</span><?php } ?>
<br>
</td>
</tr>

<?php

}

?>

</table>
<br>

<?php

if($j==$thiscolcats || $i==$catcount) echo "</td>";

}


?>

</tr></table>

Hello, well I guess my question is pretty clear.
How would I be able to read data out of an Excel sheet?

F.E. to allow my users to simply upload an .xls file to help them avoid the coding and such.

Of course, I know how to create the tables etc, the main problem is just getting that data. Also, I am uncertain if uploading an .xls file is a lot harder/totally done differently then images, and if so.. what is the best way to do this?

P.s. I do want all the fancy equations to be included, just normally entered data (which would just follow some sort of a protocol).

Thanks in advance.

i have two tables, employee details table(empno, emp_name , branch) and attendance table(date, Ot, attendence). I want to create a relation between two tables

Hi,   I am a bit of a MYSQL newbie so please bear with me. I have a database created about football/soccer stats. The database at the moment contains the following tables but more maybe added:   Players Clubs Seasons Competitions   I will create php pages for these tables that add, edit and delete records for each. But the problem I can't get my head around is how to add a record that uses data from other tables, for example we would add a...   player -> club-season-competition   Lets say we want create a player called 'Joe Bloggs' and want to add his details, we need somehow for the page to display an option for club, season and competition. Maybe they can be drop down boxes but how does one fill those drop down boxes with records that are already added in the database for each table?   Thanks

Here is function that backup mysql database. It's working fine, but I want to download file instead of creating it.




/* backup the db OR just a table */
function backup_tables($host,$user,$pass,$name,$tables = '*')
{

$link = mysql_connect($host,$user,$pass);
mysql_select_db($name,$link);

//get all of the tables
if($tables == '*')
{
$tables = array();
$result = mysql_query('SHOW TABLES');
while($row = mysql_fetch_row($result))
{
$tables[] = $row[0];
}
}
else
{
$tables = is_array($tables) ? $tables : explode(',',$tables);
}

//cycle through
foreach($tables as $table)
{
$result = mysql_query('SELECT * FROM '.$table);
$num_fields = mysql_num_fields($result);

$return.= 'DROP TABLE '.$table.';';
$row2 = mysql_fetch_row(mysql_query('SHOW CREATE TABLE '.$table));
$return.= "\n\n".$row2[1].";\n\n";

for ($i = 0; $i < $num_fields; $i++) 
{
while($row = mysql_fetch_row($result))
{
$return.= 'INSERT INTO '.$table.' VALUES(';
for($j=0; $j<$num_fields; $j++) 
{
$row[$j] = addslashes($row[$j]);
$row[$j] = str_replace("\n","\\n",$row[$j]);
if (isset($row[$j])) { $return.= '"'.$row[$j].'"' ; } else { $return.= '""'; }
if ($j<($num_fields-1)) { $return.= ','; }
}
$return.= ");\n";
}
}
$return.="\n\n\n";
}

//save file
$date= date("d-M-Y_h-i");
$handle = fopen('Backup-'.$date.'.sql','w+');
fwrite($handle,$return);
fclose($handle);
}


Usage:
Quote

backup_tables('HOST','USER','PASS','TABLE');

But this will create backup file on server.


I also tried to add following code in function (at the end):

echo $return;
header('Content-type: text/plain');
header("Content-Disposition: attachment; filename=\"$filename\"");


How to just download file, without showing it on screen instead of using fwrite/fclose function?