MySQL Database showing on a page.

[jad9321]

<?php
$conn = mysql_connect('localhost', '', '');
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>');
?>Should work if you just change the details.

[Twey]

No, not (ID), just ID.

[jad9321]

Gots an error...

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /fpgs/fpgshttpd/smileyoureahabbo/scripts/radiobox/requests.php on line 12

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

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /fpgs/fpgshttpd/smileyoureahabbo/scripts/radiobox/requests.php on line 30

[Twey]

Usually means there were no results. What's the layout of your table?

[jad9321]

Lol there are no results...

[jad9321]

Not working:

<?php

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

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

[jad9321]

Any one have any idea about the above??? ^^^^^^

[Twey]

You still haven't answered my question.

[jad9321]

What question???

[jr_yeo]

What's the layout of your table?

this question