sql statement

pinehead18

<?php
$con = mysql_connect("localhost", "pinehead", "yo") or die(mysql_error());
$db = mysql_select_db("pinehead", $con) or die(mysql_error());
$sql = "SELECT article FROM articles";
$result = mysql_query($sql, $con);
while ($row = mysql_fetch_row($result)) {

$art = $row['article'];

}



echo $art;
echo "hi";

This is my sql statement although it is not echoing the field article from table articles. I have no errors just get a blank page. I had echo $row['article']; but that didn't seem to work so i changed it to $art = $row['article']; maby you guys can see what my mistake is?

Thanks for your help
Anthony

stolzyboy

use this as your $result statement to get an error message from your sql, obviously it isn't returning what you think it should

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

also put your echo in your while loop, otherwise you will only be echoing one result and that may be an empty one

and also try throwing a semicolon after your sql statement, mysql is sometimes picky about that

$sql = "SELECT article FROM articles;";

keith73

Originally posted by pinehead18
<?php
$con = mysql_connect("localhost", "pinehead", "yo") or die(mysql_error());
$db = mysql_select_db("pinehead", $con) or die(mysql_error());
$sql = "SELECT article FROM articles";
$result = mysql_query($sql, $con);
while ($row = mysql_fetch_row($result)) {
$art = $row['article'];

}



echo $art;
echo "hi";
?>

This is my sql statement although it is not echoing the field article from table articles. I have no errors just get a blank page. I had echo $row['article']; but that didn't seem to work so i changed it to $art = $row['article']; maby you guys can see what my mistake is?

Thanks for your help
Anthony [/B]

mysql_fetch_row returns a numerically indexed array. You want to use either mysql_fetch_assoc or mysql_fetch_array.

with mysql_fetch_row you would get the result using a number ($row[0])

keith

stolzyboy

ha didn't even notice that, but that would create problems with your script, generally mysql_fetch_array is the most common method for grabbing results from an sql statement