What's wrong with my code?

Manat

<?php
$contest="contestPromo";
$query = "select from contests where ContestName=$contest";
$Results =@ mysql_query($query);
$fp = fopen("contests.txt", "w")
while ($rows =@ mysql_fetch_array($Results))
{
fwrite ($fp, $row[*])
};

Why won't this work?
This should take the result of my query and put the results into contests.txt, no?

herve

Hi,

what about trying this :

fwrite ($fp, $rows[*])

instead of

fwrite ($fp, $row[*])

🙂

Hervé.

Manat

I tried that
But still, I get a PHP parse error on this line:

while ($rows =@ mysql_fetch_array($Results))

Any idea why?

buck2bcr

Have you connected to a database?

herve

I haven't catch that the first time

instead of :

$query = "select * from contests where ContestName=$contest";

you should have :

$query = "select * from contests where ContestName='$contest'";

also it a good habit not to use "@" since if something
is wrong, like in your case, you don't have the error message
mysql will normally send to you.

(I'm not sure, but in your source there a space between @
and mysql_fetch_array, there should be no space there)

Hervé.

Manat

It still didn't work and my server logs aren't giving me errors.

Here is my modified code:

<?php require("./db_mysql.inc.php");
$DB_NAME = "hidden";
$DB_USER = "hidden";
$DB_HOST = "hidden";
$DB_PASS = "hidden";

$db = new Db();
$db->DbConnect($DB_HOST, $DB_USER, $DB_PASS, $DB_NAME);?>
<html>
<head>
<title>Untitled</title>
</head>
<?php
$contest="promo";
$query = "select * from contests where ContestName='$contest'";
$Results=mysql_query($query);
$fp = fopen("contest.txt", "w")
while(list($Results)=mysql_fetch_array($query))

{
fwrite ($fp, $rows[*])
};

And still it doesn't work, but the above shouldn't have any errors.
And yes, lol, I am connected to a database.

tomhath

Parse error on a line almost always means the line before it has something missing, so when the parser went to the next line it found something unexpected (as in this case, it was expecting a semicolon, but found the word while instead).

$fp = fopen("contest.txt", "w") 
while(list($Results)=mysql_fetch_array($query))

Manat

I had put a semicolon

$fp = fopen("contest.txt", "w");

But it made no difference.
Now i'm not getting errors in my server logs, but the page is blank.

And I don't get a contest.txt download dialog box or anythign.

TalonFinsky

try:

$query = "select * from contests where ContestName = '".$contest."'";