what's wrong with my code?

Anon

Hi guys,

I'm trying to show a particular record from a mysql database in php but mysql doesn't accept my querry. It's the first thing i've made with mysql and php.

This is the code:
$result = mysql_query ("SELECT FROM nieuws " . "WHERE ID=$heelbericht");

This is the error
You have an error in your SQL syntax near 'FROM nieuws WHERE ID=21' at line 1

Does anyone know what's wrong??
any suggestions are welcome!

Anon

Hi,

What are you SELECTing?

Maybe what you need is a "*"

$result = mysql_query ("SELECT * FROM nieuws " . "WHERE ID=$heelbericht");

A "*" means to select all the columns from the table. Or maybe there are specific columns you are selecting that may or may not be renamed.

Try looking for a beginers guide to SQL. It might be worth working through one if you're playing around with Mysql/php

Devshed.com is a good site to start at!

Hope that helps

Anthony

yendor

You have to specify what to select.

$result = mysql_query("SELECT fieldname FROM table WHERE ID='$heelbericht'");

If you use * it will return all of the fields from the table.

Also if $heelbericht is not a numeric value you HAVE to put quotes around it. I would because with quotes is works either way. Also, make sure you use single quotes or escape "\" characters inside double quotes or it will break your string.

This is a no no:

$string = "SELECT * FROM table where name="$name"";

These are ok:

$string = "SELECT * FROM table where name='$name'";

$string = "SELECT * FROM table where name=\"$name\"";

Good Luck,

Rodney

Anon

I wouldn't do "SELECT *", instead, specify what columns you want. It works fine if you need every column, but tell it which ones to select for the sake of saving CPU time.

Anon

Uhh, using ' to delimit text values is what you want. " may work with mysql, but it's not standard.

Anon

Uhh, Joshua asked what will work. Not what is standard. I provided him with a couple of examples that WILL work. Asterisk or not double quotes or single quotes. Just trying to help, not be a critic. I don't feel I should tell people how they SHOULD do things. I give them examples of ways they COULD do things.

kankersite

Thanks guy's! It worked out fine. I'll take a look at Devshed.com. Thanks for the help and... I won't use " anymore.