Error when trying to retrieve data from MySQL database with PHP

Question

So this is what I have:

<?php

$db_host = "localhost";
$db_username = "root";
$db_pass = "";
$db_name = "OnlineBulletinBoardDB";

@mysql_connect("$db_host","$db_username","$db_pass") or die ("Could no connect to    MySQL");
@mysql_select_db("$db_name") or die ("No database");

$query="SELECT PostSubject, FROM postings;";

$result=mysql_query($query);

mysql_close();

?>

<H1>Post Subject</H1>

<?php echo mysql_num_rows($result); ?>

But its not working, when I try and run it gives me some error on the last line.

Any ideas?

Dont worry guys, i found the error - it was the comma in the sql statement. — Jason
– Jason, Commented May 26, 2011 at 9:39

Rob · Accepted Answer · 2011-05-26 09:37:03Z

5

$query="SELECT PostSubject, FROM postings;"; is invalid sql

try $query="SELECT PostSubject FROM postings";

answered May 26, 2011 at 9:37

Rob

1,2552 gold badges21 silver badges45 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Rob Over a year ago

@Jason - no problem mate - I have been caught out like that on much simpler things (>.<)

Collectives™ on Stack Overflow

Error when trying to retrieve data from MySQL database with PHP

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related