mysql - php giving strange output -

mysql - php giving strange output -

so after migrating different host, exporting , importing database, fixing links, getting unusual output of php worked fine on previous host.

php connect:

<?php $con = mysql_connect("localhost","dbname_user","password"); mysql_select_db("dbname",$con); if (mysql_connect_errno()) { echo "failed connect mysql: " . mysql_connect_error(); } ?>

php db call:

<?php //print table info $sql = "select * pizzas"; $result = mysql_query($sql,$con); $firstrow = 1; while($row = mysql_fetch_array($result)){ if($row["enabled"] == 1){ if($firstrow == 0){ echo '<tr><td class="spacer">~</td></tr>'; } echo '<tr><td class="title">'.$row['name'].'</td></tr>'; echo '<tr><td class="description">'.$row['description'].'</td></tr>'; if($row['pricemax']){ echo '<tr><td class="price">£'.$row['price'].' - £'.$row['pricemax'].'</td></tr>'; } elseif($row['price']){ echo '<tr><td class="price">£'.$row['price'].'</td></tr>'; } $firstrow = 0; } } ?>

output in html:

'; } echo ''; echo ''; if($row['pricemax']){ echo ''; } elseif($row['price']){ echo ''; } $firstrow = 0; } } ?> ~ '.$row['name'].' '.$row['description'].' £'.$row['price'].' - £'.$row['pricemax'].' £'.$row['price'].'

can decipher going wrong here? have no thought giving unusual output.

edit: fixed create mysql , no mysqli. same output. changed mysql mysqli. no change. included error reporting. no info. if ?php wasn't implemented keyword suggested wouldn't code printed? confusing code beingness read not.

phpinfo:

php logo php version 5.4.26

system linux metro703.hostmetro.com 2.6.32-531.1.2.lve1.2.54.el6.x86_64 #1 smp tue mar 25 07:41:27 edt 2014 x86_64 build date mar 29 2014 04:36:14 configure command './configure' '--disable-fileinfo' '--enable-bcmath' '--enable-calendar' '--enable-exif' '--enable-ftp' '--enable-gd-native-ttf' '--enable-intl' '--enable-libxml' '--enable-mbstring' '--enable-pdo=shared' '--enable-soap' '--enable-sockets' '--enable-wddx' '--enable-zip' '--prefix=/usr/local' '--with-apxs2=/usr/local/apache/bin/apxs' '--with-curl=/opt/curlssl/' '--with-curlwrappers' '--with-enchant=/usr' '--with-freetype-dir=/usr' '--with-gd' '--with-gettext' '--with-icu-dir=/usr' '--with-imap=/opt/php_with_imap_client/' '--with-imap-ssl=/usr' '--with-jpeg-dir=/usr' '--with-kerberos' '--with-libdir=lib64' '--with-libexpat-dir=/usr' '--with-libxml-dir=/opt/xml2' '--with-libxml-dir=/opt/xml2/' '--with-mcrypt=/opt/libmcrypt/' '--with-mm=/opt/mm/' '--with-mysql=/usr' '--with-mysql-sock=/var/lib/mysql/mysql.sock' '--with-mysqli=/usr/bin/mysql_config' '--with-openssl=/usr' '--with-openssl-dir=/usr' '--with-pcre-regex=/opt/pcre' '--with-pdo-mysql=shared' '--with-pdo-sqlite=shared' '--with-pic' '--with-png-dir=/usr' '--with-pspell' '--with-tidy=/opt/tidy/' '--with-xmlrpc' '--with-xpm-dir=/usr' '--with-xsl=/opt/xslt/' '--with-zlib' '--with-zlib-dir=/usr' server api cgi/fastcgi virtual directory back upwards disabled configuration file (php.ini) path /usr/local/lib loaded configuration file /usr/local/lib/php.ini scan dir additional .ini files (none) additional .ini files parsed (none) php api 20100412 php extension 20100525 zend extension 220100525 zend extension build api220100525,nts php extension build api20100525,nts debug build no thread safety disabled zend signal handling disabled zend memory manager enabled zend multibyte back upwards provided mbstring ipv6 back upwards enabled dtrace back upwards disabled registered php streams compress.zlib, dict, ftp, ftps, gopher, http, https, imap, imaps, pop3, pop3s, rtsp, smtp, smtps, telnet, tftp, php, file, glob, data, phar, zip registered stream socket transports tcp, udp, unix, udg, ssl, sslv3, sslv2, tls registered stream filters zlib., convert.iconv., mcrypt., mdecrypt., string.rot13, string.toupper, string.tolower, string.strip_tags, convert.*, consumed, dechunk

