php script to extract thread titles

[Cory Megitt]

I'm starting to program a php script to extract thread titles.
I am new to PHP but I'm learning ...

PHP Code:

<?php
$connect=mysql_connect('localhost', 'root', 'xxxxx') or die(mysql_error());
echo "Connected to MySQL<br />";
mysql_select_db("vb") or die(mysql_error());
echo "Connected to Database";
$sql="SELECT 'title' FROM 'thread' WHERE 'dateline' BETWEEN 1315958401 AND 1318723199";
$result=mysql_query($sql);
while($row = mysql_fetch_array($result))
{
      echo "$row <br />";
}  
?>

The output of this is:

Connected to MySQL
Connected to Database
Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /Applications/XAMPP/xamppfiles/htdocs/mysql.php on line 8

[kh99]

I think the problem is the quotes you have around the column and table names. The quote character should be a backtick (`) and it looks like you have single quotes. (You don't really have to quote column and table names unless they have special characters).

Also, if you look at the page for mysql_query (http://us2.php.net/manual/en/function.mysql-query.php) under the Return Values section, you'll see that it can return FALSE if there's an error, so that's why your error message says that mysql_fetch_array() was expecting an array.

[Cory Megitt]

Originally Posted by kh99

I think the problem is the quotes you have around the column and table names. The quote character should be a backtick (`) and it looks like you have single quotes. (You don't really have to quote column and table names unless they have special characters).

Also, if you look at the page for mysql_query (http://us2.php.net/manual/en/function.mysql-query.php) under the Return Values section, you'll see that it can return FALSE if there's an error, so that's why your error message says that mysql_fetch_array() was expecting an array.

I've adjusted the line to read:

PHP Code:

$sql="SELECT `title` FROM `thread` WHERE `dateline` BETWEEN 1315958401 AND 1318723199"; 


I've adjusted the single quotes to backticks. I now have an output that looks like this:

Connected to MySQL
Connected to DatabaseArray
Array
Array
Array
Array
Array
Array
Array
Array
Array 
.........  (it keeps on going for a little while)

[kh99]

That probably means it's working. The return from mysql_fetch_array() will be an array even if you are only selecting one column. So if you change your echo to $row['title'] you should see the titles.

[setishock]

Pardon my butting in but my curiosity is killing me. What would you use that for?

[Cory Megitt]

kh ... I get this now:
Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /Applications/XAMPP/xamppfiles/htdocs/mysql.php on line 10

setishock - The reason for this is to generate a report of thread titles from the 15th of each month to the 14th of each month.
Based on the data I have, it will populate an excel spreadsheet and make my monthly reporting for the manager a lot less time consuming.

It's only the start of what I want to have the script do.

[kh99]

Originally Posted by Cory Megitt

kh ... I get this now:
Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /Applications/XAMPP/xamppfiles/htdocs/mysql.php on line 10

That usually means that quotes are mismatched or something.

[Cory Megitt]

PHP Code:

<?php
$connect=mysql_connect('localhost', 'root', 'xxxx') or die(mysql_error());
echo "Connected to MySQL<br />";
mysql_select_db("vb") or die(mysql_error());
echo "Connected to Database";
$sql="SELECT `title` FROM `thread` WHERE `dateline` BETWEEN 1315958401 AND 1318723199";
$result=mysql_query($sql);
while($row = mysql_fetch_array($result))
{
echo "$row['title']";
}  
?>

That's what it looks like -- and it appears to have proper quotes.

[kh99]

Oh right. Sorry, change the echo line to

echo "$row[title]";

[Cory Megitt]

PHP Code:

<?php
$connect=mysql_connect('localhost', 'root', 'glide75') or die(mysql_error());
echo "Connected to MySQL<br />";
mysql_select_db("vb") or die(mysql_error());
echo "Connected to Database<br />";
$sql="SELECT `title` FROM `thread` WHERE `dateline` BETWEEN 1315958401 AND 1318723199";
$result=mysql_query($sql);
while($row = mysql_fetch_array($result))
{
echo "$row[title]<br />";
}  
?>

This is the final and working script.

Thanks for the help kh99.
It worked.
Just need to figure out how to calculate the from date and to date properly as needed.