Jump to content

Archived

This topic is now archived and is closed to further replies.

bobleny

How do I create an if statement that checks a certain database table?

Recommended Posts

How do I create an if statement that checks a certain database table? Something like this lets say,

[code]
<?php

mysql_connect('db4.awardspace.com:3306',$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM email";
$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();

if(!$result)
{
echo "(Inbox Empty) <br />";
}
else
{
echo "<center><u>-- Inbox --</u></center><br><br>";

$i=0;
while ($i < $num) {

$email=mysql_result($result,$i,"email");
$subject=mysql_result($result,$i,"subject");
$message=nl2br(mysql_result($result,$i,"message"));
$time=mysql_result($result,$i,"time");
$id=mysql_result($result,$i,"id");
}
?>
[/code]

Share this post


Link to post
Share on other sites
You can run "SHOW TABLES LIKE '<yourTable>' ", and then see if you get back results.

Share this post


Link to post
Share on other sites
I’m afraid that I don’t quite understand...

Could you explain in further detail?

Share this post


Link to post
Share on other sites
I'm not sure how to elaborate... show tables will return a list of all tables in the current DB. You can request just a specific table, so if that table is found, you'll get back one row, otherwise, you won't. That's easy to check.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.