[SOLVED] Why isn't this working? =S

[adamjones]

Ok.

I'm working on a very simple guestbook, for user profiles.

This is the code;

<?php
session_start();

....DATABASE INFO....

mysql_connect("$host", "$username", "$password")or die("cannot connect"); 
mysql_select_db("$db_name")or die("cannot select DB");

$user=$_GET['user'];

$sql="SELECT * FROM $tbl_name WHERE to='$user'";
$result=mysql_query($sql);
while($rows=mysql_fetch_array($result)){
?>
			<p class="clearboth style1">
			<p><div style="height:500px;width:350px;font:16px/26px Georgia, Garamond, Serif;overflow:scroll;">
                  <table width="100%" border="0" cellspacing="0" cellpadding="0">
                    <tr>
                      <td><? echo $rows['from']; ?></td>
                      <td><? echo $rows['message']; ?></td>
                      <td> </td>
                    </tr>
                  </table>
</div>
			</p>	
			<div class="clearboth"></div>
		<div class="end"></div>
            <?
}
mysql_close();
?>

 

But I get this error;

 

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/domainey/public_html/habhub/guestbook.php on line 17

 

Any ideas?

Adam.

[MasterACE14]

try...

<?php
session_start();

// ....DATABASE INFO....

$con = mysql_connect($host, $username, $password)or die("cannot connect"); 
$con = mysql_select_db($db_name)or die("cannot select DB");

$sql="SELECT * FROM $tbl_name WHERE to='".$_SESSION['user']."'";
$result = mysql_query($sql) or die(mysql_error());
while($rows = mysql_fetch_array($result)) {
?>
			<p class="clearboth style1">
			<p><div style="height:500px;width:350px;font:16px/26px Georgia, Garamond, Serif;overflow:scroll;">
                 <table width="100%" border="0" cellspacing="0" cellpadding="0">
                   <tr>
                     <td><?php echo $rows['from']; ?></td>
                     <td><?php echo $rows['message']; ?></td>
                     <td> </td>
                   </tr>
                 </table>
</div>
			</p>	
			<div class="clearboth"></div>
		<div class="end"></div>
<?php
}
mysql_close($con);
?>

 

see what error it gives you now.

[adamjones]

try...

<?php
session_start();

// ....DATABASE INFO....

$con = mysql_connect($host, $username, $password)or die("cannot connect"); 
$con = mysql_select_db($db_name)or die("cannot select DB");

$sql="SELECT * FROM $tbl_name WHERE to='".$_SESSION['user']."'";
$result = mysql_query($sql) or die(mysql_error());
while($rows = mysql_fetch_array($result)) {
?>
			<p class="clearboth style1">
			<p><div style="height:500px;width:350px;font:16px/26px Georgia, Garamond, Serif;overflow:scroll;">
                  <table width="100%" border="0" cellspacing="0" cellpadding="0">
                    <tr>
                      <td><?php echo $rows['from']; ?></td>
                      <td><?php echo $rows['message']; ?></td>
                      <td> </td>
                    </tr>
                  </table>
</div>
			</p>	
			<div class="clearboth"></div>
		<div class="end"></div>
<?php
}
mysql_close($con);
?>

 

see what error it gives you now.

 

Thanks. I get this now;

 

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'to='Adam'' at line 1

[ToonMariner]

<?php

session_start();

 

....DATABASE INFO....

 

mysql_connect("$host", "$username", "$password")or die("cannot connect");

mysql_select_db("$db_name")or die("cannot select DB");

 

$sql="SELECT * FROM $tbl_name WHERE to = '". mysql_real_escape_string($user) . "'";

$result=mysql_query($sql);

if (mysql_num_rows($result) > 0)

{

while($rows=mysql_fetch_array($result)){

?>

<p class="clearboth style1">

<p><div style="height:500px;width:350px;font:16px/26px Georgia, Garamond, Serif;overflow:scroll;">

                  <table width="100%" border="0" cellspacing="0" cellpadding="0">

                    <tr>

                      <td><? echo $rows['from']; ?></td>

                      <td><? echo $rows['message']; ?></td>

                      <td> </td>

                    </tr>

                  </table>

</div>

</p>

<div class="clearboth"></div>

<div class="end"></div>

            <?

}

}

else

{

echo "<p>no recipient could be found</p>";

}

mysql_close();

?>

 

is $tbl_name set?

 

is to the correct field?

[adamjones]

<?php

session_start();

 

....DATABASE INFO....

 

mysql_connect("$host", "$username", "$password")or die("cannot connect");

mysql_select_db("$db_name")or die("cannot select DB");

 

$sql="SELECT * FROM $tbl_name WHERE to = '". mysql_real_escape_string($user) . "'";

$result=mysql_query($sql);

if (mysql_num_rows($result) > 0)

{

while($rows=mysql_fetch_array($result)){

?>

<p class="clearboth style1">

<p><div style="height:500px;width:350px;font:16px/26px Georgia, Garamond, Serif;overflow:scroll;">

                  <table width="100%" border="0" cellspacing="0" cellpadding="0">

                    <tr>

                      <td><? echo $rows['from']; ?></td>

                      <td><? echo $rows['message']; ?></td>

                      <td> </td>

                    </tr>

                  </table>

</div>

</p>

<div class="clearboth"></div>

<div class="end"></div>

            <?

}

}

else

{

echo "<p>no recipient could be found</p>";

}

mysql_close();

?>

 

is $tbl_name set?

 

is to the correct field?

 

Yes, and yes

[Philip]

to is a reserved word. Either rename the column or change it in the query to `to`

[adamjones]

to is a reserved word. Either rename the column or change it in the query to `to`

 

Ahh. Thank you. Never knew this; Was just about to scrap the whole thing!

 

[Philip]

This page will help you

http://dev.mysql.com/doc/mysqld-version-reference/en/mysqld-version-reference-reservedwords.html

 

[adamjones]

This page will help you

http://dev.mysql.com/doc/mysqld-version-reference/en/mysqld-version-reference-reservedwords.html

 

 

Thanks.