I have an array of user names that need to be matched with the DB table on the post.
When I post it, I get the following error:
Warning: mysqli_fetch_row () parameter 1 is expected to be mysqli_result, boolean / hermes / waloraweb008 / B2049 / info / folder / page. This array creates following the
@ sign (works fine):$ postpay on $ php 43 | 213 $ 1It is that I want to check for the array within DB.
$ mentionsql = "Choose * From Users Where Username $ $ shiz '"; $ Mentionquery = mysqli_query ($ db_conx, $ mentionsql); $ Row83 = mysqli_fetch_row ($ mentionquery); $ Music name = $ line 83 ["user name"];so that I can do this later:
mysqli_query ($ db_conx, "INSERT INTO notifications (user name, initiator, app, which_stats, Was done, date_time) value ('$ music name', '$ log_username', '& lt; a href = user.php? U = $ log_username & gt; $ log_username & lt; / a & gt; in a state Have mentioned you. ',' $ Statusid ', now (), now and ()) ");Why any error is there?
As far as I can interpret your code
$ shiz with commas The different string is the user name, therefore:$ shiz == 'user1, user2, user3'You are generating your query on this line:
$ mentionsql = "Select * Usernames where the user name in '$ shiz';If you include your example of
$ shiz So you receive a question like this:"Select * The actual syntax for the SQL command requires round brackets, however, if the user names are string, then the WHERE user name IN 'user1, user2, user3' "Then you have to put it in a single quote. So your query should look like this:
"Select * user WHERE user name IN ('user1', 'user2', 'user3') "
No comments:
Post a Comment