[SOLVED] What would be the code for this?

[ballhogjoni]

I am connecting to my DB table and then exporting that table info to excel. My question is, is there a function that will let me know if there are no records in my table? Something like

 

$no_records = mysql_num_rows($sql=0)

if ($no_records=0) {

echo "You have No Records";

}

[conker87]

<?php $no_records = mysql_num_rows($sql)
if ($no_records==0) {
echo "You have No Records";
} ?>

 

Try that.

[ballhogjoni]

Lol gotta get my operators correct. I get a syntax error, unexpected T_IF on line 43 which is

 

 

if ($no_records==0) {

 

[bbaker]

<?php $no_records = mysql_num_rows($sql); //<== missing ;

if ($no_records==0) {

echo "You have No Records";

} ?>

[clanstyles]

$no_records = mysql_num_rows($sql)

 

change to:

$no_records = mysql_num_rows($sql);

 

( FORGOT THE ; AT THE END )

[trq]

All you really need is...

 

<?php

  if (!mysql_num_rows($sql)) {
    // no records.
  }

?>

[ballhogjoni]

This is the code I have:

 

if (!mysql_num_rows($sql)) {

echo "You have No Records";

}

 

But I get this warning and the code still executes:

 

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource on line 16

You have No Records

[conker87]

All you really need is...

 

<?php

  if (!mysql_num_rows($sql)) {
    // no records.
  }

?>

Hmm! I shall be using this from now on. Ta very much there thorpe.

[trq]

Then your query that produces the $sql (poor choice for variable name by the way) result is failing and your not checing it before using it.

 

We need to see more code. Specifically, the query that returns $sql.

[ballhogjoni]

It was a script someone else wrote and I dint bother changing variable name.

 

$sql = "Select * from contact_n_questions";

if (!mysql_num_rows($sql)) {

echo "You have No Records";

}

[trq]

You need to actually execute the query. eg;

 

<?php

  $sql = "Select * from contact_n_questions";
  if ($result = mysql_query($sql)) {
    if (!mysql_num_rows($result)) {
      echo "You have No Records";
    }
  }

?>

[ballhogjoni]

Thank everyone. You helped out a bunch ;D