selecting Table

Anon

error message shows problem comes from the line which indicate select_db.
$connect=mysql_connect("localhost","chjeon","mypwd"); mysql_select_db=("teldevel",$connect);

I cannot find where the problem is...
Could you give me you previous experience or opinion?

Anon

hey...

what's the error message you get.?

dom
🙂

Anon

my error message is..

Parse error: parse error in /home/httpd/html/hr/hrm/list.php on line 11

and line ll is mysql_select_db=("db¸í",$connect"); .

Anon

given you have the database name in $dbname, just do this...

$id = mysql_connect("localhost");

mysql_select_db($dbname, $id);

if you are getting a parse error on line 11, this (helpfully) doesn't mean the error is on line 11... it's just where the parser realised something was wrong. if there are no unmatched quotes or brackets on line 11, look at the lines above for missing semi-colons or unfinished strings. if you use the emacs editor (or many others i'm sure) you can set up parenthesis matching, that tells you if you've missed a bracker. damn helpful.

if you still have no luck, just post the first 11 lines of code, and i'll have a look at it

dom
🙂

Anon

Dear dom
this is my all source....
Wha..t's wrong....

<TITLE> New Document </TITLE>
<META NAME="Generator" CONTENT="EditPlus">
<META NAME="Author" CONTENT="">
<META NAME="Keywords" CONTENT="">
<META NAME="Description" CONTENT="">
</HEAD>

<BODY BGCOLOR="#FFFFFF" link=black vlink=blue>
<?
$connect=mysql_connect("localhost","root","");
mysql_select_db=("teldevel",$connect);
$query="select emp_name,dept,position,sex,hobby,birth_year,birth_month,birth_day,birth_chk from employee order by emp_name asc";
$result=mysql_query($query,$connect);
$total=mysql_num_rows($result);
$totalid=$total;

Anon

Try this... I can't see anything wrong with yours, but i've just tidied it up a little... make sure you've got the ?> at the end...

dom
🙂

<HEAD>

<TITLE> New Document </TITLE>
<META NAME="Generator" CONTENT="EditPlus">
<META NAME="Author" CONTENT="">
<META NAME="Keywords" CONTENT="">
<META NAME="Description" CONTENT="">
</HEAD>

<BODY BGCOLOR="#FFFFFF" link=black vlink=blue>
<?php
$connect=mysql_connect("localhost","root","");

mysql_select_db=("teldevel",$connect);
$query="select emp_name,dept,position,sex,hobby,birth_year,birth_month,birth_day,birth_chk from employee order by emp_name asc";

$result=mysql_query($query,$connect);
$total=mysql_num_rows($result);
$totalid=$total;

</BODY>

Anon

Your error is with your mysql_select_db line, and here's why:

You have: mysql_select_db=("teldevel", $connect);

See the = sign in there that doesn't belong? mysql_select_db() is a function call, you're using it like you would a variable (without the $ sign).

Try this instead: mysql_select_db("teldevel", $connect);

--Ryan

Anon

goddamn, i'm stupid 🙂

Anon

Good Morning.. Ryan..
It's morning here.

What a foolish am I....
Thanks a lot...