PHP-MySQL listing sqldata in table

[php]<?php
require_once(‘auth.php’);
require_once(‘config.php’);
if ($_SESSION[‘SESS_FIRST_NAME’]!=***********’){
header( ‘Location: http://*************/index.php’ ) ;;
}
//Connect to mysql server
$link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);

  if (!$link){
  die('Failed to connect to server: ' . mysql_error());

}

mysql_select_db(“credit”, $link);
$uur= getDate(DATE_FORMAT_ISO_BASIC);
?>

Member Index

Admin Reload <?php echo $_SESSION['SESS_FIRST_NAME'];?>

My Profile | Logout

Search

search for: code GSM reseller

Reload

GSM : Herlaadcode : <?php if(isset($_POST['submit'])) { mysql_query("UPDATE Reloadcodes SET GSM = $GSM WHERE code = $Herlaadcode"); mysql_query("UPDATE Reloadcodes SET Uur = $uur WHERE code = $Herlaadcode"); } ?>

table listing here
select * from reloadcodes
table structure here

[/php]

when adding the code, my page turns blank,
is there someone who can help me adding a working piece of php code who list the $result
db=Reloadcodes
field1=id
field2=code
field3=reseller
field4=Uur
field5=GSM

i would like a list of all records with some values in GSM, like
[php]$sql=“SELECT * FROM Reloadcodes WHERE GSM<>’’”; [/php]

Sponsor our Newsletter | Privacy Policy | Terms of Service