[bhimpfen]

I want to fetch domains under a specific user ID in a table, how do I do this?

Here is the MySQL

CREATE TABLE `users` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `login` varchar(15) DEFAULT '0',
  `password` varchar(15) DEFAULT '0',
  `domains` varchar(15) DEFAULT '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; 

So, I want to display the "domains" in the users table for the id. Will be displayed in a table. It wont use login or password in the users table.

Here is an example of what I mean:
http://www.scriptplayground.com/tuto...tch-MySQL-Row/

[Nico]

PHP Code:

// Make sure database connection is established



$query = mysql_query("SELECT domains FROM users WHERE id = XX LIMIT 1") OR die(mysql_error());

$userinfo = mysql_fetch_array($query);



echo $userinfo['domains']; 

[bhimpfen]

doesnt work, i get "Unknown column 'XX' in 'where clause'" eror

[Nico]

You have to replace the XX with the actual ID you want to fetch.

[bhimpfen]

I did it like this, but it shows all of them and not a specific login row

PHP Code:

$query  = "SELECT * FROM `users`";
$result = mysql_query($query);

print "<br /><table width=\"750px;\" cellSpacing=\"1\" cellPadding=\"3\" style=\"border:1px solid #B2B2B2;\"><tr bgcolor=\"#AEB59F\"><td><strong>Domain Name</strong></td><td><strong>Whois E-mail</strong></td><td><strong>Change</strong></td></tr>";

while($row = mysql_fetch_array($result))
{
    echo "<tr bgcolor=\"#C7C7C7\"><td>{$row['domains']}</td><td>{$row['domains']}@whoisprivacy.net</td><td><a href=\"mailto:enquiries@whoisprivacy.net?subject={$row['domains']} Whois Change&body=Provide e-mail or domain change here:\">change</a></td></tr>";
} 
    
mysql_close();

print "</table><br />"; 

[Nico]

Use my code, and replace the XX with the login ID.

[bhimpfen]

if XX is $_SESSION["login"], how would I include it then

[bhimpfen]

still getting

Unknown column 'alpha' in 'where clause'

[php]$user_id = $_SESSION["login"];
$query = mysql_query("SELECT domains FROM users WHERE id = $user_id LIMIT 1") OR die(mysql_error());
$userinfo = mysql_fetch_array($query);

echo $userinfo['domains'];/php]

[Nico]

What does $_SESSION['login'] hold? The row ID or the value from the login field?

If it's the ID, try:

PHP Code:

$query = mysql_query("SELECT domains FROM users WHERE id = " . intval($_SESSION['login']) ." LIMIT 1") OR die(mysql_error()); 

And if it's the value from the login field, try:

PHP Code:

$query = mysql_query("SELECT domains FROM users WHERE login = '". mysql_real_escape_string($_SESSION['login']) ." LIMIT 1") OR die(mysql_error()); 

[bhimpfen]

i insert more then 1 domain my nulling password and id and using insert for login and domains, so I can have multiple domain enteries per login

way u did it, is only showing 1 domain, i want to show unlimited domains