MySQL and PHP display error -


Hello IEM is new under MySQL and PHP training, please tell me where is wrong

My The problem occurs when Ad01 and ad03 they are doing the echo here but ad02 echo properly

   & Lt; Title & gt; Download link & lt; / Title & gt; & Lt; Link href = "css / style.css" rel = "stylesheet" type = "text / css" /> & Lt; / Head & gt; & Lt; Body & gt; & Lt; Div class = "wrapper" & gt; & Lt; Div class = "ad01" & gt; & Lt ;? Php if ($ row_advtDisplay ['adv-no'] == 'ad01') {echo $ row_advtDisplay ['adv-content']; } And {echo "advertise here";}? & Gt; & Lt; / Div & gt; & Lt; Div class = "middlebox" & gt; & Lt; Div class = "ad02" & gt; & Lt ;? Php if ($ row_advtDisplay ['adv-no'] == 'ad02') {echo $ row_advtDisplay ['advt-content']; } And {echo "advertise here";}? & Gt; & Lt; / Div & gt; & Lt; Div class = "linkbox" & gt; & Lt; P & gt; Download link & lt; / P & gt; & Lt; Ul & gt; & Lt; Li & gt; & Lt; A href = "#" & gt; Link 01 & lt; / A & gt; & Lt; / Li & gt; & Lt; Li & gt; & Lt; A href = "#" & gt; Link 02 & lt; / A & gt; & Lt; / Li & gt; & Lt; Li & gt; & Lt; A href = "#" & gt; Link 03 & lt; / A & gt; & Lt; / Li & gt; & Lt; Li & gt; & Lt; A href = "#" & gt; Link 04 & lt; / A & gt; & Lt; / Li & gt; & Lt; Li & gt; & Lt; A href = "#" & gt; Link 05 & lt; / A & gt; & Lt; / Li & gt; & Lt; / Ul & gt; & Lt; Ul & gt; & Lt; Li & gt; & Lt; A href = "#" & gt; Link 06 & lt; / A & gt; & Lt; / Li & gt; & Lt; Li & gt; & Lt; A href = "#" & gt; Link 07 & lt; / A & gt; & Lt; / Li & gt; & Lt; Li & gt; & Lt; A href = "#" & gt; Link 08 & lt; / A & gt; & Lt; / Li & gt; & Lt; Li & gt; & Lt; A href = "#" & gt; Link 09 & lt; / A & gt; & Lt; / Li & gt; & Lt; Li & gt; & Lt; A href = "#" & gt; Link 10 & lt; / A & gt; & Lt; / Li & gt; & Lt; / Ul & gt; & Lt; Ul & gt; & Lt; Li & gt; & Lt; A href = "#" target = "_ blank" & gt; Link 11 & lt; / A & gt; & Lt; / Li & gt; & Lt; Li & gt; & Lt; A href = "#" target = "_ blank" & gt; Link 12 & lt; / A & gt; & Lt; / Li & gt; & Lt; Li & gt; & Lt; A href = "#" target = "_ blank" & gt; Link 13 & lt; / A & gt; & Lt; / Li & gt; & Lt; Li & gt; & Lt; A href = "#" target = "_ blank" & gt; Link 14 & lt; / A & gt; & Lt; / Li & gt; & Lt; Li & gt; & Lt; A href = "#" target = "_ blank" & gt; Link 15 & lt; / A & gt; & Lt; / Li & gt; & Lt; / Ul & gt; & Lt; / Div & gt; & Lt; Div class = "passwordbox" & gt; & Lt; P & gt; RAR Password & lt; / P & gt; & Lt; / Div & gt; & Lt; / Div & gt; & Lt; Div class = "ad03" & gt; & Lt ;? Php if ($ row_advtDisplay ['adv-no'] == 'ad03') {echo $ row_advtDisplay ['advt-content']; } And {echo "advertise here";}? & Gt; & Lt; / Div & gt; & Lt; Div class = "clear" & gt; & Lt; / Div & gt; & Lt; / Div & gt; & Lt; / Body & gt; & Lt; / Html & gt; & Lt ;? Php mysql_free_result ($ advtDisplay); ? & Gt;   

only ad02 does not properly display ad01 and ad03 No problems with tables only coding problem sorry for bad english

Only one line will ever return ... so that you need a loop to see all your data. $ just_one_row = mysql_fetch_assoc ($ advtDisplay); // How to loop through all rows ($ line = mysql_fetch_assoc ($ advtDisplay)) {echo $ line ["advice-no"]; Echo ["Advait-content"] per line; } // Maybe do something like this ... $ mydata = array (); While ($ line = mysql_fetch_assoc ($ advtDisplay)) {$ mydata [$ row ['adv-no']] = $ line ['ad-content']; }

  & lt ;! - and then - & gt; & Lt; Div class = "ad01" & gt; & Lt ;? Php if (isset ($ mydata ['ad01']) & amp; nbsp; ($ mydata ['ad01'])) {echo $ mydata ['ad01']; } Else {echo "advertise here"; }? & Gt; & Lt; / Div & gt;   

And let me say ... you really should use or

Comments

Popular posts from this blog

java - ImportError: No module named py4j.java_gateway -

python - Receiving "KeyError" after decoding json result from url -

.net - Creating a new Queue Manager and Queue in Websphere MQ (using C#) -