zend logo programme makes utilize of zend scripting language engine: zend engine v2.4.0, copyright (c) 1998-2014 zend technologies ioncube php loader v4.4.1, copyright (c) 2002-2013, ioncube ltd., , zend guard loader v3.3, copyright (c) 1998-2013, zend technologies

php credits configuration bcmath bcmath back upwards enabled

directive local value master value bcmath.scale 0 0

calendar calendar back upwards enabled

cgi-fcgi directive local value master value cgi.check_shebang_line 1 1 cgi.discard_path 0 0 cgi.fix_pathinfo 1 1 cgi.force_redirect 1 1 cgi.nph 0 0 cgi.redirect_status_env no value no value cgi.rfc2616_headers 0 0 fastcgi.logging 1 1

core php version 5.4.26

directive local value master value allow_url_fopen on on allow_url_include off off always_populate_raw_post_data off off arg_separator.input & & arg_separator.output & & asp_tags off off auto_append_file no value no value auto_globals_jit on on auto_prepend_file no value no value browscap no value no value default_charset no value no value default_mimetype text/html text/html disable_classes no value no value disable_functions eval,exec,passthru,shell_exec,socket_create,symlink eval,exec,passthru,shell_exec,socket_create,symlink display_errors on on display_startup_errors off off doc_root no value no value docref_ext no value no value docref_root no value no value enable_dl on on enable_post_data_reading on on error_append_string no value no value error_log error_log error_log error_prepend_string no value no value error_reporting 8183 8183 exit_on_timeout off off expose_php on on extension_dir /usr/local/lib/php/extensions/no-debug-non-zts-20100525 /usr/local/lib/php/extensions/no-debug-non-zts-20100525 file_uploads on on highlight.comment #ff8000 #ff8000 highlight.default #0000bb #0000bb highlight.html #000000 #000000 highlight.keyword #007700 #007700 highlight.string #dd0000 #dd0000 html_errors on on ignore_repeated_errors off off ignore_repeated_source off off ignore_user_abort off off implicit_flush off off include_path .:/usr/lib/php:/usr/local/lib/php .:/usr/lib/php:/usr/local/lib/php log_errors on on log_errors_max_len 1024 1024 mail.add_x_header off off mail.force_extra_parameters no value no value mail.log no value no value max_execution_time 30 30 max_file_uploads 20 20 max_input_nesting_level 64 64 max_input_time 60 60 max_input_vars 1000 1000 memory_limit 32m 32m open_basedir no value no value output_buffering no value no value output_handler no value no value post_max_size 8m 8m precision 12 12 realpath_cache_size 16k 16k realpath_cache_ttl 120 120 register_argc_argv on on report_memleaks on on report_zend_debug on on request_order no value no value sendmail_from no value no value sendmail_path /usr/sbin/sendmail -t -i /usr/sbin/sendmail -t -i serialize_precision 100 100 short_open_tag on on smtp localhost localhost smtp_port 25 25 sql.safe_mode off off track_errors off off unserialize_callback_func no value no value upload_max_filesize 20m 20m upload_tmp_dir no value no value user_dir no value no value user_ini.cache_ttl 300 300 user_ini.filename .user.ini .user.ini variables_order egpcs egpcs xmlrpc_error_number 0 0 xmlrpc_errors off off zend.detect_unicode on on zend.enable_gc on on zend.multibyte off off zend.script_encoding no value no value

ctype ctype functions enabled

curl curl back upwards enabled curl info 7.24.0 age 3 features asynchdns no debug no gss-negotiate no idn yes ipv6 yes largefile yes ntlm yes spnego no ssl yes sspi no krb4 no libz yes charconv no protocols dict, file, ftp, ftps, gopher, http, https, imap, imaps, pop3, pop3s, rtsp, smtp, smtps, telnet, tftp host x86_64-unknown-linux-gnu ssl version openssl/1.0.1e zlib version 1.2.3

date date/time back upwards enabled "olson" timezone database version 2013.9 timezone database internal default timezone utc

directive local value master value date.default_latitude 31.7667 31.7667 date.default_longitude 35.2333 35.2333 date.sunrise_zenith 90.583333 90.583333 date.sunset_zenith 90.583333 90.583333 date.timezone utc utc

