retriving infomation from database

Wrsaith

[FONT=times new roman]I have the problem with retriving data from my database when i query the data base for the infomation it displays a blank screen with nothing on it but theres no error any were and if there was one with the database it would display one.[/FONT]

LordShryku

Grey text on a grey background.....bad idea.

As for your problem, show us your code.

Wrsaith

I have the problem with retriving data from my database when i query the data base for the infomation it displays a blank screen with nothing on it but theres no error any were and if there was one with the database it would display one.

for reasons I did not use the real localhost and username and pass here.
Edited fixed my missspelling
<?php

$conn = mysql_connect("localhost", "joeuser", "somepass");

mysql_select_db("testDB",$conn);

$sql = "SELECT * FROM testTable";

$result = mysql_query($sql, $conn) or die(mysql_error());

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

$id = $newArray['id'];

$testField = $newArray['testField'];

echo "The id is $id and the text is $testField <br>";
}
?>

thats my retreving script.

Thats how it should be. thats how the book shows to do it but it still not show anything on the screen when run.

LordShryku

while ($newArray = mysql_fetch_array($result)) {
No closing bracket for this while loop
$id = $newArray['id']No termnating ;
$testField = $newArray['testField'] No termnating ;

Wrsaith

the id and testfield end brackets was misspelling be me putting it into the forums here but what do you maen no end brackets for the while loop.

LordShryku

On the line with while($blah) {, there's no } anywhere to tell php when the loop is supposed to end.

Wrsaith

dran thats my missspelling too. its right befor the end script tag.

Wrsaith

I fixed my misspellings and made show the script is as I have it one the page but still nothing shows on the screen when I load the page.

Wrsaith

no one knows whats wronge? i still get nothgin showing up on my page.

laserlight

Test with:

<?php
error_reportin(E_ALL); //set PHP error reporting for debugging

$conn = mysql_connect("localhost", "joeuser", "somepass")
	OR die(mysql_error()); //for debugging
mysql_select_db("testDB", $conn)
	OR die(mysql_error()); //for debugging

$sql = "SELECT * FROM testTable";
//dont need to explicitly use $conn, so that is left out
$result = mysql_query($sql)
	OR die(mysql_error()); //for debugging

while ($newArray = mysql_fetch_array($result)) {
	$id = $newArray['id'];
	$testField = $newArray['testField'];
	echo "The id is $id and the text is $testField <br>";
}
?>

Next time copy and paste the code, and then make the alterations for sensitive information like usernames and passwords.
Try not to re-type the whole code snippet as typos could distract the issue from the main problem.