Display SQL query results in php

Question

I m tring to diplay results in php from sql database  MySQL statement is correct and does what i want in phpMyAdmin but for some reason my code breaks in the webpage   here is the code   require once  db php       sql  SELECT   FROM  modul1open WHERE idM1O gt   SELECT FLOOR  MAX  idM1O     RAND       FROM  modul1open   ORDER BY idM1O LIMIT 1    result   mysql query  sql   echo   result      and here is what i get   In general I need random number limited from min to max by the table id

User · Accepted Answer

You need to fetch the data from each row of the resultset obtained from the query. You can use mysql_fetch_array() for this.

// Process all rows
while($row = mysql_fetch_array($result)) {
    echo $row['column_name']; // Print a single column data
    echo print_r($row);       // Print the entire row data
}

Change your code to this :

require_once('db.php');  
$sql="SELECT * FROM  modul1open WHERE idM1O>=(SELECT FLOOR( MAX( idM1O ) * RAND( ) )  FROM  modul1open) 
ORDER BY idM1O LIMIT 1"

$result = mysql_query($sql);
while($row = mysql_fetch_array($result)) {
    echo $row['fieldname']; 
}

User · Answer

You cannot directly see the query result using mysql query its only fires the query in mysql nothing else   For getting the result you have to add a lil things in your script like  require once  db php        sql  SELECT   FROM  modul1open WHERE idM1O gt   SELECT FLOOR  MAX  idM1O     RAND       FROM  modul1open  ORDER BY idM1O LIMIT 1      result   mysql query  sql      echo   result   while   row   mysql fetch array  result  MYSQL ASSOC         print r  row       This will give you result

User · Answer

You need to do a while loop to get the result from the SQL query  like this   require once  db php       sql  SELECT   FROM  modul1open WHERE idM1O gt   SELECT FLOOR  MAX  idM1O     RAND          FROM modul1open  ORDER BY idM1O LIMIT 1     result   mysql query  sql    while  row   mysql fetch array  result  MYSQL ASSOC             If you want to display all results from the query at once      print r  row           If you want to display the results one by one     echo  row  column1        echo  row  column2       etc        Also I would strongly recommend not using mysql   since it s deprecated  Instead use the mysqli or PDO extension  You can read more about that here

[php] Display SQL query results in php

Examples related to php

Examples related to mysql

Examples related to random

Examples related to numbers

Examples related to generator