Tricky problem

maye

I have a problem with my code...The webpage doesnt show any error, yet the php function doesnt work... can anyone find the problem?

This is the code:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
<style type="text/css">
<!--
.style1 {font-size: medium}
-->
</style>
</head>

<body>
<table width="1024" height="429" border="0" cellpadding="5" cellspacing="0">
  <tr>
    <td height="132" colspan="2" bordercolor="#FFFF00" bgcolor="#FFFF00">    <h2 align="center">KAGGEBLOGGEN</h2></td>
  </tr>
  <tr>
    <td width="785" height="235" bgcolor="#FFFF00"><iframe name="text" src="text2.php" width="785" height="300"></iframe></td>
    <td width="219" bordercolor="#FFFF00" bgcolor="#FFFF00"> 
    <?

$connect=@mysql_connect("host","user", "pass")
or die ("kunde inte ansluta");

$dbconn=mysql_select_db("Mayfair_DB_kaggebloggen");

$sql="SELECT * FROM Blogginlägg";



$result=mysql_query("$sql");

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


echo "<form method=post action=text2.php><br>";
echo "<b>Header</b><br>";
echo "<input type=radio name=".$rad[Rubrik]." value=".$rad[Rubrik]."><br>";
echo "<input type=submit>";
echo "</form>";

}
mysql_close($lank);
?>




</td>
  </tr>
</table>
</body>
</html>

jrolands

first of all it's not a very good idea to post a code containing host, username and pass for your database.. second, use "code" or "php" clams arround your code to make it more readable..
try removing the "@" in front of the mysql_connect() function.
This is an error control operator which means that it suppresses any errors generated by the function it's used on..

maye

Now I have tried that, didn't work...any other ideas? Thx for the suggestions about formatting the code, will do.

jrolands

i see, but the username and password is still there.. 😛

replace this:

    $result=mysql_query("$sql");

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


echo "<form method=post action=text2.php><br>";
echo "<b>Header</b><br>";
echo "<input type=radio name=".$rad[Rubrik]." value=".$rad[Rubrik]."><br>";
echo "<input type=submit>";
echo "</form>";

}

with this:

    $result=mysql_query($sql);

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


echo "<form method=post action='text2.php'><br>";
echo "<b>Header</b><br>";
echo "<input type=radio name='".$rad['Rubrik']." value='".$rad['Rubrik']."'><br>";
echo "<input type=submit>";
echo "</form>";

}

maye

nope, nothing🙁
thx for the suggestion though, I didn't remember how you used ' and what difference it had from " anymore, so I excluded it.

well, if you have any more suggestions, Im all ears🙂

jrolands

okay, let's try another approach.. what does it return? yo say you get no errors, but how about the source code of the page it returns.. post it

maye

This is the source code it returns, you can check it out yourself at www.kaggebloggen.se...I'm pretty new to php, so have patience with me.

one thing that should be noted is that the php code in the text2.php doc that is loaded in the iframe is almost the same. I just don't understand...

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
<style type="text/css">
<!--
.style1 {font-size: medium}
-->
</style>
</head>

<body>
<table width="1024" height="429" border="0" cellpadding="5" cellspacing="0">
  <tr>
    <td height="132" colspan="2" bordercolor="#FFFF00" bgcolor="#FFFF00">    <h2 align="center">KAGGEBLOGGEN</h2></td>
  </tr>
  <tr>
    <td width="785" height="235" bgcolor="#FFFF00"><iframe name="text" src="text2.php" width="785" height="300"></iframe></td>
    <td width="219" bordercolor="#FFFF00" bgcolor="#FFFF00"> 




</td>
  </tr>
</table>
</body>
</html>

jrolands

have you checked that your db name and table is right?

jrolands

try adding "echo mysql_num_rows($result);" after "$result=mysql_query($sql);"
and see how many rows it retreats..

maye

returned "mysql_num_rows()", is that good or bad...btw I checked out the DB and table and they seemed to be in order..

maye

sry, realised that I should have put that in ""...didn't return anything🙁

jrolands

are you sure that your php is working at all?

maye

yes ofc, as I said, it worked with text2.php which is loaded in the iframe. and as I said, it's a php script with the same build, save for just some slight adjustments.

maye

is there anyone else who has had problems with this one before whom managed to solve it?

bradgrafelman

Is display_errors set to On and error_reporting set to E_ALL ? If not, do so (ex. using [man]ini_set/man) and let us know if any errors show up.
Have you removed all @ error-suppressors from the script?

Try adding the following code if no error messages show up:

echo var_dump($connect) . ' || ' . var_dump($dbconn) . ' || ' . var_dump($result);

You shouldn't use the '<?' short-tags; they've long ago been deprecated and are no longer valid as of PHP6.