Variable in select statement

Dev Shed Forums Sponsor:

April 14th, 2000, 10:26 AM

djmouse

Junior Member

Join Date: Apr 2000

Posts: 14

Time spent in forums: < 1 sec
Reputation Power: 0

Hi,

I want to do the following:

Select ID
From tablename
where name='$name'

How do I do this in PHP?

Thanks in advance,
Yomo

April 14th, 2000, 01:12 PM

CTD

Junior Member

Join Date: Apr 2000

Posts: 20

Time spent in forums: < 1 sec
Reputation Power: 0

$query = "SELECT * FROM table_name WHERE
columnname="" .
$variable_name . """;

mysql_connect($host,$user,$password);
mysql_select_db($database);
$result = mysql_query($query);

April 14th, 2000, 01:35 PM

Darguz

Registered User

Join Date: Dec 1999

Location: Ann Arbor, MI USA

Posts: 6

Time spent in forums: 29 m 29 sec
Reputation Power: 0

MySQL uses single quotes. Try:

$Query = "select ID From tablename where name='$name'";

Then the rest of what CTD said.

April 14th, 2000, 03:44 PM

CTD

Junior Member

Join Date: Apr 2000

Posts: 20

Time spent in forums: < 1 sec
Reputation Power: 0

Darn, I have been using double quotes. I will say that they work, but I guess I should switch to the correct syntax.

Viewing: Dev Shed Forums > Programming Languages > PHP Development > Variable in select statement

« Previous Thread | Next Thread »

Developer Shed Advertisers and Affiliates

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox

Forum Jump