I'm trying to get this line of code to work. I have it working on other sites, but it won't execute in this script. Can anyone help me with the syntax?
Code: Select all
$sql = "SELECT * FROM $clientname";Code: Select all
<?require_once('/home/content/db/inc/global.php');
session_start();
if(!session_is_registered(myusername)){
header("location:index.php");
}
//get username
//$myusername=$_GET['id'];
//connect
db_connect();
//query
$sql="SELECT * FROM `clients` ORDER BY `client` ASC";
$result=mysql_query($sql) or die (mysql_error());
//stick our toe in the water
$totalpull = mysql_num_rows($result) or die (mysql_error());
$i=0;
while($totalpull > $i){
//Loop through client names
$array = mysql_fetch_array($result);
$clientname=($array["client"]);
echo $clientname;
echo "<br/>";
//select other db
//$fluid = "SELECT * FROM $tb2_surfers ORDER BY $tb2_id DESC LIMIT 1";
$sql = "SELECT * FROM $clientname";
$result=mysql_query($sql) or die (mysql_error());
$i++;
}
exit;
?>Code: Select all
$sql = "SELECT * FROM `$clientname` ";
$sql = "SELECT * FROM $clientname ";
$sql = "SELECT * FROM '$clientname' ";
$sql = 'SELECT * FROM $clientname ';
$sql = 'SELECT * FROM "$clientname" ';
$sql = 'SELECT * FROM '$clientname' ';
$sql = 'SELECT * FROM `$clientname` ';
$sql = "SELECT * FROM "$clientname" ";
$sql = "SELECT * FROM ."$clientname." ";
$sql = "SELECT * FROM $clientname";
$sql = ("SELECT 'status' FROM $clientname");