[Resolved] mysql_fetch_array() error

[jakeone]

Hi,

Can anyone tell me what I'm doing wrong with in the following:

<ul>
<?php
$sql="SELECT topicID, topicName FROM topics";
$result=mysql_query($sql);
while($query_data = mysql_fetch_array($result)) {
echo '<li><a href="admingate.php?action=edit_topic&topicID='.'$query_data[topicID]">'.'$query_data[topicName]'.'</a></li><br>';
}
?></ul>

I get the following error message: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource. (Please ignore any wrapping).

Thanks for any pointers!

[DeltaRho2K]

Be very cautious with how you use single and double quotes... This should work for you. Let me know if it doesn't...
Also, you don't need the <BR> tag after your List item. This will cause extra large gaps in your list (unless that's what you want).

<ul>
<?php

$sql="SELECT topicID, topicName FROM topics";
$result=mysql_query($sql);

while($query_data = mysql_fetch_array($result))
 {
    echo "<li><a href=\"admingate.php?action=edit_topic&topicID=".$query_data['topicID']."\">".$query_data['topicName']."</a></li>";
 }
?>
</ul>

[jakeone]

Hi,

Thanks for the help - I'll watch out for those quotation marks in future.

I'm still getting the same error however. I'll persevere!...

Jake

[jakeone]

Hi DeltaRho2K,

I've fixed the problem - it was in my database connection. Thanks for your help!

Jake

[DeltaRho2K]

No problem...
Be sure to mark this thread as resolved. Sorry I couldn't help more, but without your Connection String in the original post, I had no chance ;-)

[GlenC]

Originally posted by jakeone
Hi DeltaRho2K,

I've fixed the problem - it was in my database connection. Thanks for your help!

Jake

Might i ask what the problem was? We are having this same error, and i just cant seem to find the problem. Thanks.

[DeltaRho2K]

Post your code GlenC, and we'll get things going for you... You may want to start a new thread if you haven't already since this thread is marked as resolved...

[GlenC]

After pulling out most of my hair, it turns out i had Register Globals turned on when my webmaster created his script. I had turned it off and it broke what he was doing. We just changed the way he passed the information and it worked. I was almost sure it was a connection problem, thats why i had asked here. Thanks anyways. 🙂 I guess its time i started doing more with php as to help offset the load on my webmaster.... hmmmm 😃