I mixed sql and sqli commands..but this gives errors..what is the correct code?

Question

There's some error in this piece of code..can someone care to correct me?

$user_list=mysqli_query("SELECT 'id','username', FROM 'users' ");
    while($run_user=mysqli_fetch_array($user_list)){
        $user=$run_user['id'];
        $username=$run_user['username'];
        echo "<p><a href='send.php?user=$user'>$username</a></p>";
        }

From comments made below -

mysqli_query() expects at least 2 parameters, 1 given in D:\wamp\www\2\send.php on line 44

*They're not getting any Sam* @JayBlanchard ;-) and tutorials?! doubt it. — Funk Forty Niner, Jun 26 '15 at 13:43
mysqli_query() expects at least 2 parameters, 1 given in D:\wamp\www\2\send.php on line 44 — mee, Jun 26 '15 at 13:45
this is a terrible question. Please go over proper tutorials before posting this. — Funk Forty Niner, Jun 26 '15 at 13:51

score 1 · Accepted Answer · answered Jun 26 '15 at 13:39

1

Ummm, see your SELECT query once, it's full of errors like below

don't quote column names and table names else DB engine will think it as string literal rather a column.
there is a extra , before FROM clause in your query.

Correct one should be

SELECT `id`,`username` FROM `users`

answered Jun 26 '15 at 13:39

Rahul

76,197
13
71
125

i jus tried what u told me..still the same – mee Jun 26 '15 at 13:41
mysqli_query() expects at least 2 parameters, 1 given in D:\wamp\www\2\send.php on line 44..this is the error – mee Jun 26 '15 at 13:44
Hmm, someone downvoted ... not sure why though? Any idea??? – Rahul Jun 26 '15 at 13:48
....was not me. but reason could be that db connection isn't in the answer? who knows if OP even has those setup too. – Funk Forty Niner Jun 26 '15 at 13:48
@Fred-ii-, LOL I have no idea about PHP brother ... saw the mistakes in query so answered :) – Rahul Jun 26 '15 at 13:49
2

however Rahul, the question itself is a real "can of worms". OP is posting all these other error messages and didn't bother reading and understanding tutorials. We are not a school after all ;-) I gave an upvote for the initial question. – Funk Forty Niner Jun 26 '15 at 13:50
@Fred-ii-, Yes, indeed it is. I feel like deleting my answer :) – Rahul Jun 26 '15 at 13:53
the choice is yours amigo ;-) best to just run away lol – Funk Forty Niner Jun 26 '15 at 13:53
@Fred-ii-, you are playing politics with me now ... :). I know that's what you want me to do ... LOL :) nice talking friend. Cheers. – Rahul Jun 26 '15 at 13:54
1

If I had put in an answer for the question and be faced with all of this, I would have no hesitated to delete my answer. We can't save them all.... *cheers* ;-) – Funk Forty Niner Jun 26 '15 at 13:56

Saty · Answer 2 · 2015-06-26T13:49:23.300

-2

Just replace quotes with backtick also mysqli_query need connection in your first parameter

 $user_list=mysqli_query(PASS_YOUR_CONNECTION_VARIABLE,"SELECT `id`,`username` FROM `users`");

edited Jun 26 '15 at 13:49

answered Jun 26 '15 at 13:40

Saty

22,443
7
33
51

not debugged..still the same.. – mee Jun 26 '15 at 13:43
mysqli_query() expects at least 2 parameters, 1 given in D:\wamp\www\2\send.php on line 44 – mee Jun 26 '15 at 13:43
Ok, but what about the `,` before FROM??? – Rahul Jun 26 '15 at 13:43
yeah i removed it..still the same – mee Jun 26 '15 at 13:46
mysqli_fetch_array() expects parameter 1 to be mysqli_result, null given in D:\wamp\www\2\send.php on line 45..these two errors – mee Jun 26 '15 at 13:46
have you pass your connection variable as your first parameter – Saty Jun 26 '15 at 13:47
@sathwik mysqli_fetch_array() expects parameter 1 to be mysqli_result, null given.......... your query failed and you need to find out why that is. Add error reporting to the top of your file(s) right after your opening PHP tag for example ` – Funk Forty Niner Jun 26 '15 at 13:55
it was error in connection variable...thanks anyway @Saty – mee Jun 26 '15 at 13:56

I mixed sql and sqli commands..but this gives errors..what is the correct code?

2 Answers2