Not sure how any of that code is running.
You mention 2 queries but you only have one query in there. It has 2 conditions, but it is one query.
Quote:
|
$sql = "SELECT * FROM Recipe WHERE Title RLIKE 'fryer' AND RLIKE 'Air' ORDER BY Title ASC;";
|
Needs to be:
$sql = "SELECT * FROM Recipe WHERE Title RLIKE 'fryer' AND
Title RLIKE 'Air' ORDER BY Title ASC";
You have to have the field being interrogated listed in each condition.
I am not sure if that is your only problem.
Quote:
|
PHP Warning: mysqli_query() expects parameter 1 to be mysqli, null given in /blah/blah/domain.com/members/test/index.php on line 62
|
This would indicate that you did not have a good connection. The first parameter on mysqli_query is the connection. The error message says that is null which would mean a bad connection.
The second set of code that was posted should not even run because of the errors in there. It shows 2 different wile loops but only one is closed. That doesn't matter though because the 2 different while loops make no sense. You are looping through the resuult and inside the loop you are looping through the results again. I don't think you want ot do that.
.