Search found 3 matches

by anthor
Tue Jun 23, 2009 4:04 pm
Forum: PHP - Code
Topic: INSERT and SELECT SQL statement
Replies: 3
Views: 129

Re: INSERT and SELECT SQL statement

oh god ! it is what i want ! i never seen this kind of SQL statement..oh thanks man !
i dont understand the statement meaning man,can explain please?

Code: Select all

SELECT '%s', itemid FROM cart WHERE orderby = %s
this is hard man
by anthor
Tue Jun 23, 2009 3:36 pm
Forum: PHP - Code
Topic: INSERT and SELECT SQL statement
Replies: 3
Views: 129

INSERT and SELECT SQL statement

$query_rs_orderid = sprintf("INSERT INTO order_list (order_by,status,order_date)VALUES('%s',1,now())", $userid); $rs_orderid = mysql_query($query_rs_orderid, $Conn) or die(mysql_error());   $query_rs_post = sprintf("INSERT INTO order_item (order_id,item_id)VALUES(%s) SELECT itemid FR...
by anthor
Sun Jun 14, 2009 3:16 pm
Forum: PHP - Code
Topic: php header location couldn't jump to correct page
Replies: 2
Views: 224

php header location couldn't jump to correct page

<?php if (isset($_POST['login'])){ require_once('Connections/Conn.php'); mysql_select_db($database_Conn, $Conn); $username = $_POST['username']; $password = $_POST['password']; $query_rs_post = sprintf("SELECT * FROM web_user WHERE username='%s' AND password='%s'",$username,$password); $r...