[SOLVED] Login Script - Need Help Please... - pt.2

[Corey Maddox]

Okay I have a login script and it writes 4 things into a mySQL database

 

Username - name

Password - pass

Level - level

ID - id

 

mainly I have this script that calls for the lines and displays them how they need to be.

 

<?

$host = "sql06.freemysql.net";

$user = "coreyma";

$pass = "japanese";

$dbname = "csmusers";

 

$connection = mysql_connect($host,$user,$pass) or die (mysql_errno().": ".mysql_error()."<BR>");

mysql_select_db($dbname);

 

$sql = 'SELECT * FROM `data` LIMIT 0, 30 ';

$query = mysql_query($sql);

 

while ($row = mysql_fetch_array($query))

{

echo "$";

echo "cfgLogin[",$row['id'],"]&nbsp=&nbsp'",$row['name'],"';<br>";

echo "$";

echo "cfgPassword[",$row['id'],"]&nbsp=&nbsp'",$row['pass'],"';<br>";

echo "$";

echo "cfgUserLevel[",$row['id'],"]&nbsp=&nbsp'",$row['level'],"';<br>";

echo "$";

echo "cfgUserID[",$row['id'],"]&nbsp=&nbsp'",$row['id'],"';<br><br>";

}

 

?>

 

 

This the rows and style needs to be actually inserted into the php file, not echoed and displayed...

I dunno how to do that, any help would be great.

[phpQuestioner]

do something like this:

 

<?php

while ($row = mysql_fetch_array($query))
{
echo "<span style=\"color:red\">"; // add your css styles to this span
// echo php variable here
echo "</span>";
}

?>

 

you could also give your span an id or class and style the span in an external css file.

[Corey Maddox]

No... right now the text is being echoed as

 

$cfgLogin[1] = 'test';

$cfgPassword[1] = 'test';

$cfgUserLevel[1] = '';

$cfgUserID[1] = '1';

 

But it is echoing as displayed text... I need it to somehow just be on the page and not echoed... liek part of the actual script...

 

 

[phpQuestioner]

place each of your field values in a variable

 

like:

 

$username = $row["username"];

[zimmer]

you also might want to change your password, now that we know it.

[Corey Maddox]

Will do. Especially since some dumbass hacked my gmail and youtube , but thankfully I recovere my accounts.

 

I also got the script to be fully functional now

 

Thanks you guys!

 

-Corey Maddox