sql database to php

[oursler]

I'm trying to select and print info from my database to a php page. I can't seem to figure this out. Please help.

 

 

 

<?php

$con = mysql_connect("localhost","****","****");

if (!$con)

  {

  die('Could not connect: ' . mysql_error());

  }

 

mysql_select_db("my_db", $con);

 

$result = mysql_query("SELECT * FROM Events");

 

while($row = mysql_fetch_array($result))

  {

  echo $row['ename'] . $row['date'] . $row['time'];

  echo "<br />";

  }

 

mysql_close($con);

?>

[kenrbnsn]

Are you having any problems? Any errors?

 

Ken

[oursler]

no errors, i just can't get it to print the info from the database to the page that this is on

[otuatail]

If you are not getting any errors. IE die('Could not connect: ' . mysql_error());

 

Are there any records to return? Run the query directly on the database. and see the results.

Des.

 

[YourNameHere]

Try doing

$recCount = mysql_num_rows($result);

 

then in your while loop

 

while ($t < $recCount){
				$column=mysql_result($recResult,$t,column_name);
				$column2=mysql_result($recResult,$t,column_name2);
				$column3=mysql_result($recResult,$t,column_name3);

//echo code


				$t++;				
				}

[oursler]

thanks, got it