dom dom/xml enabled dom/xml api version 20031129 libxml version 2.9.0 html back upwards enabled xpath back upwards enabled xpointer back upwards enabled schema back upwards enabled relaxng back upwards enabled

enchant enchant back upwards enabled version 1.1.0 libenchant version 1.5.x revision $id: 6de2feac8047059326b85565067ecdba8fb4f363 $

myspell myspell provider /usr/lib64/enchant/libenchant_myspell.so

ereg regex library bundled library enabled

exif exif back upwards enabled exif version 1.4 $id$ supported exif version 0220 supported filetypes jpeg,tiff

directive local value master value exif.decode_jis_intel jis jis exif.decode_jis_motorola jis jis exif.decode_unicode_intel ucs-2le ucs-2le exif.decode_unicode_motorola ucs-2be ucs-2be exif.encode_jis no value no value exif.encode_unicode iso-8859-15 iso-8859-15

filter input validation , filtering enabled revision $id: ad78b4a085153b8c7f4d6db5dc69df40e969c343 $

directive local value master value filter.default unsafe_raw unsafe_raw filter.default_flags no value no value

ftp ftp back upwards enabled

gd gd back upwards enabled gd version bundled (2.1.0 compatible) freetype back upwards enabled freetype linkage freetype freetype version 2.3.11 gif read back upwards enabled gif create back upwards enabled jpeg back upwards enabled libjpeg version 6b png back upwards enabled libpng version 1.2.49 wbmp back upwards enabled xpm back upwards enabled libxpm version 30411 xbm back upwards enabled

directive local value master value gd.jpeg_ignore_warning 0 0

gettext gettext back upwards enabled

hash hash back upwards enabled hashing engines md2 md4 md5 sha1 sha224 sha256 sha384 sha512 ripemd128 ripemd160 ripemd256 ripemd320 whirlpool tiger128,3 tiger160,3 tiger192,3 tiger128,4 tiger160,4 tiger192,4 snefru snefru256 gost adler32 crc32 crc32b fnv132 fnv164 joaat haval128,3 haval160,3 haval192,3 haval224,3 haval256,3 haval128,4 haval160,4 haval192,4 haval224,4 haval256,4 haval128,5 haval160,5 haval192,5 haval224,5 haval256,5

iconv iconv back upwards enabled iconv implementation glibc iconv library version 2.12

directive local value master value iconv.input_encoding iso-8859-1 iso-8859-1 iconv.internal_encoding iso-8859-1 iso-8859-1 iconv.output_encoding iso-8859-1 iso-8859-1

imap imap c-client version 2007f ssl back upwards enabled kerberos back upwards enabled

intl internationalization back upwards enabled version 1.1.0 icu version 4.2.1

directive local value master value intl.default_locale no value no value intl.error_level 0 0

json json back upwards enabled json version 1.2.1

libxml libxml back upwards active libxml compiled version 2.9.0 libxml loaded version 20900 libxml streams enabled

mbstring multibyte back upwards enabled multibyte string engine libmbfl http input encoding translation disabled libmbfl version 1.3.2

mbstring extension makes utilize of "streamable kanji code filter , converter", distributed under gnu lesser general public license version 2.1.

multibyte (japanese) regex back upwards enabled multibyte regex (oniguruma) backtrack check on multibyte regex (oniguruma) version 4.7.1

directive local value master value mbstring.detect_order no value no value mbstring.encoding_translation off off mbstring.func_overload 0 0 mbstring.http_input pass pass mbstring.http_output pass pass mbstring.http_output_conv_mimetypes ^(text/|application/xhtml+xml) ^(text/|application/xhtml+xml) mbstring.internal_encoding no value no value mbstring.language neutral neutral mbstring.strict_detection off off mbstring.substitute_character no value no value

mcrypt mcrypt back upwards enabled mcrypt_filter back upwards enabled version 2.5.8 api no 20021217 supported ciphers cast-128 gost rijndael-128 twofish arcfour cast-256 loki97 rijndael-192 saferplus wake blowfish-compat des rijndael-256 serpent xtea blowfish enigma rc2 tripledes supported modes cbc cfb ctr ecb ncfb nofb ofb stream

directive local value master value mcrypt.algorithms_dir no value no value mcrypt.modes_dir no value no value

