[løst] Hjelp med php/mysql ?

[medusa1414]

Hei, har et problem:

 

Notice: Undefined variable: sql_get in C:\wamp\www\-\pastbin\index.php on line 117

 

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\wamp\www\-\pastbin\index.php on line 117

 

 

sql_get variablen / fetch_array:

	$sql_qet = mysql_query("SELECT * FROM pastbin LIMIT 0, 100 ORDER BY 'q_id' DESC");

while($row = mysql_fetch_array($sql_get)) {
	echo $row['tittel'] . '<br />';	
}

 

 

Jeg skjønner ikke hva som kan være feil ?

Har noen, noen tips ?

Endret 28. august 2008 av medusa1414

[Martin A.]

Hiv på "or die( mysql_error() );" etter mysql_query.

[medusa1414]

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY 'q_id' DESC' at line 1

 

 

Endret 28. august 2008 av medusa1414

[Alex Moran]

SELECT * FROM pastbin ORDER BY q_id DESC LIMIT 0, 100

[medusa1414]

SELECT * FROM pastbin ORDER BY q_id DESC LIMIT 0, 100

 

 

Skiftet til:

	$sql_qet = mysql_query("SELECT * FROM pastbin ORDER BY q_id DESC LIMIT 0, 100") or die (mysql_error());

while($row = mysql_fetch_array($sql_get)) {
	echo $row['tittel'] . '<br />';	
}

 

 

Men fortsatt feil:

Notice: Undefined variable: sql_get in C:\wamp\www\-\pastbin\index.php on line 117

 

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\wamp\www\-\pastbin\index.php on line 117

 

EDIT:

Linje 117:

while($row = mysql_fetch_array($sql_get)) {

 

 

 

 

Fler tips ?

Endret 28. august 2008 av medusa1414

[medusa1414]

Løst:

 

Hadde vist skrivi g istedenfor Q (liten)