[Resolved] fetch_row error why?

genom

<?php

include("db.php"); // has all the connection details in it 

$sql = "SELECT * FROM `scschedule` WHERE 1";
$cycle = mysql_query($sql) or die (mysql_error());

while($row = mysql_fetch_row($cycle)) {
  $cycle = $row[1];
  }

echo "$cycle";

?>

I'm getting the following output.

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in <server/filename> on line number
april2004

So april2004 is the correcte value for $cycle, it's echoing it fine, but why am I getting the error? I can't turn the error reporting off as it's not my own server.

The table only has one row in it, with a series of dates. Any ideas welcome.

TheDefender

The problem is in your WHERE clause... You aren't comparing anything...

$sql = "SELECT * FROM `scschedule` WHERE 1"; 
//Perhaps something like this instead?!?
$sql = "SELECT * FROM `scschedule` WHERE `somefield` = 1";

With the way your statement is, it is going to output the last row of the table eveytime, and will throw out that error...

genom

I've tried a few different combinations such as.

$sql = "SELECT * FROM `scschedule` WHERE 1 AND `index` LIKE '1'";
$sql = "SELECT * FROM `scschedule` WHERE `index`= '1'";
$sql = "SELECT * FROM `scschedule` WHERE `index` =\"1\"";

None of them seem to make a difference, the error message remains the same.

devinemke

include('db.php');
$result = mysql_query('SELECT * FROM scschedule') or die(mysql_error());
while($row = mysql_fetch_row($result))
{
	echo $row[1] . '<br>';
}

genom

Okay that works, now can I ask why the ones with the where clause didn't work?

devinemke

Originally posted by genom
Okay that works, now can I ask why the ones with the where clause didn't work?

it has nothing to do with the WHERE clause. you kept overwritting your $cycle variable during your while loop.

genom

Doh!

That appears to be a favourite phrase of mine, i'll be so happy when I get this lot finished.

Thanks.