Retrieving data from MySQL DB

[Sondar]

bradgrafelman;10947157 wrote:

Here:

   echo " 
    <td>$result</td> 
    <td>$result</td> 
    <td>$scoreresult</td>; 

there is no ending double quote to close the string, and here:

</tr> 
</tbody> 
</table>"; 

There is no [man]echo[/man] to output the data as well as a double quote to begin the string.

Awesome 🙂 Thanks i fixed that problem.

However, it's now oputting a table liek this:
User ID User Name Score
Resource id #2 Resource id #3 Resource id #2 Resource id #3 Resource id #2 Resource id #3

(Except all the Resource IDs are on one line). Why is it writing Resource ID and not the data contained in my SQL tables? I managed to do this before i changed the code and the error came.

Thanks again,
Sondar

[Emma]

Because you are outputting $scoreresult and not $scoreline

[Sondar]

Emma;10947165 wrote:

Because you are outputting $scoreresult and not $scoreline

Well now I feel like an idiot - it's obvious when i look at it.

Thanks! 🙂

[Sondar]

Sondar;10947166 wrote:

Well now I feel like an idiot - it's obvious when i look at it.

Thanks! 🙂

Sorry for the double post, but it still doesn't work. All that's happened is that the resource id 3 has changed to the word array for seom reason.

[bradgrafelman]

Since you're no longer having a parse error, I've moved your posts to a new thread.

Sondar;10947168 wrote:

changed to the word array for seom reason.

That's because [man]mysql_fetch_row/man returns an array.

Also note that you used $result which is a MySQL resource returned by [man]mysql_query/man, when you instead should be using one of the mysql_fetch_*() functions (or [man]mysql_result/man, if it's just one column you want) to actually retrieve the data.

[Emma]

bradgrafelman;10947169 wrote:

Since you're no longer having a parse error, I've moved your posts to a new thread.

For a minute there I thought I'd gone completely crazy - as my replies had disappeared 😉