[snip]
$sql = "SELECT `User_name` AND `User_pass` FROM `user` WHERE `User_name`
= '$_POST['user_id']' AND '$_POST['user_id']' ";
[/snip]
echo $sql; //to see the query and check the syntax
$sql = "SELECT `User_name` AND `User_pass` FROM `user` WHERE `User_name`
= '" . $_POST['user_id'] . "' AND
to:[EMAIL PROTECTED]
Sent: 23 May 2005 09:01
To: php-general@lists.php.net
Subject: [PHP] Php with mysql
Hi friends,
I am Rittwick Banerjee
Some one gave me an idea about that past php code that is :
$sql = "SELECT `User_name` AND `User_pass` FROM
`user`
WHERE `User
ELECT `User_name` , (replaces AND) `User_pass` FROM `user`
WHERE `User_name` = '$_POST['user_id']' AND '$_POST['user_id']'
-Original Message-
From: Rittwick Banerjee [mailto:[EMAIL PROTECTED]
Sent: 23 May 2005 09:01
To: php-general@lists.php.net
Subj
Hi friends,
I am Rittwick Banerjee
Some one gave me an idea about that past php code that is :
$sql = "SELECT `User_name` AND `User_pass` FROM `user`
WHERE `User_name` = '$_POST['user_id']' AND '$_POST['user_id']' ";
but I found that it still not working ...
Plaese give m
[snip]
Regarding to php with mysql , if the php with mysql implement data
manipulating like (insert , update , delete ..etc) or just implement the
query operation only ??.
[/snip]
You can do any SQL operation with PHP and MySQL.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, vi
Hi ,
Regarding to php with mysql , if the php with mysql implement data manipulating like
(insert , update , delete ..etc) or just implement the query operation only ??.
Best Regards,,
ayman amin
Egypt - Cairo
:
> Try this:
>
> "SELECT COUNT(*), order_number FROM " . $prefix .
> "_purchases GROUP BY
> order_number"
>
> as your query.
>
> Shaunak
>
> - Original Message -
> From: "Ryan A" <[EMAIL PROTECTED]>
> To: <[EMAIL P
Try this:
"SELECT COUNT(*), order_number FROM " . $prefix . "_purchases GROUP BY
order_number"
as your query.
Shaunak
- Original Message -
From: "Ryan A" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, February 09, 2004 8:36 PM
Sub
Hi,
I have a table where a users details are entered for the products he bought,
the only part that is repeated is the order_id,
I basically need to only get the order per person, and paginate for all the
customers
eg:
if user "tom" bought 3 items in the database it would be entered as:
order_id
Ok. Then the second message was even more idiotic. Damn! :)
Bogdan
Miguel Cruz wrote:
>Your message? Actually you're right. I just noticed in the manual:
>
> The simple form user is a synonym for user@"%".
>
>miguel
>
>On Fri, 3 May 2002, Bogdan Stancescu wrote:
>
>>Um. Sorry. That was idiot
Your message? Actually you're right. I just noticed in the manual:
The simple form user is a synonym for user@"%".
miguel
On Fri, 3 May 2002, Bogdan Stancescu wrote:
> Um. Sorry. That was idiotic.
>
> Bogdan
>
> Bogdan Stancescu wrote:
>
> > You can simply grant username instead of usern
Um. Sorry. That was idiotic.
Bogdan
Bogdan Stancescu wrote:
> You can simply grant username instead of username@machine.
>
> Bogdan
>
> Paras Mukadam wrote:
>
>> Hi Gurus,
>> one MySQL - PHP query : while granting permissions to particular user in
>> MySQL, the administrator has to give usernam
On Thu, 2 May 2002, Paras Mukadam wrote:
> one MySQL - PHP query : while granting permissions to particular user in
> MySQL, the administrator has to give username@machine_address !! Then how
> can we connect to MySQL through PHP only by passing "username" as one of the
> arguments to mysql_connec
You can simply grant username instead of username@machine.
Bogdan
Paras Mukadam wrote:
>Hi Gurus,
>one MySQL - PHP query : while granting permissions to particular user in
>MySQL, the administrator has to give username@machine_address !! Then how
>can we connect to MySQL through PHP only by pas
essage-
> From: Paras Mukadam [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 02, 2002 12:46 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP] PHP with MySQL
>
> Hi Gurus,
> one MySQL - PHP query : while granting permissions to particular user
in
> MySQL, the administrator has to giv
Hi Gurus,
one MySQL - PHP query : while granting permissions to particular user in
MySQL, the administrator has to give username@machine_address !! Then how
can we connect to MySQL through PHP only by passing "username" as one of the
arguments to mysql_connect() ?
Thanks.
Paras.
--
PHP Genera
Pablo Pasqualino <[EMAIL PROTECTED]>
Newsgroups: php.general
Sent: Friday, March 02, 2001 9:43 PM
Subject: [PHP] PHP with MySQL doubt
> Hi
>
> I have an account on a hosting service provider.
>
> They have a server with a lot of clients... and there, each client has his
own
>
Hi
I have an account on a hosting service provider.
They have a server with a lot of clients... and there, each client has his own
Apache binary compiled with PHP 4.
They also offer MySQL... but they only have ONE server for all their customers,
and so, they just offer one db to each one.
I ne
18 matches
Mail list logo