mysql mysql back upwards enabled active persistent links 0 active links 0 client api version 5.5.36 mysql_module_type external mysql_socket /var/lib/mysql/mysql.sock mysql_include -i/usr/include/mysql mysql_libs -l/usr/lib64 -lmysqlclient

directive local value master value mysql.allow_local_infile on on mysql.allow_persistent on on mysql.connect_timeout 60 60 mysql.default_host no value no value mysql.default_password no value no value mysql.default_port no value no value mysql.default_socket /var/lib/mysql/mysql.sock /var/lib/mysql/mysql.sock mysql.default_user no value no value mysql.max_links unlimited unlimited mysql.max_persistent unlimited unlimited mysql.trace_mode off off

mysqli mysqli back upwards enabled client api library version 5.5.36 active persistent links 0 inactive persistent links 0 active links 0 client api header version 5.5.36 mysqli_socket /var/lib/mysql/mysql.sock

directive local value master value mysqli.allow_local_infile on on mysqli.allow_persistent on on mysqli.default_host no value no value mysqli.default_port 3306 3306 mysqli.default_pw no value no value mysqli.default_socket /var/lib/mysql/mysql.sock /var/lib/mysql/mysql.sock mysqli.default_user no value no value mysqli.max_links unlimited unlimited mysqli.max_persistent unlimited unlimited mysqli.reconnect off off

mysqlnd mysqlnd enabled version mysqlnd 5.0.10 - 20111026 - $id: c85105d7c6f7d70d609bb4c000257868a40840ab $ compression supported ssl supported command buffer size 4096 read buffer size 32768 read timeout 31536000 collecting statistics yes collecting memory statistics no tracing n/a loaded plugins mysqlnd,example,debug_trace,auth_plugin_mysql_native_password,auth_plugin_mysql_clear_password api extensions pdo_mysql

mysqlnd statistics bytes_sent 0 bytes_received 0 packets_sent 0 packets_received 0 protocol_overhead_in 0 protocol_overhead_out 0 bytes_received_ok_packet 0 bytes_received_eof_packet 0 bytes_received_rset_header_packet 0 bytes_received_rset_field_meta_packet 0 bytes_received_rset_row_packet 0 bytes_received_prepare_response_packet 0 bytes_received_change_user_packet 0 packets_sent_command 0 packets_received_ok 0 packets_received_eof 0 packets_received_rset_header 0 packets_received_rset_field_meta 0 packets_received_rset_row 0 packets_received_prepare_response 0 packets_received_change_user 0 result_set_queries 0 non_result_set_queries 0 no_index_used 0 bad_index_used 0 slow_queries 0 buffered_sets 0 unbuffered_sets 0 ps_buffered_sets 0 ps_unbuffered_sets 0 flushed_normal_sets 0 flushed_ps_sets 0 ps_prepared_never_executed 0 ps_prepared_once_executed 0 rows_fetched_from_server_normal 0 rows_fetched_from_server_ps 0 rows_buffered_from_client_normal 0 rows_buffered_from_client_ps 0 rows_fetched_from_client_normal_buffered 0 rows_fetched_from_client_normal_unbuffered 0 rows_fetched_from_client_ps_buffered 0 rows_fetched_from_client_ps_unbuffered 0 rows_fetched_from_client_ps_cursor 0 rows_affected_normal 0 rows_affected_ps 0 rows_skipped_normal 0 rows_skipped_ps 0 copy_on_write_saved 0 copy_on_write_performed 0 command_buffer_too_small 0 connect_success 0 connect_failure 0 connection_reused 0 reconnect 0 pconnect_success 0 active_connections 0 active_persistent_connections 0 explicit_close 0 implicit_close 0 disconnect_close 0 in_middle_of_command_close 0 explicit_free_result 0 implicit_free_result 0 explicit_stmt_close 0 implicit_stmt_close 0 mem_emalloc_count 0 mem_emalloc_amount 0 mem_ecalloc_count 0 mem_ecalloc_amount 0 mem_erealloc_count 0 mem_erealloc_amount 0 mem_efree_count 0 mem_efree_amount 0 mem_malloc_count 0 mem_malloc_amount 0 mem_calloc_count 0 mem_calloc_amount 0 mem_realloc_count 0 mem_realloc_amount 0 mem_free_count 0 mem_free_amount 0 mem_estrndup_count 0 mem_strndup_count 0 mem_estndup_count 0 mem_strdup_count 0 proto_text_fetched_null 0 proto_text_fetched_bit 0 proto_text_fetched_tinyint 0 proto_text_fetched_short 0 proto_text_fetched_int24 0 proto_text_fetched_int 0 proto_text_fetched_bigint 0 proto_text_fetched_decimal 0 proto_text_fetched_float 0 proto_text_fetched_double 0 proto_text_fetched_date 0 proto_text_fetched_year 0 proto_text_fetched_time 0 proto_text_fetched_datetime 0 proto_text_fetched_timestamp 0 proto_text_fetched_string 0 proto_text_fetched_blob 0 proto_text_fetched_enum 0 proto_text_fetched_set 0 proto_text_fetched_geometry 0 proto_text_fetched_other 0 proto_binary_fetched_null 0 proto_binary_fetched_bit 0 proto_binary_fetched_tinyint 0 proto_binary_fetched_short 0 proto_binary_fetched_int24 0 proto_binary_fetched_int 0 proto_binary_fetched_bigint 0 proto_binary_fetched_decimal 0 proto_binary_fetched_float 0 proto_binary_fetched_double 0 proto_binary_fetched_date 0 proto_binary_fetched_year 0 proto_binary_fetched_time 0 proto_binary_fetched_datetime 0 proto_binary_fetched_timestamp 0 proto_binary_fetched_string 0 proto_binary_fetched_blob 0 proto_binary_fetched_enum 0 proto_binary_fetched_set 0 proto_binary_fetched_geometry 0 proto_binary_fetched_other 0 init_command_executed_count 0 init_command_failed_count 0 com_quit 0 com_init_db 0 com_query 0 com_field_list 0 com_create_db 0 com_drop_db 0 com_refresh 0 com_shutdown 0 com_statistics 0 com_process_info 0 com_connect 0 com_process_kill 0 com_debug 0 com_ping 0 com_time 0 com_delayed_insert 0 com_change_user 0 com_binlog_dump 0 com_table_dump 0 com_connect_out 0 com_register_slave 0 com_stmt_prepare 0 com_stmt_execute 0 com_stmt_send_long_data 0 com_stmt_close 0 com_stmt_reset 0 com_stmt_set_option 0 com_stmt_fetch 0 com_deamon 0 bytes_received_real_data_normal 0 bytes_received_real_data_ps 0

