[SOLVED] fetch array

[SJames]

$result = mysql_query("SELECT * FROM page_content WHERE cID = '$cID'") or die ("Select Error");

$resultArray = mysql_fetch_array($result) or die ("Array Error");

 

It already connects properly and everything but when it gets to the fetch_array part, I get the "Array Error" error. I can't figure out why this doesn't work. mysql_fetch_row doesn't work either.

[Jessica]

print out the sql?

[SJames]

I'm just trying to make the array here... Printing it doesn't work because the array doesn't get made. If it's important, printing out $result returns "Resource ID#3".

[marcus]

What are you echo'ing?

[SJames]

I'm not echoing anything yet, I'm trying to get the mysql_fetch_array to work, it still gives me the error.

[SJames]

Oh, never mind -- I got it working... Thanks anyway.

[darkfreaks]

<?php
mysql_select_db("mydb");/// need to select a database after connecting to script then do your query

$result = mysql_query("SELECT * FROM page_content WHERE cID = '$cID'") or die ("Select Error");




$resultArray = mysql_fetch_array($result) or die ("Array Error");?>