Jump to content


Photo

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


  • Please log in to reply
3 replies to this topic

#1 bobleny

bobleny
  • Members
  • PipPipPip
  • Advanced Member
  • 429 posts

Posted 23 May 2006 - 11:03 AM

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

<?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");
}
?>

-- www.firemelt.net --
First do me a favor and read this: JavaScript is NOT Java - Then read this: www.php.net - When your done with that, read this Topic
After that, floors open. I and anyone else will be MORE than happy to answer YOUR query! [Topic Solved]
Cheer up, the worst has yet to come...

#2 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 23 May 2006 - 08:19 PM

You can run "SHOW TABLES LIKE '<yourTable>' ", and then see if you get back results.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.

#3 bobleny

bobleny
  • Members
  • PipPipPip
  • Advanced Member
  • 429 posts

Posted 23 May 2006 - 09:29 PM

I’m afraid that I don’t quite understand...

Could you explain in further detail?
-- www.firemelt.net --
First do me a favor and read this: JavaScript is NOT Java - Then read this: www.php.net - When your done with that, read this Topic
After that, floors open. I and anyone else will be MORE than happy to answer YOUR query! [Topic Solved]
Cheer up, the worst has yet to come...

#4 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 23 May 2006 - 10:10 PM

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.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users