example statistics stat1 0 stat2 0

openssl openssl back upwards enabled openssl library version openssl 1.0.1e-fips 11 feb 2013 openssl header version openssl 1.0.1e-fips 11 feb 2013

pcre pcre (perl compatible regular expressions) back upwards enabled pcre library version 8.21 2011-12-12

directive local value master value pcre.backtrack_limit 1000000 1000000 pcre.recursion_limit 100000 100000

pdo pdo back upwards enabled pdo drivers sqlite, mysql

pdo_mysql pdo driver mysql enabled client api version mysqlnd 5.0.10 - 20111026 - $id: c85105d7c6f7d70d609bb4c000257868a40840ab $

directive local value master value pdo_mysql.default_socket /var/lib/mysql/mysql.sock /var/lib/mysql/mysql.sock

pdo_sqlite pdo driver sqlite 3.x enabled sqlite library 3.7.7.1

phar phar: php archive back upwards enabled phar ext version 2.0.1 phar api version 1.1.1 svn revision $id: ec823514107160b7e6fabc519594012657a2db91 $ phar-based phar archives enabled tar-based phar archives enabled zip-based phar archives enabled gzip compression enabled bzip2 compression disabled (install pecl/bz2) openssl back upwards enabled

phar based on pear/php_archive, original concept davey shafik. phar realized gregory beaver , marcus boerger. portions of tar implementation copyright (c) 2003-2009 tim kientzle.

directive local value master value phar.cache_list no value no value phar.readonly on on phar.require_hash on on

posix revision $id: 1dfa9997ed76804e53c91e0ce862f3707617b6ed $

pspell pspell back upwards enabled

reflection reflection enabled version $id: f6367cdb4e3f392af4a6d441a6641de87c2e50c4 $

session session back upwards enabled registered save handlers files user mm registered serializer handlers php php_binary wddx

