whats wrong with my query?

Question

$check_badge = mysql_query("SELECT badge_number FROM users WHERE user_id = '$user_id' LIMIT 1") or die(mysql_error());

while($cb = mysql_fetch_array($check_badge));
{
badge_check = $cb['badge_number'];

}

yahoo cut off the middle bit;

while($cb = mysql_fetch_array($check_badge));

ill try again

while($cb = mysql_fetch_array
($check_badge));

Answer 1

I dont even understand the query, never mind whats wrong with it

Answer 2

You never learnt, do you?
1. Your WHERE clause is incorrect:
user_id='$user_id' is wrong syntax.
2. You set your query with LIMIT 1 -> you get ONE record.
So, why do you do a "while"?
3. PhP requires "$" in front of variables.
4. The index in = $cb[' ']; may be ok, if there is no typing mistake, but it is better to use the value of the index (i.e. $cb[0], or the relative index).
So, and for the last time:

$query = "SELECT * FROM users WHERE `user_id`
= ' " . $user_id . " ' LIMIT 1";
// pay attention to the correct syntax: `user_id` (back accent)
// and ' " . $user_id . " ' (spaces added for clarity)
$check_badge = mysql_query ($query) or die (mysql_error() );
$cb = mysql_fetch_array ($check_badge);
$badge_check = $cb[0]; // if badge_number is index 0.

Answer 3

It looks fine to me except for badge_check needing a $ in front of it. Also, you don't need to do a while loop if you are only grabbing one record. You could just do:

$cb = mysql_fetch_row( $check_badge );
$badge_check = $cb[0];

Answer 4

Looks like you've missed out the $ from in front of the variable on the statement inside the while loop.

i.e. it needs to be $badge_check instead of badge_check.

Other than that, I don't know.

Edit: To sparky, it's a computer programming language

Edited again: Oops, I forgot the statement in the while loop was an assignment as well. Silly me!

Answer 5

It looks like you are either an oracle dba or an sqlplus programmer maybe you need to write the full detail and what you expected to get as a result from your sqlplus query and the errors you got.

Answer 6

what on earth is this supposed to be asking????

is this a mensa test or something????????

Answer 7

WTF ?