[RESOLVED] MySQL data not displaying

This site is best viewed in a modern browser with JavaScript enabled.

angelrulez7

I really can't get this one, and it doesn't seem as obvious.

So, I'm trying to make a chat for my site, but first off, it isn't displaying the data. Second, here's a screenshot of the problem.
http://puu.sh/53ddT.png

Here's the code.

<?php
include_once('../include/session.php');
mysql_query("SELECT * FROM chat ORDER BY id DESC LIMIT 90'");
?>
<font color="<? 
mysql_connect("*****", "*****", "*****") or
die("No se pudo conectar: " . mysql_error());
mysql_select_db("ni235658_1sql2");
$resultado = mysql_query("SELECT chatcolor FROM users WHERE username='".$rows[name]."'");
while ($fila = mysql_fetch_array($resultado, MYSQL_BOTH)) {
printf ("%s", smiles(BBcode($fila[chatcolor])));} ?>">
<?php echo $rows['name']; ?>:</font> <?php echo smiles($rows[message]) ?><br>

Also, it doesn't notice that I ended the "font color" html code. Instead, before AJAX refreshing, says ">: in blue, then turns to just a :.

Here is my table.
http://puu.sh/53dxg.png

Proof that it does in fact have rows.
http://puu.sh/53dIy.png

So it IS inserting, just not displaying. Please help. Thanks.

ginerjm

I don't see where you are storing the results of the first query. I also don't understand that font color thing. Not at all.

NogDog

My suggestion would be to reorganize your code. Take care of all the database connection and queries first, assigning results to variables (whether scalar or array). Right now it looks like you try to do your first query before you connect to the database?

Then do your output, echoing the applicable variables where needed.

Also, always use the full <?php tag, as <? is not supported in all environments/configurations.

angelrulez7

NogDog;1293919 wrote:
My suggestion would be to reorganize your code. Take care of all the database connection and queries first, assigning results to variables (whether scalar or array). Right now it looks like you try to do your first query before you connect to the database?

Then do your output, echoing the applicable variables where needed.

Also, always use the full <?php tag, as <? is not supported in all environments/configurations.

OH, WHOA. I accidentally posted the database info! As a moderator, I can guess you can edit it. Can you please remove that?
Also, the MySQL doesn't even need to be connected because session.php connects everything.

Mohammad_Kurdi

I haven't understand any thing in font color but make the code like this:


<?php
include_once('../include/session.php');

?>

<?php

mysql_connect("*****", "*****", "*****") or
die("No se pudo conectar: " . mysql_error());
mysql_select_db("ni235658_1sql2");

$resultado = mysql_query("SELECT * FROM chat ORDER BY id DESC LIMIT 90'");

while ($row = mysql_fetch_array($resultado)) {

echo '<font color="blue">'.$rows['name'].' : </font>';

echo $rows['message'].'<br>';

}

 ?>

may be this will work.

Sorry I have write this from mobile for that I am sorry for any wrong.

ginerjm

This code sample is obviously full of mistakes. When you get home and actually try it out and debug it, then ask for help.

angelrulez7

The "font color" code is to echo the user's chat color username. It connects to the user table and selects that and then returns it.

angelrulez7

Well, got it working. It displaying >: was because of a really bad AJAX system, and has been replaced. Also, I had been echoing much stuff wrong.