• PHP Help

  • Display full array of column name or something like that 

<?php 
		$username = $_SESSION['username'];
		$db = new PDO('mysql: host=localhost;dbname=menusp;','***','***');
		$stmt = $db->prepare("SELECT id, shopName, shopType FROM shops WHERE username = :username");
		$stmt->bindValue(':username', $username);
		$stmt->execute();
		$data = $stmt->fetchAll();
		
		?>
		
		<div class="shop-flex">
		<?php
		if($stmt->rowCount() == 0){
			echo "Add your first location to get started";
		}else{
		foreach ($data as $row) { ?>
			<div class="shop-locations">
			<a href="view-shop.php?id=<?php echo $row['id']; ?>&type=<?php echo $row['shopType'][0]; ?>"><?php echo $row['shopName']; ?></a>
			</div>
		<?php
		}		
		}
		?>
		</div>
	</div>

I'm trying to get shopType to show the full name selected from my database but it's only showing my the first letter, without [0] it comes up as array

    Turns out i was targeting the wrong column and the one I was pointing to had the data called array, doh!

      Write a Reply...