user curly braces around your arrays in the string e.g:
$sql = "INSERT INTO x VALUES ({$_SESSION['add']['name']} ";
oh, and unless add & name are actually constants you should always wrap
them in single quotes. (php will covert the non-exstent constant into a
string a issue an E_NOTICE + its
Tuesday, April 6, 2004, 1:21:52 AM, you wrote:
> hi...
> i cant cut and paste my exact mysql query because it takes the ''
> stuff out doubles the $'s and the ,'s in the whole thing (dont know
> why but anyways...)...
> i have a query that goes something like this:
> mysql_query("insert into $Gue
Hi
Try the following to find out what's happening :
$result = mysql_query($query,$conn) or die (mysql_error());
Or try echo'ing $result to see what it contains. It should contain something
like this if everything is working fine :
Resource id #2
Regards
Girish
- Original Message -
is ol' fool.
Cheers,
Brad
> From: "Christopher Allen" <[EMAIL PROTECTED]>
> Date: Tue, 17 Jul 2001 09:11:05 -0500
> To: "Brad Wright" <[EMAIL PROTECTED]>
> Subject: Re: [PHP] mysql_query problem (more suggestions)
>
> not right because this
> > From: Alvin Tan <[EMAIL PROTECTED]>
> > Date: Tue, 17 Jul 2001 14:38:58 +0800
> > To: Brad Wright <[EMAIL PROTECTED]>, Jason Murray
> > <[EMAIL PROTECTED]>, PHP General List
> > <[EMAIL PROTECTED]>
> > Subject: Re: [PHP] mysql_query pr
lvin Tan <[EMAIL PROTECTED]>
> Date: Tue, 17 Jul 2001 14:38:58 +0800
> To: Brad Wright <[EMAIL PROTECTED]>, Jason Murray
> <[EMAIL PROTECTED]>, PHP General List
> <[EMAIL PROTECTED]>
> Subject: Re: [PHP] mysql_query problem (more suggestions)
>
> Hi ag
right wrote:
>Jason,
>I have tried what yoiu suggested. result is the same.
>
> > From: Jason Murray <[EMAIL PROTECTED]>
> > Date: Tue, 17 Jul 2001 15:28:11 +1000
> > To: "'Brad Wright'" <[EMAIL PROTECTED]>, Alvin Tan
> > <[EMAI
Jason,
I have tried what yoiu suggested. result is the same.
> From: Jason Murray <[EMAIL PROTECTED]>
> Date: Tue, 17 Jul 2001 15:28:11 +1000
> To: "'Brad Wright'" <[EMAIL PROTECTED]>, Alvin Tan
> <[EMAIL PROTECTED]>, PHP General List <[EMAIL
> Unless i have actually defined a function 'password()', calling 'echo
> password('$password') will (...does, i just double checked)
> causes a Fatal
> Error 'Undefined Function'.
> Nice try tho :)
the original mail said to echo $query, which will include some
text in it that says "password('i
7;echo
password('$password') will (...does, i just double checked) causes a Fatal
Error 'Undefined Function'.
Nice try tho :)
> From: Alvin Tan <[EMAIL PROTECTED]>
> Date: Tue, 17 Jul 2001 13:07:45 +0800
> To: Brad Wright <[EMAIL PROTECTED]>
> Subject:
> $testResult = mysql_query("SELECT * FROM login_table where Pass =
$query = "select * from login_table where Pass=password('$password')";
then echo $query to the screen and make sure you see what needs to be there.
Also try mysql_error etc.. from the manual
GL
--ccma
--
PHP General Mail
11 matches
Mail list logo