help

[spearchilduser]

can anyone see a error with this code ?

 

$query = mysql_query("SELECT * FROM project WHERE Module_Code ='$schemelevel' AND Available ='Yes'");

$result = mysql_query($query);

 

while ($myrow = mysql_fetch_row($result)) {

 

seems to be a issue using fetch_row ($result) telling me theres a issue with the resource

 

[AyKay47]

mysql_query expects it's first argument to be a string containing valid SQL, which is what you have contained in $query.

With $result, you are attempting to query a query resource, which is invalid, the code should read:

 

$query = "SELECT * FROM project WHERE Module_Code = '$schemelevel' AND Available = 'Yes'";
$result = mysql_query($query);
while ($myrow = mysql_fetch_row($result))
{
//code
}

[spearchilduser]

Hi thanx for the reply yer that makes scence

 

However now when i run the page it dispalys nothing when everythign is worded correclt in the correct format :s

[AyKay47]

Is there any other code in the page?

Try this debugging code and post the results:

 

$sql = "SELECT * FROM project WHERE Module_Code = '$schemelevel' AND Available = 'Yes'";
$result = mysql_query($sql) or die($sql .'<br />'. mysql_error());
if(mysql_num_rows($result) == 0)
{
    echo "no results";
    exit;
}
while ($myrow = mysql_fetch_row($result))
{
//code
}

[spearchilduser]

just printing no results but i know there is data in the table that should display results and  the fields are named correclty as well

[AyKay47]

alright, then try this:

 

$sql = "SELECT * FROM project WHERE Module_Code = '$schemelevel' AND Available = 'Yes'";
$result = mysql_query($sql) or die($sql .'<br />'. mysql_error());
if(mysql_num_rows($result) == 0)
{
    echo "no results <br/ >";
    echo $sql;
    exit;
}
while ($myrow = mysql_fetch_row($result))
{
//code
}

[spearchilduser]

hey same thing except its now displayign the query

 

no results

SELECT * FROM project WHERE Module_Code = 'Bsc Hons' AND Available = 'Yes'

 

 

[AyKay47]

and are these values correct?

[spearchilduser]

No it should show a table with an entry within it as my database has a entry that matches the criteria but it is printing out the select statment correctly

[AyKay47]

Something is not right here, if the select statement was printing out as it should, it would grab results data from the table, but it is not.

Post the entire relevant code.

[spearchilduser]

<?php
$db = mysql_connect("", "","");
mysql_select_db("");

$schemelevel = $_POST['schemelevel'];

$sql = "SELECT * FROM project WHERE Module_Code = '$schemelevel' AND Available = '1'";
$result = mysql_query($sql) or die($sql .'<br />'. mysql_error());
if(mysql_num_rows($result) == 0)
{
    echo "no results <br/ >";
    echo $sql;
    exit;
}
while ($myrow = mysql_fetch_row($result))
{
echo "<table border=1>\n";
echo "<tr><td>Module Code</td><td>Title</td><td>First_Supervisor</td><td>Level</td><td>Description</td></tr>\n";




echo "<tr><td><A HREF='http://students.comp.glam.ac.uk/08030472/project/displayproject.php?T1=$myrow[0]'>$myrow[0]</A></td><td>$myrow[1]</td><td>$myrow[2]</td><td>$myrow[3]</td><td>$myrow[4]</td></tr>\n";
	//printf("<tr><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td></tr>\n",
	//echo"<A HREF='http://students.comp.glam.ac.uk/08030472/project/displayproject.php?T1=$myrow[0]'>$myrow[0]</A>"$myrow[0],$myrow[1],$myrow[2],$myrow[3],$myrow[4]);
}
echo "</table>\n";
?>
</body>
</html>

[AyKay47]

then the SQL is simply not matching any results sets in the db table.

Make sure the field types are correct and the values to be compared are correct etc..

[PFMaBiSmAd]

Do you even know what data is in your table? You have changed the query from using Available = 'Yes' to using Available = '1'? What is the actual data in your database table that the query should return?

[cpd]

A complete guess but if your fields are named appropriately, isn't Module_Code a unique code for each module, not "BSc Hons". Could be completely wrong so still answer PFMaBiSmAd's question regarding what data should be returned.

[spearchilduser]

hi sorry yeah i put in the wrong field name god how stupid sorry for wasting tiem and thanx for the responses

[AyKay47]

not a problem, sometimes the easiest fixes are the hardest to spot.