Using echo for a table produces blank page, not even errors!!!?

[rawky1976]

Hi, I have a hyperlink which goes to the page below and passes the PK_ID from a query into 'userid'. From this we query the DB and then echo a table with a form; only the textboxes are already populated with the data from the query (in theory)!!!

But I get a blank page! I have error reporting on php and mysql but nothing is displayed?

<?php
 
echo "<form method=\"post\" action=\"\" style=\"padding-left: 10px\">";
 
ini_set('display_errors','On');
error_reporting(E_ALL);
 
$user = $_GET['userid'];
 
include 'config.php';
include 'opendb.php';
 
$query = "select * from users WHERE user_id LIKE '$user'"; 
 
$result = mysql_db_query("servicemgmt", $query . mysql_error());
 
$r = mysql_fetch_array($result);
 
$firstname = $r['user_fname'];
$lastname = $r['user_lname'];
$ext = $r['user_ext'];
$bleep = $r['user_bleep'];
$exttel = $r['user_extno'];
$email = $r['user_email'];
 
 
echo "<table style=\"width: 80%\">";
echo "<tr><td>First Name</td><td><input type=\"text\" value=\"$firstname\" name=\"firstname\" id=\"firstname\" style=\"width: 160px\"/></td><td>Last Name</td><td> <input type=\"text\" value=\"$lastname\" name=\"lastname\" id=\"lastname\" style=\"width: 160px\"/></td></tr>";
echo "<tr><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td></tr>";
echo "<tr><td>Extension</td><td> <input type=\"text\" value=\"$ext\" name=\"ext\" id=\"ext\" style=\"width: 160px\"/></td><td>Bleep No.</td><td> <input type=\"text\" value=\"$bleep\" name=\"bleep\" id=\"bleep\" style=\"width: 160px\"/></td></tr>";
echo "<tr><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td></tr>";
echo "<tr><td>External Tel.</td><td><input type=\"text\" value=\"$exttel\" name=\"exttel\" id=\"exttel\" style=\"width: 160px\"/></td><td>&nbsp;</td><td>&nbsp;</td></tr>";
echo "<tr><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td></tr>";
echo "<tr><td>Email</td><td><input type=\"text\" value=\"$email\" name=\"email\" id=\"email\" style=\"width: 200px\" /></td><td>&nbsp;</td><td>&nbsp;</td></tr>";
echo "<tr><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td></tr>";
echo "<tr><td><input name=\"updateuser\" type=\"submit\" id=\"updateuser\" value=\"Update User Details\" /></td><td>&nbsp;</td><td>&nbsp;</td><td><input name=\"reset1\" type=\"reset\" value=\"Clear Form\" /></td></tr>";
echo "</table>";
 
echo "</form>";
 
?>

[pbmods]

Heya, Rawky. Welcome to TSDN!

Try adding this after line 15:

echo mysql_error();
 

[rawky1976]

Thanks, it's still blank, here's the calling page: -

<?php 
 
error_reporting(E_ALL);
ini_set('display_errors', '1');
 
include 'config.php';
include 'opendb.php';
 
$edituser = $_POST['edituser'];
 
 
$search = $_POST['edituser'];
if ($search) // perform search only if a string was entered. 
{ 
$srch="%".$search."%"; 
$query = "select * from users WHERE user_sname LIKE '$srch'"; 
 
$result = mysql_db_query("servicemgmt", $query . mysql_error());
 
if ($result) 
{ 
echo "Names matching query: -<br><br>";
echo "<table width=90% align=left border=0>";
while ($r = mysql_fetch_array($result)) { 
$sn = $r["user_sname"];
$fn = $r["user_fname"];
$id = $r["user_id"]; 
echo "<tr><td width=\"100%\"><a href=\"editSearcheduser.php?userid=$id\">$sn $fn</a></td></tr>";
//echo "<tr><td>&nbsp;</td><td>&nbsp;</td></tr>"; 
}
echo "</table>"; 
} else { echo "problems...."; } 
} else { 
echo "Search string is empty. <br> Go back and type a string to search"; 
}
 
include 'closedb.php';
 
?>

[pbmods]

Heya, Rawky.

This line confuses me:

$result = mysql_db_query("servicemgmt", $query . mysql_error());
 

I don't understand why you are appending the result of mysql_error() to $query.

[Purple]

Hi,

try doing :

[PHP]echo $query;[/PHP]

and copying the query and running it directly in whatever database gui you have installed..

Let us know if that works ok cause we are then back to the code..

Regards Purple