directive local value master value session.auto_start off off session.cache_expire 180 180 session.cache_limiter nocache nocache session.cookie_domain no value no value session.cookie_httponly off off session.cookie_lifetime 0 0 session.cookie_path / / session.cookie_secure off off session.entropy_file no value no value session.entropy_length 0 0 session.gc_divisor 100 100 session.gc_maxlifetime 1440 1440 session.gc_probability 1 1 session.hash_bits_per_character 4 4 session.hash_function 0 0 session.name phpsessid phpsessid session.referer_check no value no value session.save_handler files files session.save_path /tmp /tmp session.serialize_handler php php session.upload_progress.cleanup on on session.upload_progress.enabled on on session.upload_progress.freq 1% 1% session.upload_progress.min_freq 1 1 session.upload_progress.name php_session_upload_progress php_session_upload_progress session.upload_progress.prefix upload_progress_ upload_progress_ session.use_cookies on on session.use_only_cookies on on session.use_trans_sid 0 0

simplexml simplexml back upwards enabled revision $id: b9966ddccead3e8bb7666aae9de01fe3d687b21a $ schema back upwards enabled

soap soap client enabled soap server enabled

directive local value master value soap.wsdl_cache 1 1 soap.wsdl_cache_dir /tmp /tmp soap.wsdl_cache_enabled 1 1 soap.wsdl_cache_limit 5 5 soap.wsdl_cache_ttl 86400 86400

sockets sockets back upwards enabled

spl spl back upwards enabled interfaces countable, outeriterator, recursiveiterator, seekableiterator, splobserver, splsubject classes appenditerator, arrayiterator, arrayobject, badfunctioncallexception, badmethodcallexception, cachingiterator, callbackfilteriterator, directoryiterator, domainexception, emptyiterator, filesystemiterator, filteriterator, globiterator, infiniteiterator, invalidargumentexception, iteratoriterator, lengthexception, limititerator, logicexception, multipleiterator, norewinditerator, outofboundsexception, outofrangeexception, overflowexception, parentiterator, rangeexception, recursivearrayiterator, recursivecachingiterator, recursivecallbackfilteriterator, recursivedirectoryiterator, recursivefilteriterator, recursiveiteratoriterator, recursiveregexiterator, recursivetreeiterator, regexiterator, runtimeexception, spldoublylinkedlist, splfileinfo, splfileobject, splfixedarray, splheap, splminheap, splmaxheap, splobjectstorage, splpriorityqueue, splqueue, splstack, spltempfileobject, underflowexception, unexpectedvalueexception

sqlite3 sqlite3 back upwards enabled sqlite3 module version 0.7 sqlite library 3.7.7.1

directive local value master value sqlite3.extension_dir no value no value

standard dynamic library back upwards enabled path sendmail /usr/sbin/sendmail -t -i

directive local value master value assert.active 1 1 assert.bail 0 0 assert.callback no value no value assert.quiet_eval 0 0 assert.warning 1 1 auto_detect_line_endings 0 0 default_socket_timeout 60 60 no value no value url_rewriter.tags a=href,area=href,frame=src,input=src,form=,fieldset= a=href,area=href,frame=src,input=src,form=,fieldset= user_agent no value no value

tidy tidy back upwards enabled libtidy release 25 march 2009 extension version 2.0 ($id$)

directive local value master value tidy.clean_output 0 0 tidy.default_config no value no value

tokenizer tokenizer back upwards enabled

wddx wddx back upwards enabled wddx session serializer enabled

xml xml back upwards active xml namespace back upwards active expat version expat_2.0.1

xmlreader xmlreader enabled

xmlrpc core library version xmlrpc-epi v. 0.51 php extension version 0.51 author dan libby homepage http://xmlrpc-epi.sourceforge.net open sourced epinions.com

xmlwriter xmlwriter enabled

xsl xsl enabled libxslt version 1.1.27 libxslt compiled against libxml version 2.9.0 exslt enabled libexslt version 1.1.27

zend guard loader zend guard loader enabled license path no value obfuscation level 0

php license

this programme free software; can redistribute and/or modify under terms of php license published php grouping , included in distribution in file: license

this programme distributed in hope useful, without warranty; without implied warranty of merchantability or fitness particular purpose.

if did not receive re-create of php license, or have questions php licensing, please contact license@php.net.

you using mysqli_connect , querying table mysql_query. wrong. please utilize mysqli_query , mysqli_fetch_array

query should become:

$result = mysqli_query($con, $sql);

fetching records

while($row = mysqli_fetch_array($result)){

php mysql