[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
(posted again with another syntax error corrected)
This is a beginner's guide to SQL syntax, please review it
http://www.webdevelopersnotes.com/tutorials/sql/mysql_guide_querying_mys
ql_tables.php3?PHPSESSID=fb6c7c7a548b6a271a75d623ce04cc9c
The answer to your question (which someone has already g
This is a beginner's guide to SQL syntax, please review it
http://www.webdevelopersnotes.com/tutorials/sql/mysql_guide_querying_mys
ql_tables.php3?PHPSESSID=fb6c7c7a548b6a271a75d623ce04cc9c
The answer to your question (which someone has already given in a
previous reply to you) is
SELECT `User_n
[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
Hey,
Thanks for replying.
Nope, that didnt work, but i modified my search terms on google and kept on
trying with different search terms and got the solution here:
http://dbforums.com/arch/230/2002/11/623223
Cheers,
-Ryan
On 2/10/2004 3:14:21 AM, Shaunak Kashyap ([EMAIL PROTECTED])
wrote:
> Try
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
Subject: [PHP] php with mysql COUNT, DISTINCT sy
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
mysql_connect("host","username","password");
If there is no password, leave it blank. "host" is the name or IP
address of the MySQL server. Set it to localhost if it's on the same
machine as the script.
---John Holmes...
> -Original Message-
> From: Paras Mukadam [mailto:[EMAIL PROTECTE
You're done.
Just add the port into your mysql_connect function.
--
Visit the Zend Store at http://www.zend.com/store/
Wanna help me out? Like Music? Buy a CD: http://l-i-e.com/artists.htm
Volunteer a little time: http://chatmusic.com/volunteer.htm
- Original Message -
From: Pablo Pasq
13 matches
Mail list logo
