So i have a table that contains a range of columns, some of them fill the entire set of rows, some of them have say, 10 items in the column, while I have 25 rows.
This is the querie that I am using to display the data:
Quote:
|
$sql = "SELECT ColumnName FROM Table ORDER BY RAND() LIMIT 1";
|
I understand why its only displaying blank fields in some areas of my PHP coding (because its randomly pulling row data that doesnt exist in a column), however, how would I change the above querie to FORCE data to be displayed for a specific column, whether its full or only 1/2 full with data?
Hopefully, that makes sense?