Member Avatar for cliffcc

I don't know how to enquiry the "informationtype" which are message and email? How to rewrite the below code?

$information = mysql_query("SELECT * FROM table WHERE informationtype='message'");
$row = mysql_fetch_assoc($information);
$result=($row['informationno']);
  • 3 Contributors
  • 4 Replies
  • 79 Views
  • 18 Hours Discussion Span
  • Latest Post Latest Post by Stefano Mtangoo

Recommended Answers

All 4 Replies

Member Avatar for vibhaJ

Your code is right.
Are you facing any error?

Member Avatar for cliffcc 
$information = mysql_query("SELECT * FROM table WHERE informationtype='message' or 'email'");
Edited by cliffcc because: n/a
Member Avatar for vibhaJ

Correction...

$information = mysql_query("SELECT * FROM table WHERE informationtype='message' OR informationtype='email'");
Member Avatar for Stefano Mtangoo

I wonder how you guys understood the question. Am I that dumb?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.