MySQL Database showing on a page.

[jad9321]

I think its like accross the top...

Habbo Name, Song Request, Shoutout/Joke, ID

[Twey]

Well how about you find out?

[jad9321]

Yeah its....

Habbo Name, Song Request, Shoutout/Joke, ID


(I found out...)

[jad9321]

-sighs-

[jad9321]

hmmmmmmmmmmmmmmmmmmmmmmm...

[jr_yeo]

Joe, have u tried the latest script posted by Twey?

anywayz, i did and it worked on my local web server

<EDIT>

<table border=1><tr><th>0</th><th>ID</th><th>1</th><th>Habbo Name</th><th>2</th><th>Song Request</th><th>3</th><th>ShoutOut/Joke</th><th>del</th></tr><tr>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr></table>

why is there an additional table header before the ID, Habbo Name, Song Request, ShoutOut/Joke? and extra table data after the execution of the request.php

[jad9321]

Ok... I am reallly confused.

This is EXACCLY whats in the requests.php file:

<?php

$conn = mysql_connect('localhost', 'smiletest', 'jjaadd');
mysql_select_db('smiletest');
$tablename = 'request';
$uniquerow = 'ID';
if(isset($_GET['delete']))
  if(!is_numeric($_GET['delete'])) die();
  else mysql_query('delete from `' . $tablename . '` where ' . $uniquerow . '=\'' . $_GET['delete'] . '\';');

$rs = mysql_query('select * from `' . $tablename . '`;');
$row = mysql_fetch_array($rs);
$cols = array();
foreach($row as $k => $v)
  array_push($cols, $k);
array_push($cols, 'del');
echo('<table><tr>');
for($i = 0; $i < count($cols); ++$i)
  echo('<th>' . $cols[$i] . '</th>');
echo('</tr>');
do {
  $row['del'] = '<form action="?delete=' . $row[$uniquerow] . '" method="get"><input type="submit" value="Delete"></form>';
  echo('<tr>');
  for($i = 0; $i < count($cols); ++$i) {
?>
<td><?php echo($row[$i]); ?></td>
<?php
  }
  echo('</tr>');
} while($row = mysql_fetch_array($rs));
echo('</table>');
?>

And what was the thingy you posted?????? Huh?:

<table border=1><tr><th>0</th><th>ID</th><th>1</th><th>Habbo Name</th><th>2</th><th>Song Request</th><th>3</th><th>ShoutOut/Joke</th><th>del</th></tr><tr>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr></table>

Where is that supposed to go? :| God i'm confused...

[jr_yeo]

the output of the request.php if u run the script

Joe, have u tried the latest script posted by Twey?
anywayz, i did and it worked on my local web server

[jad9321]

Omg i am REALLY CONFUSED!

[jr_yeo]

question have u tried running the request.php?