MySQL Database showing on a page.

[jad9321]

Uhh. There is no request.php

Theres only Requests.php

[jr_yeo]

oic

have u tried running the REQUESTS.PHP?

[jad9321]

Yes...

Well i'm just gona do this...


Requests.php:

<?php

$conn = mysql_connect('', '', '');
mysql_select_db('');
$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>');
?>

Than I have my mysql database...

I have this NOWARE:

<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>

I have NO IDEA WHERE THAT IS SUPPOSED TO GO....

[jr_yeo]

I have NO IDEA WHERE THAT IS SUPPOSED TO GO....

this is the output/result/outcome that i got when i ran the requests.php

<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>

thought u might want to compare it with what uve got

if u could just ignore this if this is not the same as what u got when u ran the requests.php, that would be great (for me, at least)

[jad9321]

Ohhhhhhhhhhhhh... No I didnt get that...
I said earlier in this thread I got error:

Warning: Invalid argument supplied for foreach() in /fpgs/fpgshttpd/smileyoureahabbo/scripts/radiobox/requests.php on line 14
del



ok... ok... now were on the same page.......

[jr_yeo]

huh? the script is running smoothly on my end

no errors whatsoever

[jad9321]

Can you tell me EXACCLY WHATS IN YOUR Request.php... Or requests.php... What ever.

I might be like retarded.

:P

[jr_yeo]

Can you tell me EXACCLY WHATS IN YOUR Request.php... Or requests.php

sorry just formatted my hard disk

[jad9321]

Uhh... Ok can you run it again and see if it works... And if it did send itt?

[jr_yeo]

wait....

trying to find a copy of the requests.php