0

We've had an old website move server but am having lots of problems with it, plus it's been nearly two years since I did any PHP so any help would be greatly appreciated.

Have sorted some problems out but am stumped by this one. Have stripped the code down to a simplified version/simplified query etc...

<?php
$query_PropCount = "SELECT '1' as numrows
FROM WEB_PROPOSAL" ;

$PCresult  = mysql_query($query_PropCount) or die('Error, query failed');
$PCrow     = mysql_fetch_array($PCresult);

#$numrows = $row['numrows'];
#echo $PCrow[numrows]; 
?>

If either of those red lines are included it fails. Unfortunately the new server doesn't give you a useful messge, just a 500 Internal server error. As a note, this code is embedded amongst lots of other code that all works, just this bit doesn't. Have tried various stuff like

if (mysql_num_rows($query_PropCount)>0) {

thanks in advance

1
Contributor
1
Reply
2
Views
7 Years
Discussion Span
Last Post by mjenn2
0

Seems to have magically fixed itself.

Edited by mjenn2: n/a

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.