[SOLVED] Resource id #3

[berry05]

i get this error "Resource id #3 "

when i run the script...

 

<?php
// Make a MySQL Connection
mysql_connect("localhost", "root", "") or die(mysql_error());
mysql_select_db("math") or die(mysql_error());

// Get all the data from the "example" table
$result = mysql_query("SELECT * FROM problems ORDER BY RAND() LIMIT 0,1;") 
or die(mysql_error());  



// keeps getting the next row until there are no more to get
while($row = mysql_fetch_array( $result )) {
// Print out the contents of each row into a table
echo $result;

} 

?>

[Ken2k7]

I think you meant to echo something in the $row array instead of $result.

[berry05]

mhm when i do that it now just says..

Array ...

 

wouldn't i need to change this part then?

 

while($row = mysql_fetch_array( $result )) {

[Ken2k7]

$row is an array. What is it you want to do?

[berry05]

I have 3 math problems in my table...I want to show a random math problem when i run the script...just 1 out of the 3...

 

 

btw thanks for helping me out man!

[Ken2k7]

Tell me what output you get when you run this:

 

<?php
// Make a MySQL Connection
mysql_connect("localhost", "root", "") or die(mysql_error());
mysql_select_db("math") or die(mysql_error());

// Get all the data from the "example" table
$result = mysql_query("SELECT * FROM problems ORDER BY RAND() LIMIT 0,1;") 
or die(mysql_error());  

// READ!!
// if you put LIMIT 0, 1, then the maximum rows you get back is 1.
// no need for a loop
$result = mysql_fetch_assoc($result);

var_dump($result);
?>

[berry05]

now i get this

array(1) { ["problems"]=>  string(4) "1+1=" }

[Ken2k7]

<?php
// Make a MySQL Connection
mysql_connect("localhost", "root", "") or die(mysql_error());
mysql_select_db("math") or die(mysql_error());

// Get all the data from the "example" table
$result = mysql_query("SELECT * FROM problems ORDER BY RAND() LIMIT 0,1;") 
or die(mysql_error());  

// READ!!
// if you put LIMIT 0, 1, then the maximum rows you get back is 1.
// no need for a loop
$result = mysql_fetch_assoc($result);

echo $result['problems'];
?>

[berry05]

im learning!

aha

i figured it out by using arrays!

now i dont need to use the database..

here's the simple code..

 

<?php
$problems = array ( "1+1=", "1+2=", "1+3=" );
$random = $problems[array_rand($problems)];
echo $random;
?>

[Ken2k7]

It's probably best to use the DB though.

[berry05]

LOL

I need to learn PHP waaay better than what I know now..aha