nzorb
-
Posts
7 -
Joined
-
Last visited
Never
nzorb's Achievements
Newbie (1/5)
0
Reputation
-
mysql_fetch_array needs refference and not boolean warning
nzorb replied to nzorb's topic in PHP Coding Help
*goes in the corner and shoots his face off* yup it should :S tnx -
mysql_fetch_array needs refference and not boolean warning
nzorb replied to nzorb's topic in PHP Coding Help
tnx ken that seems to fix the error but $row is still null the sql query should be correct cause I'm running it over in mysql admin and returns the one line it should. -
mysql_fetch_array needs refference and not boolean warning
nzorb replied to nzorb's topic in PHP Coding Help
the result should be fine, if by checking you mean something simple like this: if ($result=mysql_query("SELECT I.ITEM_ID AS ID,I.DESCR AS DESCR,W.QUANTITY AS QUANT,W.PRICE AS PRICE FROM ITEM I JOIN WANTS_TO_BUY W ON I.ITEM_ID=W.ITEM_ID JOIN USER U ON U.USERNAME=W.USERNAME WHERE U.USERNAME='%id'")) $row=mysql_fetch_array($result); else echo 'error'; I've done that and get the same error. PS: tnx for moving it, I wasn't sure where it belonged, it has a bit of both. -
I've got this and it gives me that warning. Row is null before and after the command. What am I doing wrong? $row=mysql_fetch_array(mysql_query("SELECT I.ITEM_ID AS ID,I.DESCR AS DESCR,W.QUANTITY AS QUANT,W.PRICE AS PRICE FROM ITEM I JOIN WANTS_TO_BUY W ON I.ITEM_ID=W.ITEM_ID JOIN USER U ON U.USERNAME=W.USERNAME WHERE U.USERNAME='%id'")); (I also posted this in php help cause I'm not sure where it belongs, please tell me so I can delete the wrong post)
-
wow tnx for the fast replies all! So all I have to do is set up a server with php support and throw the files there (even if 'there' is just my pc), sounds like a stupidly hard way to run a simple site but I guess there's a logical explanation behind it that I'll understand at some point tnx again I think this thread should be considered solved!
-
Ok first of all I want to apologize for asking what I'm about to ask. I understand it should be some stupidly easy to find mistake but considering the fact I have to send the code tomorrow leaves me with little to no time to try and find the solution so I'll be asking here and hope that by the time I wake up tomorrow an answer will be here and I'll be able to resume scripting. So my problem is that I just can't find how to make php commands run at all. I tried just randomly inserting them into my html code then found out it needs a separate file. So I created the basic.php with this code: <html> <body> <?php echo "Hello World"; ?> <div>adgaeganerhaohn</div> </body> </html> tried opening it through a form in my html code but it wouldn't print the Hello world line, then I tried running it straight into firefox but I only got adgaeganerhaohn again (without that line I get a white page) So I need to know what am I doing wrong? I have php5.301 installed with default options (no server). thanks for your help beforehand, once I get a bit more into php I'll be coming back with serious questions but for now I really need someone to tell me how php is supposed to work and what I'm doing wrong