So the problem im having is that with the code below I can echo a username and it pulls a customer id just not the right one. It pulls the first one in the table. Any ideas?
<?php $username = $_GET['username']; $infosql = "SELECT * FROM premiersounds_users WHERE username = username"; $inforesult = mysql_query($infosql) or die(mysql_error()); $info = mysql_fetch_array($inforesult); echo $username; echo $info['customer_id']; ?>Your query should probably read something like this:
[php]
$infosql = “SELECT * FROM premiersounds_users WHERE username = ‘$username’”;
[/php]