Not being inserted

run_GMoney

Somethings not working out here. I can't figure it out. I can get this statement to work with other tables in my database. Am I missing something easy?

<?php

include 'header.inc';
$result = mysql_query("INSERT INTO tablename (player) VALUES ('4')");
$display = mysql_query("SELECT * FROM tablename");
if($display == 0) // message isn't displayed, though it seems like it should
{
  echo "NO values were entered into the database";
}
$rowcheck = mysql_num_rows($display);
echo $rowcheck; //displays '0'
while ($row = mysql_fetch_array($display))
{
  echo "<br /> $row[player]";
  echo "<br />";
}

?>

'player' is a column in 'tablename'. I've double-checked that. For some reason I'm getting 0 stored in $rowcheck when it should have 1. 'tablename' only has 1 column and it's 'player'. So what the heck is going on here?

nnichols

You should always do some error checking when you run queries, then it makes it easier to troubleshoot -

<?php

include 'header.inc';

$sql = "INSERT INTO tablename (player) VALUES ('4')";
$result = mysql_query($sql)
	or die('MySQL error: '.mysql_error().'<br>Query: '.$sql);

$sql = "SELECT * FROM tablename";
$display = mysql_query($sql)
	or die('MySQL error: '.mysql_error().'<br>Query: '.$sql);

if(mysql_num_rows($display) == 0) {
	echo "NO values were entered into the database";
	}
$rowcheck = mysql_num_rows($display);
echo $rowcheck; //displays '0'
while ($row = mysql_fetch_array($display))
{
  echo "<br /> $row[player]";
  echo "<br />";
}

?>

mysql_error() should be your best friend while developing with MySQL 😉

run_GMoney

LOL, actually I got it all worked out...using mysql_error(). I tried to delete the thread but I guess we can't do that on this forum. But thanks for the help. I think it was an earlier post from you that I referenced when I figured it out. I was just annoyed that it was working with other tables.